prompts

S

Susie

A couple of related things...I have a macro that runs when
I open the database that appends a query. When I open the
database, I get prompts telling me I am about to append a
table, is this OK. I also have a query that runs daily
reports and replaces files that are downloaded daily to
our intranet site. I also get prompted on each report
asking if I would like to replace the file. Is there a
simple way to get rid of these prompts. No big deal, just
a little annoying.

Thank you in advance for you help...Susie
 
C

Cheryl Fischer

In VBA code ...

DoCmd.SetWarnings False
<your code>
DoCmd.SetWarnings True

In a Macro Action:
SetWarnings <set Warnings On property to 'No'>
<other macro actions>
SetWarnings <set Warnings On property to 'Yes'e>
 
Top