Filter by form mystery
Filter by form mystery
(OP)
On my main form, if the user attempts to filter on the 'product details' field (a memo field) most of the time the following message appears
"The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time"
It then seems to apply the filter but every field has '#Name?' in it. This is the only field that this happens, and never are more than 1 user using the database at the same time
Regards
Richey
"The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time"
It then seems to apply the filter but every field has '#Name?' in it. This is the only field that this happens, and never are more than 1 user using the database at the same time
Regards
Richey
RE: Filter by form mystery
click start - run - type this in - msaccess /decompile
then open your copy of the database. After it opens you will get a message about the code. Close Access. Open Access like normal. Open your copy of the database and get into a code window. Click debug then Compile and save all.
Then test your form.
That is all I can think of.
John A. Gilman
gms@uslink.net