Suppressing Yes No Prompts 1

[duncanmc]

Hi Everyone,

In Access 2000 I'm trying to run a macro which runs three queries, one to delete the existing data in a table, and two which appends data from two other tables.

However when this query is run I get the usual prompts warning me about deleting and appending data with the Yes No buttons.

I'd like this to run seemlessly in the background otherwise it will look pants for the user. Any ideas?

 

[PHV]

Have a look at SetWarnings

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[duncanmc]

Thanks for this info, you replied with in minutes and your suggestion worked first time. Really please