Annoyances.org
Home » Windows XP Discussion Forum » Message 1068057012 » Entire Thread Search | Help | Home
  
Auto Yes when running macros in Access?
Showing all messages in thread #1068057012
Windows XP Annoyances Discussion Forum


The following are all of the messages in this thread (2 in all), shown in chronological order. Click any message subject to view that message by itself or to view the thread hierarchy.
Auto Yes when running macros in Access?
Wednesday, November 5, 2003 at 10:30 am
Posted by Zak (24 messages posted)

Hello, I have some huge macros which take hours to complete. These macros have numerous warning/confirmation messages requiring a "Yes" click before macro will continue. Is there a way to disable messages or automatically select yes whenever a confirmation message pops up? Thanks, Zak

[Reply or follow-up to this message]

Tip: Run a free scan for common Windows errors ad

re: Auto Yes when running macros in Access?
Wednesday, November 5, 2003 at 10:56 am
Posted by Ricer46 (20448 messages posted)

Add a SetWarnings to of statement to the begiining of the macro, be sure to turn 
them back on at the end.

Macros are a pretty poor way to program in Access, should use VB modules.





On Wednesday, November 5, 2003 at 10:30 am, Zak wrote: >Hello, > >I have some huge macros which take hours to complete. >These macros have numerous warning/confirmation messages requiring a "Yes" click >before macro will continue. >Is there a way to disable messages or automatically select yes whenever a confirmation >message pops up? > >Thanks, >Zak

[Reply or follow-up to this message]

Tip: Use one of the [Reply or follow-up to this message] links above to add a message to this thread
Return to the Windows XP Discussion Forum


All content at Annoyances.org is Copyright © 1995-2008 Creative Elementtm All rights reserved.
Please do not plagiarize; redistributing these pages without permission is strictly prohibited.