I've built a system to enter and manage purchase orders. This is in
use by >10 clients. Some use it in Access 97, most are in A2k. About
half use it through a Citrix implementation. It is separated into a
front end and 3 back ends (1 network for permanent storage, 1 local for
temp storage, and 1 local for storage for particular user).
One particular form is failing for a single client (Access 2000, using
Citrix). This form is a form with a subform, used for entering po's.
The outer form contains summary information, such as vendor. The child
form is for entering lines. In order, the fields are account,
quantity, unit price, extended (qty * unit), then two free text fields.
It is bound to the outer form on a shared id, which uses an autonumber
key to assure a unique id across all users.
This single client encounters an error when moving from the unit price
field to the first free text field. All fields on the current line
display #error. The error message displayed is "Not a valid bookmark".
The only code on the unit price field is to set the extended cost
value equal to quantity * unit price. The error message is not
produced through my error trap. If I ctrl+break to see what executes
next, nothing does
Neither the parent nor child form uses a recordset. I have not
declared, nor do I use, any bookmarks on either form. I've declared
recordsets on each, which are used solely within their subs or
functions, then killed when exiting the sub or function. The parent
form is unbound, the child form is bound. The error is not consistent.
Sometimes it fails on the 2nd po to be entered, sometimes the 4th,
sometimes further out. I have not yet seen it fail on the 1st. If the
form is closed then reopened, the first entered will not encounter
errors. Once it has produced the error, even rolling the mouse over
the subform will produce it. The error message box will sometimes be
displayed multiple times.
I cannot find any consistency in the number of times the error is
displayed, or in the number of entries it will accept prior to
producing it, though it is typically between 2 and 12.
I cannot find any consistency in the data used in the record that
produces the error.
I have reconfigured the client's application from the master.
I have relinked another client's application to this client's tables
and encounter the error.
I have relinked this client's app to another client's tables and do not
encounter the error.
I can use another client's accounts with the client's app & tables and
do not encounter the error.
I can use this client's accounts with another client's app & tables and
do encounter the error.
I do not see any differences between Citrix vs non-citrix, though
another tester reports that the error is not encountered in a
non-Citrix environment.
I've not yet encountered the error if I enter all detail lines in the
subform first, then enter data in the outer form.
I've tried placing break points and error handlers within all code on
the subform, as well as the subform object on the parent form. None of
these are encountered when this error is produced.
I have rebuilt all tables. I noticed when testing, that sorting
certain fields in the account table would produce this error, when
viewing them through the table link. These were text fields, using the
A-Z button to sort asc/desc. I rebuilt that table from scratch. I
repopulated it by exporting data from the former table to a text file,
then importing the data from that text file. This did not change the
testing results.
My only thought for a fix is to entirely redesign the form to eliminate
use of a subform, which will take more time than I currently have
available. Of course, on the other hand, I'd be partly done with it if
I'd not done so much testing/rebuilding.
I am at a loss as to what could be causing this error? Any ideas?
use by >10 clients. Some use it in Access 97, most are in A2k. About
half use it through a Citrix implementation. It is separated into a
front end and 3 back ends (1 network for permanent storage, 1 local for
temp storage, and 1 local for storage for particular user).
One particular form is failing for a single client (Access 2000, using
Citrix). This form is a form with a subform, used for entering po's.
The outer form contains summary information, such as vendor. The child
form is for entering lines. In order, the fields are account,
quantity, unit price, extended (qty * unit), then two free text fields.
It is bound to the outer form on a shared id, which uses an autonumber
key to assure a unique id across all users.
This single client encounters an error when moving from the unit price
field to the first free text field. All fields on the current line
display #error. The error message displayed is "Not a valid bookmark".
The only code on the unit price field is to set the extended cost
value equal to quantity * unit price. The error message is not
produced through my error trap. If I ctrl+break to see what executes
next, nothing does
Neither the parent nor child form uses a recordset. I have not
declared, nor do I use, any bookmarks on either form. I've declared
recordsets on each, which are used solely within their subs or
functions, then killed when exiting the sub or function. The parent
form is unbound, the child form is bound. The error is not consistent.
Sometimes it fails on the 2nd po to be entered, sometimes the 4th,
sometimes further out. I have not yet seen it fail on the 1st. If the
form is closed then reopened, the first entered will not encounter
errors. Once it has produced the error, even rolling the mouse over
the subform will produce it. The error message box will sometimes be
displayed multiple times.
I cannot find any consistency in the number of times the error is
displayed, or in the number of entries it will accept prior to
producing it, though it is typically between 2 and 12.
I cannot find any consistency in the data used in the record that
produces the error.
I have reconfigured the client's application from the master.
I have relinked another client's application to this client's tables
and encounter the error.
I have relinked this client's app to another client's tables and do not
encounter the error.
I can use another client's accounts with the client's app & tables and
do not encounter the error.
I can use this client's accounts with another client's app & tables and
do encounter the error.
I do not see any differences between Citrix vs non-citrix, though
another tester reports that the error is not encountered in a
non-Citrix environment.
I've not yet encountered the error if I enter all detail lines in the
subform first, then enter data in the outer form.
I've tried placing break points and error handlers within all code on
the subform, as well as the subform object on the parent form. None of
these are encountered when this error is produced.
I have rebuilt all tables. I noticed when testing, that sorting
certain fields in the account table would produce this error, when
viewing them through the table link. These were text fields, using the
A-Z button to sort asc/desc. I rebuilt that table from scratch. I
repopulated it by exporting data from the former table to a text file,
then importing the data from that text file. This did not change the
testing results.
My only thought for a fix is to entirely redesign the form to eliminate
use of a subform, which will take more time than I currently have
available. Of course, on the other hand, I'd be partly done with it if
I'd not done so much testing/rebuilding.
I am at a loss as to what could be causing this error? Any ideas?
Comment