Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Turn confirm Action Queries on then off in macro (Access 97)

    Client runs a number of append queries in a macro. Wants macro to turn Action queries confirm (Tools, Options, Edit/Find, Action Queries) and then turn it on again after macro has run. Using SENDKEYS I can get to the appropriate dialogue box but I don't know how to select the correct TAB. ALT+E for Edit/Find does not work ... I can simply Click on the TAB and then ALT+T will turn it off (or on if it is already off) but I would like to automate the whole process without user intervention. Any help would certainl,y be appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Turn confirm Action Queries on then off in macro (Access 97)

    In a macro, use the SetWarnings action, with argument No before running the append queries, and with argument Yes afterwards.
    In VBA code, use DoCmd.SetWarnings False to turn off the confirmation, and DoCmd.SetWarnings True to turn it on again.

Posting Permissions

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