Results 1 to 2 of 2
  1. 11-17-2011, 05:46 PM #1
    stevepcne
    stevepcne is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2011
    Location
    Boston, Ma.
    Posts
    23

    macro: rapid firing of update queries


    Hi, Can anyone tell me how I can make a macro to say yes to about 50 update queries?
    Reply With Quote Reply With Quote
  2. 11-17-2011, 05:55 PM #2
    boblarson
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    If you are using macros, then use

    ACTION: SETWARNINGS
    VALUE: NO

    and then at the end use the same but with YES.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. help needed Queries to a new table with a macro
    By cslr in forum Queries
    Replies: 11
    Last Post: 11-07-2011, 11:29 AM
  2. AfterUpdate not firing
    By newvb in forum Forms
    Replies: 4
    Last Post: 09-29-2011, 04:55 AM
  3. Running an Update Query from a Macro
    By michaelb in forum Queries
    Replies: 7
    Last Post: 06-02-2011, 09:46 PM
  4. Form level mouseup event not firing
    By Philhoop in forum Forms
    Replies: 3
    Last Post: 07-22-2010, 09:41 AM
  5. Access 2010, record selection not firing on click
    By drhowells in forum Access
    Replies: 1
    Last Post: 05-31-2010, 05:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums