Removing Prompts

M_Mike

Registered User.
Local time
Today, 16:18
Joined
Aug 10, 2005
Messages
31
Can anyone please help me, I currently have a series of queries that are called by a macro, these create a number of tables. But when each query runs it provide a prompt stating what it is doing, my question is can these be stopped so that the queries run without a user being present.

Thanks
 
macros

In the macro use the setwarnings to off. Also, make sure your Save in the macro is set to Yes.
Hope this helps
 
after you have finished you ought to setwarnings true again. otherwise you could accidentally delete/change data etc without realising it
 
Thanks for the help, that done the trick.
 

Users who are viewing this thread

Back
Top Bottom