Half A Headache

[Alex2015]

Hello,

Without VBA (if possible) I want to achieve the following for my end users:

Give them the ability to update only some of the records in a table. For example, a workplace with 50 employees, in which they only want to update 25 people at one given time or something like that. Later on they can run the same update query to take care of the rest of the employees. Is this possible?

 

[jdraw]

More info needed.

only some

at one given time or something like that.

 

[gemma-the-husky]

you need a way of selecting the ones you want to update.

eg 1st half of the alphabet.
or all those not yet selected
or pick the ones you want manually

 

[Alex2015]

More info needed.

Thank you for the reply. My database is tracking compliance with training modules for various employees (94 people at the moment). Some of those 94 belong to different work areas in a hospital.

Perhaps one day, work area A wants to retrain everyone on how to perform CPR, except that not everyone from this work area shows up for the training. I want to have the ability to update the completion dates for only those records of the people that actually showed up.

As the administrator, I know how to do this, but making this simple for the end users has been haunting me for months. Any ideas?

 

[gemma-the-husky]

your users probably need to select the records to update manually. it's hard to "standardize stuff like this, without them being expert access users.

if you can design a query that selects the employees that showed up, it might help - the trouble is you will probably need to be designing a series of one of queries.

how would they do it in excel? whatever you do in excel, you can do in access.

 

[Alex2015]

your users probably need to select the records to update manually. it's hard to "standardize stuff like this, without them being expert access users.

if you can design a query that selects the employees that showed up, it might help - the trouble is you will probably need to be designing a series of one of queries.

how would they do it in excel? whatever you do in excel, you can do in access.

Yeah, I agree that this is difficult to do. If they were doing this in Excel, I'd imagine they would have to scroll down to everyone that showed up & manually type in the new completion date. I was thinking of making a continuous data entry form for this purpose, but I just don't want all of that info showing up on the screen at once. That's the best I've come up with so far.