Would i use a macro for this????

[daherb]

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

 

[FoFa]

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

 

[daherb]

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.