G
Guest
when using an append query in a macro, how can you hide the alerts or dialog
boxes or make them automatically click yes
boxes or make them automatically click yes
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
For first action use Warnings - Off. Then for last use Warnings - On.
S
Steve Schapel
Desiree,
Put a SetWarnings/No action in your macro before the first OpenQuery action.
Put a SetWarnings/No action in your macro before the first OpenQuery action.
G
Guest
Can you please put that in "stupid user" terms? I have been using macro's
sporatically and am currently drawing a blank on how to translate your
response. Thanks in advance for your patience.
sporatically and am currently drawing a blank on how to translate your
response. Thanks in advance for your patience.
G
Guest
See Steve Schapel's response.
C
chuckHRC via AccessMonster.com
Desiree- Whenever you "turn off" system warnings, as has been correctly
suggested, it's also a good practice to create your own error handling. You
might want to put a DCount statement as a condition one line below the append
query in the same macro to validate the record was added to your table and
have the condition=true fire your own message box, then set warnings back on.
The last thing you want is for a user to "think" a record appended when it
really didn't (they wouldn't know BECAUSE the warnings were turned off!) ...
just a thought from someone that's written several proprietary Access
applications.
suggested, it's also a good practice to create your own error handling. You
might want to put a DCount statement as a condition one line below the append
query in the same macro to validate the record was added to your table and
have the condition=true fire your own message box, then set warnings back on.
The last thing you want is for a user to "think" a record appended when it
really didn't (they wouldn't know BECAUSE the warnings were turned off!) ...
just a thought from someone that's written several proprietary Access
applications.