Recent content by Reeses

Thank you so much! Worked like a charm. I appreciate your help and the specific instructions.

Hey all, I am stuck. Thanks to alot of research and YouTube, I finally was able to create a DectectIdleTime for one of my databases. My coworkers have a habit of leaving the database open all the time and even overnight and it was causing issues. So I needed a way to be able to have it auto...

Hey all! I'm back again. Lol. And since yall are so awesome and helpful, I have another issue. Lately sporadically, my coworkers are getting the error "could not update, currently locked" when they try to enter information and save it. It's happened twice so far and once they all restarted...

Yeah...I hope I do. lol

And the other system that the company uses saves them for 10 years before they get trashed.

No cause once they are audited and released we no longer have the packages in those locations. They go to a different area out of our department and are documented in a different system that my company uses. This database that I created is strictly just for my department to keep track of the...

I will, thank you. We should never have more than 2,000 records in there. We delete some daily that are completed audited.

Gotcha. You guys are awesome. You're my "go to" people. Lol. Thank you! I will add that and see how it goes. I appreciate your help, as always. Enjoy your weekend!

Ohhhh, ok, so put it in the "find record" command. And the me.requery?

So for the "lot number" that you see at the top of the picture, put a me.requery in there for the event procedure?

Theres more buttons at the bottom that you cant see. I pit a command button to "find record". So they click that and put in the lot number and that takes them to the record.

This is what it looks like (I added an attachment). When the first group gets packages, they insert the lot number and put it in a cabinet that has a location. So the auditors will search for the lot number to find out what cabinet it is in and go get it. They will then fill out what packages...

I'm back! Yall have helped me so much with my last few questions. Thank you. I have another one. Lol. Ok, so like I stated before, this is a split database. When my coworkers are looking up a lot number, sometimes it doesnt show up but when I look it up on mine, it shows up. Do you think I...

Hey all! Sooo...I have another question. I'm so sorry. Lol. Ok, so my database form has many fields that my coworkers have to input data. But there is ONE field that I want to lock after data is put in. The thing is, it is a continuous form, so that field cant be locked when adding a new...

Thanks again for the help. I was able to go in the back end and add to the table and then add new fields on the front end. Now it's how my manager wants it. I couldn't have done it without your help....I was seriously googling everything I could for about 3 hours. Lol. Now I know where I can...