Recent content by nashaz

I would have done job category but thats not possible in this instance unfortunately. I also have to think about absences, as well as some employees were partially present. All of this data I have a physical record of. Just need to translate that into db. Thanks for the attached db. I will go...

Precisely my concerns, and thus this thread. If I was to open individual employee record, and update the training subform within that (which is currently what I have), it would take ages. Just wanted to see if I could simplify this operation by having all employees in a list where I could select...

True... However, just for learning's sake, any idea why this may be happening?

As I understand from your and LarryE's response, this would have to be an ad-hoc operation and not something which you can have a form for, am I right? I will implement this solution tomorrow and update here with the results. As always, really appreciate everyone's help :)

Greetings, I have a basic table, CourseNameT which looks like this: In the corresponding form, I have txtCourseID, cboCourseName, cboType (can only be either External or Internal), and txtValidFor. I am trying to use NotInList event so that user can add new courses if it doesn't already...

Thank you for your reply. I am not playing catchup, as we just did an internal training day with all the staff, which included around 13 different trainings. When I actually got down to updating the db is when I thought maybe I should ask if there is another way of doing that.

Mostly, all employees, but in some instances it will be lesser than EVERYONE due to absences etc Not all training records, but as an example, 13 out of 25 training records Could you please explain this further (apologies)

Pardon me for my lack of knowledge, do I write the above inside a SELECT query SQL?

Hi all Is there a way to bulk update training records? For example, let's say I want to update records of 50 employees, where they all received 13 trainings. Using continuous forms, I would usually navigate to an employee, then assign 13 trainings to them. But this is way too long to do for 50...

that did the trick. thanks!

Hi all I am trying to import some forms from a previous db to a new one, to save me from formatting and referencing, but I get the following error: I have tried to close and reopen the db, as well as compact & repair without any luck. Thanks for the help.

@Minty and @Doc Thank you for your inputs. Based on both your feedbacks, what I understood is that the totalling needs to happen in a separate query. I have done the following and it works just as I needed it (although its not as sophisticated a solution as what the Doc suggested). Thank you...

Im sorry, I dont quite understand what you meants by that.. :$

When I select Max, it gives the same error, as seen below: However, Access changes this to Expression itself when I save and close it. If I change it back to Max, I am getting following error:

Hi I have a very basic issue with the total query which is doing my head in. Don't think I have had this issue before. I have the following query which works just fine as standard non-total query. When I press Total and do the following, I get an error message saying 'enter parametric...