Customizing append query confirmation dialog

[dgilbert]

Is there a way to CUSTOMIZE the action query confirmation dialogs so the message is more informative (and less scary sounding)?

For example, I would prefer the dialog state something along the lines of "You are about to add X records to yada yada table."

The default message of "You are about to append X row(s). Once you click Yes, you can't use the Undo command..." sounds a bit intimidating to those unfamiliar with Access.

I know I can easily disable these message via DoCmd.SetWarnings(), but would like to give the user the option to abort the append if the reported number of records don't look correct.

Thanks for any help,

-- Dan

 

[grnzbra]

If you are running the query from code, after you set warnings to false, you could run a duplicate select query and get a count of the reocrds in that. Use that count in a message box and if the user selects yes (or ok or whatever) then run the action query. If he selects no, set the warnings to true and get out.