Recent content by abnorth

@jdraw Thanks! I'll take a look. @Gasman Ah I see, that makes sense. I wouldn't mind learning VBA, it's just a matter of time (I'm a chemist who is supposed to be doing lab work, not managing a database, but no one else at my company can do it 😂). My guess is if I need much more functionality...

Hi Gasman, Not sure what you mean. An If statement to display the message and another to undo? On another note. Not having ever touched VBA before I looked up a tutorial on using beforeupdate to cancel unwanted changes and got it to work based on the example in the video. So I guess this is...

Hi! I have some users that like to randomly click on things and delete text for no reason. This results in accidental changes to some of our data. I’ve locked everything on the form that isn’t used for adding/editing records, but I would like to add a prompt when data is about to changed so...

No, we are continuing to use that solution to ensure only one person is using it at once. As I said, it was our initial solution in lieu of another option and we are doing that until we can properly fix it. All I meant by my message was that we had already enacted your suggestion.

This was our initial solution when we discovered two people tried to enter different new chemicals into the inventory at the same time. We only have 3 people who use the database, so it's not too cumbersome, just an extra step to check if someone is using it.

All my coworker had time to do was to import our previous inventory excel spreadsheet into access before he left the company. It was one of the last things he did, and he told us it was only a half-finished job. I don't have the authority to move it off of google drive and my boss is currently...

This seems like the type of solution I am looking for, I just don't know how to go about doing it. I will look into it more! I did read Krayna's thread. Unfortunately, most of what was said about how to implement the fix went over my head. Thank you for your explanations though, they were...

In our current configuration, multiple people can open and view the db, but the first person who opens it generates a locked file, and only their changes will be saved. Others can make changes, but those changes won't be saved and there is no indication to those users that their changes won't be...

Hi! Thanks for your replies. Gasman - No it is not split. We do use forms to edit the data in our tables but don't have FE/BE files (I just learned what those were today in fact). Unfortunately we are a small company that does not have an IT team, we are all just figuring things out as we go...

We use access as an inventory, and sometimes one person is adding an item while another is looking up or marking another item as empty. Our database is stored in a shared google drive and we use file stream to open any files. With excel, word, or powerpoint, the real-time presence notifies us if...