[AccessD] Error on Next Record

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Thu Jun 12 09:02:04 CDT 2003


Coming a bit late to the party but:

On Error GoTo IsIt2105:

    DoCmd.GoToRecord , , acPrevious

    Exit Sub

IsIt2105:
If err.Number = 2105 Then Exit Sub

MsgBox "Error: " & err.Number & " - " & err.Description


hth

Rocky Smolin
Beach Access Software

----- Original Message ----- 
From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, June 10, 2003 8:01 AM
Subject: [AccessD] Error on Next Record


> 
> Hello Everyone,
> 
> 
> Does someone possibly know how I can get rid of the following runtime
> error?
> 
> Runtime error '2105
> You can't go to the specified record.
> 
> 
> I have a form that I use a query to extract certain information from a
> Linked Oracle table.  I have buttons on the form for the user to go to
> next and previous records.  When ever they reach the first record and
> press the previous button again this error comes up and if they reach
> the last record and press the next button again the error also comes up.
> 
> Is there anyway to make this error not show and just stay on the current
> record??  I don't want the user to have to answer the question to be
> able to continue.
> 
> Mike Gowey, MCP
> Technical Support Analyst
> SRCI ISSD Team Leader
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



More information about the AccessD mailing list