×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

*
*
*
*

Thanks. We have received your request and will respond promptly.

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Filter by form mystery

thread702-25228

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

RE: Filter by form mystery

Not sure what it could be but I have had Access get messed up. You could try making a copy of your database with a new name, decompile it and then re-compile it and try again. Don't do this to your main copy!
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close