How to customize messages

[itbeginner]

Hello!

Normally when you delete records from tables, you enter invalid data or things like that, Access normally displays either an error or informatiom message which is quite difficult for a user with very little undertanding of computer terms. So is there anyway i can customize these messages or disable them and put my own messages in a more user-friendly way?

 

[KenReay]

Hi

Yes

But to explain how depends on where and what you want to suppress

for example teh validation property in a control on a form, you can include a custom message in the validationmessage property

if you want to suppress the 'about to delete n records message' on a bound form then in the before delete event put Response = acDataErrContinue, and in the OnDelete event put code to display your custom message (and possibly cancel the delete)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[willir]

Hmmmm

See...

http://www.tek-tips.com/viewthread.cfm?SQID=840593&SPID=700&page=1

Some of the sample code strings a custom error message depending on the success of the validation.

Richard

 

[itbeginner]

Thanks a lot Ken and Richard. From both ur answers it seems i need to use coding which i'm not very familiar with. so i'll go n find some tutorial n learn it.