| | |
|
|
|
prompts |
|---|
| message from Susie on 10 May 2004 |
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
|
| Cheryl Fischer replied to Susie on 10 May 2004 |
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>
|
|
Archived message: prompts (MS Access Forms)
