Recordset Clones and Bookmarks

[Mike Moncur]

Form.Recordset = "Select* from table"
I can't move past the 49th record with out a runtime error.

 

[Dirk Goldgar]

Form.Recordset = "Select* from table"
I can't move past the 49th record with out a runtime error.

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.

 

[Mike Moncur]

-----Original Message-----
Form.Recordset = "Select* from table"
I can't move past the 49th record with out a runtime error.
.

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.

 

[Arvin Meyer [MVP]]

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.

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

 

[Michael, Cheng [MST]]

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.