Likes Likes:  0
Results 1 to 4 of 4

Thread: Access: Stop the popup messages

  1. #1
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,529
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Access: Stop the popup messages

    How do I stop the messages that come with the make table and append table queries? I thought it was SetWarnings = False

    I tried different places with no luck - the code errors

    Code:
    Private Sub Form_Load()
    'open home page
    On Error GoTo Form_Load_Err
    
    
        DoCmd.OpenQuery "qry_1a_Find_New_QuoteNumbers", acViewNormal, acEdit
        '    DoCmd.SetWarnings = False
        DoCmd.Close acQuery, "qry_1a_Find_New_QuoteNumbers"
        DoCmd.OpenQuery "qry_1b_ppend_New_Quotes", acViewNormal, acEdit
        DoCmd.Close acQuery, "qry_1b_ppend_New_Quotes"
    
    
    Form_Load_Exit:
        Exit Sub
    
    Form_Load_Err:
        MsgBox Error$
        Resume Form_Load_Exit
    
    End Sub
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    48,996
    Post Thanks / Like
    Mentioned
    47 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Access: Stop the popup messages

    Put it before you very first query (and make sure it is not commented out!).
    Also, there is no equal sign with it.
    See: https://docs.microsoft.com/en-us/off...md.setwarnings
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,529
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access: Stop the popup messages

    Thanks. So it was the equal sign that screwed up. I had it first at one point.

    Thank You
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

  4. #4
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    48,996
    Post Thanks / Like
    Mentioned
    47 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Access: Stop the popup messages

    Yeah, in bouncing back and forth between Excel and Access, I often also sometimes confuse DisplayAlerts with SetWarnings and equals sign or no no equals sign.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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