You can't go to the specific record - I want to display a different message

[Simone]

Hello!!!

Here is the thing.
I have had this problem and I want to address it now where in the next
and previous button DoCmd.GoToRecor d , , acNext - DoCmd.GoToRecor d , ,
acPrevious I wish the message that displays to the user when there is
no more record to got to was something different then **You can't go
to the specific record**
Has anyone ever changed to say something different?

Thanks
Simone

[Deano]

Simone wrote:

Hello!!!

Here is the thing.
I have had this problem and I want to address it now where in the next
and previous button DoCmd.GoToRecor d , , acNext - DoCmd.GoToRecor d , ,
acPrevious I wish the message that displays to the user when there is
no more record to got to was something different then **You can't go
to the specific record**
Has anyone ever changed to say something different?

Thanks
Simone

I think you can trap this in the form's error event and sub your own
message. I assume the err nuimber is 2105 but if you step through the code
you can see what the value of DataErr actually is. Also if you're using a
command button for navigation you can place this in the error handling
section but instead check for the value of Err.number.
Private Sub Form_Error(Data Err As Integer, Response As Integer)

Select Case DataErr
Case Is = 2105
Msgbox "Listen up, there really aren't any more records to see."
Response = acDataErrContin ue
Case else
Response = acdataerrDispla y
End Select

End Sub

[Simone]

Thanks for you help.
I tried the code below and it didn't work, actually nothing happened.
The error number is 2105.
Please let me know if you have other ideas.

Thanks.
Simone

"Deano" <de*********@ho tmail.com> wrote in message news:<KC******* ***********@war ds.force9.net>. ..

Simone wrote:

Hello!!!

Here is the thing.
I have had this problem and I want to address it now where in the next
and previous button DoCmd.GoToRecor d , , acNext - DoCmd.GoToRecor d , ,
acPrevious I wish the message that displays to the user when there is
no more record to got to was something different then **You can't go
to the specific record**
Has anyone ever changed to say something different?

Thanks
Simone

I think you can trap this in the form's error event and sub your own
message. I assume the err nuimber is 2105 but if you step through the code
you can see what the value of DataErr actually is. Also if you're using a
command button for navigation you can place this in the error handling
section but instead check for the value of Err.number.
Private Sub Form_Error(Data Err As Integer, Response As Integer)

Select Case DataErr
Case Is = 2105
Msgbox "Listen up, there really aren't any more records to see."
Response = acDataErrContin ue
Case else
Response = acdataerrDispla y
End Select

End Sub

[Deano]

Simone wrote:

Thanks for you help.
I tried the code below and it didn't work, actually nothing happened.
The error number is 2105.
Please let me know if you have other ideas.

Thanks.
Simone
That probably means the error is not handled at the form level and you need
to trap it in the command button itself.

You need to step through your code by setting a breakpoint. See where the
error occurs then add an error handler.

In your event code you should set up some basic error handling structure. A
commonly used method is;

Private Sub Command0_click( )
On Error goto Err_Command0

'your code here

Exit_Err_Comman d0:
Exit Sub

Err_Command0:
Msgbox err.number & " " & err.description
Resume Exit_Err_Comman d0

End Sub
In your case simply put the following code first in the Err_Command0
section;

If err.number = 2105 then
Msgbox "Listen up, there really aren't any more records
Resume Exit_Err_Comman d0
End If


"Deano" <de*********@ho tmail.com> wrote in message
news:<KC******* ***********@war ds.force9.net>. ..

Simone wrote:

Hello!!!

Here is the thing.
I have had this problem and I want to address it now where in the
next and previous button DoCmd.GoToRecor d , , acNext -
DoCmd.GoToRecor d , , acPrevious I wish the message that displays to
the user when there is no more record to got to was something
different then **You can't go to the specific record**
Has anyone ever changed to say something different?

Thanks
Simone

I think you can trap this in the form's error event and sub your own
message. I assume the err nuimber is 2105 but if you step through
the code you can see what the value of DataErr actually is. Also if
you're using a command button for navigation you can place this in
the error handling section but instead check for the value of
Err.number.
Private Sub Form_Error(Data Err As Integer, Response As Integer)

Select Case DataErr
Case Is = 2105
Msgbox "Listen up, there really aren't any more records
to see." Response = acDataErrContin ue
Case else
Response = acdataerrDispla y
End Select

End Sub