How to Run an Append Query in VBA without getting all the messages.
Posted on 2004-09-21
I have a line that runs an append query in my code
DoCmd.OpenQuery "QRY_AppendHeader", acViewNormal, acAdd
the add query Runs normally every time and the only thing I want to avoid is
to stop getting the messages from the application.
"You are about to run an append query that will modify data in your table"
"You are about to append 486 rows"
"Microsoft can't append all the records in the append query"
I know that there are some fields not being Imported I take care of that in the code
but i NEED TO STOP THESE MESSAGES FROM APEARING. hOW DO i DO THAT?