Search results

Yeah, they've been sharing the FE. We've got about 8 computers and they rotate. Everyone's gotta save it on every one, eh? At any given point there's usually only 1 or 2 people on the database at once, and this problem is occuring with one person on.

Thanks for the responses! The front & back end are stored in the same folder under different subfolders. I tried to run the code linked above but when my coworkers go to use the database it comes up that they don't have permission to access that database (i.e. the backend) or someone has...

Hi - I've got a database in Access 2007 that keeps track of client data for work. It's been working fine for about a month, and suddenly today other users can't change any information because the records are suddenly locked when accessed from their accounts. I've already checked that they...

Just in the table.

Same problem happens. Yeah this was the last one I tried and it seemed promising but for some reason it would copy to the temp table but not the actual audit table: allenbrowne.com/appaudit.html I've been able to muddle my way through VBA for everything else but I think this audit system...

I'm attempting to create a system to track changes to my database because it's going to be piloted shortly and I'm going to keep our old information systems up to date while that occurs, just in case something unexpected happens or the database is a flop. I've tried several ways, the first...

Perfect! Done and done-er! Thanks for the tips! :)

So, I feel kind of dumb here cause I'm 99% sure this is super easy and already been solved multiple times on this forum but I really can't figure it out after lots of poking around. I am trying to create a report that filters out certain records in a look-up field. The field is called...

Well, I did this over and over again without success and then randomly I did it again and it worked. No idea what changed! Thank you so much for your assistance and patience, this is immensely helpful for me! H

Here's the basic layout of it, I've changed the actual records because it's all confidential information. The form I'm trying to adapt is "Participant Details" and currently am trying to program the button right of the drop down selection to open the "face sheet" report. Thanks Heidi

Hi, thanks - the data type is a number. Some of the fields are blank - would that change it?

Hi, I'm working on a database for my job and have a very limited understanding of code as I don't have much time to learn it in detail - I only need it for a few small things. Thus far I've been able to muddle my way through, but I'm stuck on trying to print off a specfic entry in a report. I...