Running macros & stuff

[Joe C]

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

 

[TC]

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

 

[Joshua A. Booker]

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

 

[jahoobob via AccessMonster.com]

In the first line of the macro select SetWarnings and make sure that the
Warnings On says No

 

[Joe C]

TC,

I don't know VBA. Any suggested tutorials?

JC

 

[TC]

The "Access Developers' Handbook" is an acknowledged reference; try
that.

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