Change Append Query Message

[Engr. Clement]

Hi,
Please guide me on how best to change the default message that an append query pops up to a customized message.
Thank you.

 

[MarkK]

An append query does not, by default, display a message. If your query does display one please describe it, when it occurs, what it says, and so on, in detail. Then someone might have enough info to help you customize it.
HTH
Mark

 

[Pat Hartman]

If you're talking about the "you're about to append x records..." and then the "x records were appended and x records ...", you can suppress these messages completely by setting warnings off before running the query and then back on immediately after (do NOT forget this step. It is critical). If you want to give the same kind of messages, you'll need to append the records one at a time in a VBA code loop using DAO or ADO so you can trap and count the individual errors.

 

[gemma-the-husky]

there are 2 choices here

1. turn on/off errors as mentioned above.
docmd.setwarnings false
docmd.setwarnings true

2. use a different command
currentdb.execute qryname

now option 1 runs without informing you of errors, so if something goes wrong, you won't be aware

on the other hand option 2 fails to run in the event of errors, but enables you to trap the error

so you need to thing about the best way to achieve what you want.

----
and as Pat said, you can manage the whole process manually to get full control, but it is a bit more work.