Stopping a macro based Setwarning diag box
in [General]
|
Prev: Navigation Pane/Database Window...whatever it is now!!!
Next: How do I delete an unwanted table in Access?
From: AB1 on 6 Apr 2010 12:01 I have created a Macro that includes a spreadsheet transfer and append. My SetWarnings is Yes. However, I noticed that when I get the dialog box indicating what I am about to do and ask if I am sure I want to run this query, I select no but the macro continues anyway. How can I get the Macro to stop running?
From: Tom Wickerath AOS168b AT comcast DOT on 7 Apr 2010 01:51 Hi AB1, Sounds to me like it's time to make the move away from macros to VBA code. This is very easy to do with a little VBA code. The same thing applies for your follow-on question "SetWarning in macro". Perhaps this document will be helpful: http://www.accessmvp.com/TWickerath/downloads/ActionQueryExamplesWithSetWarnings.doc Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ __________________________________________ "AB1" wrote: > I have created a Macro that includes a spreadsheet transfer and append. My > SetWarnings is Yes. However, I noticed that when I get the dialog box > indicating what I am about to do and ask if I am sure I want to run this > query, I select no but the macro continues anyway. How can I get the Macro > to stop running?
From: Allen Browne on 6 Apr 2010 22:16
Answered in your post 30 minutes later. |