[AccessD] Error on Next Record

Charlotte Foust cfoust at infostatsystems.com
Tue Jun 10 10:31:54 CDT 2003


It's easy enough to test the recordset's BOF or EOF to see whether to
execute the code to move previous or move next.  I don't bother
disabling the buttons, I just pop up a message that says this is the
first record or the last record.

Charlotte Foust

-----Original Message-----
From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] 
Sent: Tuesday, June 10, 2003 7:15 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Error on Next Record


Mike,

I have a slightly long winded approach to this I'm sure someone has a
better solution, when I open a form I disable the previous button as the
user will be on the first record anyway, and when the user moves off the
record I enable it.  If they click the previous button, after the actual
record move I see if it is the first record, if it is I disable the
previous button again.  I do a similar procedure with the user hitting
the last record where I disable the next button if tha last record is
reached.....

Paul


From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
Date: Tue 10/Jun/2003 15:01 GMT
To: <accessd at databaseadvisors.com>
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


________________________________________________________________________
__
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for
Best Unmetered ISP and Best Consumer Application.


_______________________________________________
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