customized message

  • Thread starter Thread starter ela
  • Start date Start date
E

ela

hi, all! i have an append query and i would like to
customize its message when it's about to append or cannot
append bec. it violated some restrictions, so that the
user may not be confused. can anybody help me how to do
it?

thanks in advance.
 
One approach would be to wrap up the query in a procedure that includes:
turning off the warnings (be SURE to set them back on at the end!)
testing for success of append (using other than the warning!)
providing your own message
turning back on the warnings!
Click to expand...

Check Access HELP on the DoCmd.SetWarnings command.
 
Search Help for the topic "Display a message box." From there you can
link to instructions on how to create a custom dialog box using either a
macro or VBA.

hth,

LeAnne
 
Back
Top