Topics Search

RunSQL Macro Action

RunSQL Macro Action
Views: 241
You can use the RunSQL action to run a Microsoft Office Access 2007 action query by using the corresponding SQL statement. You can also run a data-definition query.
Sponsored Links:

More topics

 

RunSQL statement

Preview
Can anybody tell me why this SQL statement won't run in in the RunSQL macro action.

SELECT Open_Issues.* FROM Open_Issues WHERE ((Open_Issues.Account_No)=(Forms.Open_Issues_Viewe r.Text64));

It tells me that the RunSQL action must have an SQL statement for an arguement when I try to run the macro. I thought that was a perfectly valid SQL statement considering I checked it with a query
 

Hourglass Macro Action

Preview
You can use the Hourglass action to change the mouse pointer to an image of an hourglass (or another icon you've chosen) while a macro is running. This action can provide a visual indication that the macro is running. This is especially useful when a macro action or the macro itself takes a long time to run.
 

RunMacro Macro Action

Preview
You can use the RunMacro action to run a macro. The macro can be in a macro group.
You can use this action:
-To run a macro from within another macro.
-To run a macro based on a certain condition.
-To attach a macro to a custom menu command.
 

CancelEvent Macro Action

Preview
You can use the CancelEvent action to cancel the event that caused Microsoft Office Access 2007 to run the macro containing this action. The macro name is the setting of an event property such as BeforeUpdate, OnOpen, OnUnload, or OnPrint.
 

Pause a macro

Preview
Is there a way to insert an action (or action arguments) to pause a macro action for X amount of seconds before performing the action
 

PrintOut action

Preview
I'm trying to create a macro that will print out 5 reports. I know how to OPEN 5 reports with a macro, with the OpenReport action, but I want to print them. The PrintOut action is not in the drop down list of usable actions in the Macro design view, though.
 

Transfertext action missing in Macro

Preview
I am creating an import macro in Access 2007 and do not have a TransferText action option. My last Action is StopMacro. Do you think it's an installation issue or is there something else I have to download to get that action back? I used it many times in 2003 and researched and found that it's supposed to be in 2007 and can't find anyone else with this problem.
 

SingleStep Macro Action

Preview
You can use the SingleStep action to pause macro execution and open the Macro Single Step dialog box.
 

Getting to Know Macros

Preview
You can easily add conditions (which make the macro run only under specific criteria) to your macros. You apply a condition to a certain action in the macro sheet and when you run the macro, if the condition is not met, the action is skipped and the next action in the sequence is run. You can make conditions apply to multiple sequential actions by putting an ellipsis() in the next action's Condition column.
 

Error handling macros 2010

Preview
I am following the documention in the Help file for Access 2010 (which by the way, the icons they referece here etc don't seem to match what's on screen).

I selected Help, Data Macros, Create Macro and then jumped to the section titled, Debug a Macro, Use the OnError Action.

This section suggests that you create a named Error-handling macro, which I did following their instructions.

Then it suggests you add an OnError action to a data macro. They use the after instert macro for a table in their example, so I did the same. They suggest you drag an OnError action to the screen which I did. On their screen this action has two sections
Macro Name

On my Screen, however, there is only a GoTo field. Is this because these instructions are out dated? Why do their instructions not match what I see on screen. I have a macro I want the onError to go to but I am left to wonder how to tell it so.