display messages
Question posted by: rudy
(Guest)
on
November 13th, 2005 12:58 AM
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
1
Answer Posted
On 18 Jun 2004 10:03:31 -0700, rudy wrote:
[color=blue]
> 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[/color]
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.
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 196,898 network members.
Top Community Contributors
|