Would i use a macro for this????

daherb

Registered User.
Local time
Today, 17:42
Joined
Sep 14, 2005
Messages
66
Hi, i am currently designing a simple database for work and it has been a while since i have done one (about 3 years in fact) and i was wondering if it is a macro that i need to use in order to solve my problem.

Basically i have about 6 update queries that i want to run by clicking a command button inside a form. do i need a macro for this and if so how would i go about writing the macro (i.e what would be the commands to use)

please help

thanks in advance
 
A macro would be simple for this:
If these/any are update queries, then a SETWARNINGS OFF is a good start, followed by OPENQUERY for each query ending with a SETWARNINGS ON
 
thanks for the fast response i managed to get the macro built but i forgot all about the setwarnings, thanks for that it saves me alot of time not having to confirm each update query action.
 

Users who are viewing this thread

Back
Top Bottom