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.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"sierralightfoot" <sierralightfoot[ at ]discussions.microsoft.com> wrote in
message news:EC805C3F-BFBD-41CC-80F9-F308C8E9E57B[ at ]microsoft.com...
[Quoted Text] > 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.
|