Running macros & stuff

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have two questions. First, I am running a macro that runs various action
queries. When i run the queries they display the usual "You are about to
append...." messages. How do I bypass that set of messages?

When designing a query are there keystrokes to run the query and return to
design view?

Thanks
Joe
 
If you were running the action queries using VBA, you could use
DoCmd.SetWarnings - look that up in F1 help.

I recommend that you avoid macros, and use VBA instead. VBA has much
better features for standard programming needs such as, loops, error
handling, debugging, and so on.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Joe,

DoCmd.SetWarnings False
or just set warnings false in a macro. Don't forget to also add a
setwarnings true when you're done running the queries.

You can run a query in design view by pressing the exclamation point button
on the toolbar. I don't think there are shortcut keys for that.

HTH,
Josh
 
In the first line of the macro select SetWarnings and make sure that the
Warnings On says No
 
Back
Top