Recordset Clones and Bookmarks

  • Thread starter Thread starter Mike Moncur
  • Start date Start date
M

Mike Moncur

Form.Recordset = "Select* from table"
I can't move past the 49th record with out a runtime error.
 
Mike Moncur said:
Form.Recordset = "Select* from table"
I can't move past the 49th record with out a runtime error.
Click to expand...

It would help if you posted the exact error message, and the error
number if possible. Are you talking about a form whose recordset you
have set in code, or is your statement really referring to theform's
RecordSource property? Are you experiencing the error when you navigate
on the form using the built-in navigation buttons, or via code? Your
subject says "Recordset Clones and Bookmarks", so presumably there's
code involved somewhere. Please post the code.
 
-----Original Message-----
Form.Recordset = "Select* from table"
I can't move past the 49th record with out a runtime error.
.
Click to expand...
I figured this out my self.
A recordset with a large number of records takes some time
to return all the records. Do not set a bookmark until all
the records have been received.
 
Mike Moncur said:
I figured this out my self.
A recordset with a large number of records takes some time
to return all the records. Do not set a bookmark until all
the records have been received.
Click to expand...

A few thousand records is not a very large number of records. A well indexed
recordset will return several hundred thousand records in a few seconds at
most. You can set a bookmark in your code, as VBA code is not asynchronous
(it runs sequentially). You should use a .movelast on your recordset though
to make sure that the record is where you think it is in the count (You can
only get an accurate count after moving to the end of the recordset).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Hi, Mike

How are things going? Detailed information that you can provide will make
things clear and help us move closer to the causes and resolutions.

I would appreciate it if you could post here to let me know the status of
the issue. If you have any questions or concerns, please don't hesitate to
let me know. I look forward to hearing from you, and I am happy to be of
assistance.

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Back
Top