Update Queries 2

[bikerboy718]

Is there a way to run multilpe update queries in one step, instead of running each query individually?

With Great Power Comes Great Responsibility!!!

Michael

 

[PaultheS]

Take a look at Macros.

 

[mp9]

Easiest way in my view is to write all your separate queries, then either write a macro or VBA function (preferred, in my book) to run all your queries.

This way, your one step is just to run the macro or call the function.

http://www22.brinkster.com/accessory/

 

[bikerboy718]

How do i execute a query from a macro in Access?

With Great Power Comes Great Responsibility!!!

Michael

 

[PaultheS]

Also, whether you choose to use a macro or VBA, consider using SetWarnings if you don't want to have to keep clicking "OK" to run the queries.

 

[mp9]

In a Macro, use the 'OpenQuery' action.

http://www22.brinkster.com/accessory/

 

[bikerboy718]

How would you go about using setwarnings if i use the macro to run the queries?

With Great Power Comes Great Responsibility!!!

Michael

 

[bikerboy718]

Nevermind. I figured it out. Thanks for the help!!!

With Great Power Comes Great Responsibility!!!

Michael