Run A Query with a Macro in MS Access

[Love Buzz]

I have a really easy question, I think anyway.

I have several update queries that I would like to run with one macro.
However, I only see the 'open' and 'close' Actions under the Macro template.

Is there a way to run several update queries with one macro w/o opening the
query?

Hope that made sense...thanks for your help.

 

[KARL DEWEY]

Just use the OpenQuery action. Add a new action entry for each query.

You might want to turn off warnings as first action and on again as last
action.

 

[Guest]

I am new in useing MP4's and I just got a new dell lap top with windows
vista.I need to know are they compatable with each other or do I need to
down load a patch?

 

[John W. Vinson]

I am new in useing MP4's and I just got a new dell lap top with windows
vista.I need to know are they compatable with each other or do I need to
down load a patch?

I would suggest you post in a more appropriate newsgroup. This one is for the
database software Microsoft Access - not for general Windows questions.

John W. Vinson [MVP]

 

[Guest]

I am new in useing MP4's and I just got a new dell lap top with windows
vista.I need to know are they compatable with each other or do I need to
down load a patch?

 

[Love Buzz]

Thanks Karl. I didn't think it would be that easy.

Is there a way to bypass the 'are you sure' messages so that the update
query runs with just a selection of the macro?

Thanks for your help.

 

[KARL DEWEY]

Make your first action Set Warnings - Off.
Make last action Set Warnings - On.

 

[Steven Chicago,Illinois]

Karl,

I am setting the warnings off and then back on again at the end of the
Event. And I am very happy with the warning messages not popping up, as I
know it would confuse the end-user. But is there a way to allow(code) to see
more severe messages? Like a error message when the user is trying to add
duplicate records? I am wondering if there are a few select messages that we
really do want to see, and that access considers them just warnings, while
some of us would consider them error messages (duplicate keys, etc..). I have
been searching help and the discussion group to see if there are any
options/message severity levels that we can opt for when turning off
messages. I am worried that access may consider my query to copy a table to a
backup table name, that fails a warning message and then continue in the
event/or macro to execute the next query and update my table, and then clear
out my input table source. And I think you can see what I am trying to say...
Maybe I don't understand the difference between a warning and a error?