How to customize append query confirmation message

[Hellgofi]

Hi,

Is there any way to customize append query confirmation message? Unclicking Confirm Tools-->Options-->Edit/Find-->Confirm-Action Queries disables all warning messages.

My query takes some records from one table and append them to another table. When I run the query, first warning message says "Warning you r about to run an append query that will modify data in your table" (this is the message I do not want to see) and then if OK is clicked, the message says "you are about to append XXX rows...(this is the message I would like to customize)

How can I customize the 2nd message?
regards

 

[Mile-O]

You can't customise them directly.

You can create a function that runs the queries and then shows a confirmation message.

With DoCmd
    .SetWarnings False
    .OpenQuery "AppendQuery"
    .SetWarnings True
End With
MsgBox "Success", vbInformation

 

[Hellgofi]

thanks a lot