Access: Stop the popup messages

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,720
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
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,720
Thanks. So it was the equal sign that screwed up. I had it first at one point.

Thank You
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,100
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,347
Messages
5,449,862
Members
405,577
Latest member
PetMak

This Week's Hot Topics

Top