prompts

  • Thread starter Thread starter Susie
  • Start date Start date
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
 
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>
 
Back
Top