By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,287 Members | 1,668 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,287 IT Pros & Developers. It's quick & easy.

display messages

P: n/a
I am using a form for data entry that I want to be able to change the
message that appears when I click on a button to process the entry.
The current message that appears is 'you can't go to the specified
record'. Can this be edited or replaced with one that states 'record
is already in database' or something more meaningful.

Thanks,
Rudy
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 18 Jun 2004 10:03:31 -0700, rudy wrote:
I am using a form for data entry that I want to be able to change the
message that appears when I click on a button to process the entry.
The current message that appears is 'you can't go to the specified
record'. Can this be edited or replaced with one that states 'record
is already in database' or something more meaningful.

Thanks,
Rudy


Code the Form's Error Event:
MsgBox "The error# is " & DataErr
Resume acDataErrContinue

open the form and intentionally make the error.

The message box will appear with the error number.

Then re-code the Error event to:
If DataErr = XXXX Then
MsgBox "Your new message here."
Resume acDataErrContinue
Else
MsgBox "Error #: " & DataErr
Resume acDataErrDisplay
End If
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.