Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Set Warnings ?? (Access 2000)

    If I have code running when a form opens, how can I add "set warnings to No" to this event?

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

    Re: Set Warnings ?? (Access 2000)

    I don't know why you would need it when opening a form, but the code is DoCmd.SetWarnings False. Don't forget to use DoCmd.SetWarnings True later on, for Access doesn't turn it on automatically within a session.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Set Warnings ?? (Access 2000)

    SetWarnings is for messages generated by Access when doing things like running a query. You shouldn't need it when opening a form unless you are running some kind of append or update query behind the scenes. If that's NOT what you're using it for, you might want to explain what the form is doing that caused you to ask the question. It may be something we can help you with.
    Charlotte

Posting Permissions

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