Results 1 to 3 of 3
  1. 08-27-2009, 11:04 AM #1
    oakoen
    oakoen is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2009
    Posts
    15

    Up datequery question

    Is there a way to run an update query unprompted.
    I have a form that runs an update query onclose and I do not want the "are you sure" prompts to appear.
    Reply With Quote Reply With Quote
  2. 08-28-2009, 01:45 AM #2
    dcrake's Avatar
    dcrake
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    You need to toggle the following

    DoCmd.SetWarnings True/False either side of the query execute.

    David
    Reply With Quote Reply With Quote
  3. 08-28-2009, 08:40 AM #3
    oakoen
    oakoen is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2009
    Posts
    15
    Thanks dcrake
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

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