|
Home > Archive > Application Center Usage > February 2004 > MS Access: How to disable warning msgs for automatic macros
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MS Access: How to disable warning msgs for automatic macros
|
|
| Larry Clifford 2004-02-08, 8:45 am |
| I want to run some MS Access macros with no user
intervention, specifically a delete operation on a large
Access table (>20,000 records).
When I run the macro I get the following message "You
won't be able to undo this Delete operation. The undo
command won't be available because this operation is too
large, or there isn't enough free memory. Do you want to
delete these items?"
When I manually answer yes the delete operation procedes
successfully, but I don't want the operation to have to
wait for a response.
Does anybody know how to delete these messages? I have
already turned of the display of alerts on the Office
Assitant dialog box and this has not helped.
Thanks, Larry
| |
| Susan Hayden [MS] 2004-02-08, 8:45 am |
| Larry,
In your macro you need to set warning false so if you macro is running a
query for example, the steps in the macro should be
action arguments
========= =========
set warning no
run query query1
set warning yes
This should keep the dialog from popping up.
Susan Hayden[MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to newsgroups only.
|
|
|
|
|