access macros

  • Thread starter sierralightfoot
  • Start date
S

sierralightfoot

I'm pretty good at this access stuff but a simple Macro has me stumped:
I have a number of append queries to run.
They append to the same table.
I want to run these queries. (I cant get these to run)
Any where from one to three screens come up requesting yes or no answers.
I want to answer Yes to these screens to finish each append.
 
D

Douglas J. Steele

Do you really want to answer yes, or is your desire not to have the messages
appear at all?

To prevent them from happening, issue SetWarnings False before you run the
queries, SetWarnings True after they've run.
 

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

Adding data to MS Access from csv file 0
Append Queries in a Macro 6
Getting Radio Buttons to work, that are inserted via AutoText 0
Yes/No pop-up 1
Can I edit macro buttons on the quick access toolbar in excel? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
WORD VBA Search and switch to advanced ... 1
Converting URLs in comments to Markdown-formatted links 2

Top