Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    suppress message box (2002)

    Hi all, I've got a check box in a form that when clicked, runs an append query. Next appear 3 pop-up windows in succession asking the user (for example) "do you want to append records....etc etc"....to which they would answer "yes" to all of them. I would like to not have these appear and i would like the "yes" response automatically chosen for each window. Can this be done in the code? thanks, Van

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

    Re: suppress message box (2002)

    Yes, insert a line

    DoCmd.SetWarnings False

    above the line that runs the query, and

    DoCmd.SetWarnings True

    below it.

  3. #3
    Star Lounger
    Join Date
    Nov 2002
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: suppress message box (2002)

    Thanks Hans, that works a treat! regards, Van

Posting Permissions

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