Using a macro to run an update querey

A

Access WannaBe

I am having trouble getting a macro to run a query if there is any other
action in the macro.

I am trying to run an update query with out seeing the warnings. If I use
setwarings/on to ‘no’ the query doesn't run. If I eliminate the warning
action the query runs.

I first wanted to run two queries at the same time, and when they didn't
work I started eliminating actions until I found the problem. My append
query works fine with the warnings turned off.

Any help is much appreciated.

Chad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why are my Update Queries not working from my Macro? 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
warnings help 2
Need to know number of rows pasted 1
Append Queries in a Macro 6
Macro: VBA code to move/forward email based on subjects and attachments 0
Hide Message in Action queries 7
Run Macros to update data 4

Top