Trapping Access messages

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

When a user deletes a record from a table which has a link to another table
two messages appear.One that asks the user to confirm they want to delete
the record and another that involves the deleting of records in the linked
tables. is there any way to trap these messages to stop them appearing and
replace them with my own because the wording of the second message isn't
user friendly?
TIA
Tony Williams
 
If you are working directly in the tables, I don't know of a way on an
individual basis. If you are using forms, this can be done. You could do the
delete in code and bypass the warnings.

There is a way to turn some warnings off for everything, but be careful when
doing this. The options are located in Tools|Options, Edit/Find tab under
Confirm. The advantage of turning off the warnings in code is that you can
also do some verification in code to make sure that an item should be done
and so the warnings may not be as necessary or you may have already supplied
your own warnings and so there is no need to duplicate it with Access's
warnings.
 
Back
Top