Hi all you gurus,
This error came up on our database. Fortunately I had a backup
so no problems. Could not even compact or repair. What causes this error.
When a form is opened & loaded, each record is asigned a [blue]BookMark[/blue] value. Also each time the form is opened, the bookmarks are never the same.
One way to goto a record is by manipulating the bookmark property of a form or recordset. [blue]The error is raised when the bookmark property assigned doesn't exits[/blue] . . .
many thanks for your help.
Is this the forum to explain the latter part of you reply.. 'bookmark property does not exist.' How does this occur?
Or can you point me in the right direction to be able to follow this up.
1) You may have some code that references the bookmark property for an object that does not have a bookmark property. So search your code for the word "bookmark" and post any code that references it.
2)Compile your code and see if it breaks any where
3)If not 1 or 2 then your database may be corrupted which can be caused by many things. Network, poor database design, access quirkiness:
Almost invariably this occurs with recordsets. Consider for a form you perform the following:
Code:
[blue] Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone[/blue]
Here the recordset bookmarks are a copy of the form bookmarks, so that:
Code:
[blue] Me.Bookmark = rst.Bookmark[/blue]
Always works. However, if while both form and rst are active you requery either the form or recordset, the requeried object is assigned a different set of bookmarks. A miss match now exists.
Consider the above when you hold a bookmark for return to a record after requery!
Actually this idea of bookmarks as it relates to your problem is quite academic, as [purple]I'd expect you to get this error during design testing! This is an hardcore error that will always raise its head![/purple]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.