Recent content by nashaz

Hi Please look at the db file in post #8 by arnelgp. That is what I implemented. If you still have further questions, let me know. Only reason I am saying this is that my database has evolved very much from back then. But I am sure I've used the technique in my new database somewhere.

good catch, lol! Thank you. I will made the suggested change for DaysLeft=0

Unfortunately, cant share the db as I will have to cut down a lot. But I was able to get around the issue by creating a new query with the following SQL: SELECT 'Valid' AS Status, SUM(IIf([DaysLeft] > 0, 1, 0)) AS Count FROM AllDeliveredQ UNION ALL SELECT 'Invalid' AS Status...

Hi all First time using the modern charts in access. I am trying to plot a simple pie chart which depicts how many of courses are still in date and how many are out of date. My query (lets call it qry1) has CertificationDate, ExpiresOn, DaysLeft fields. However, I cannot get it to plot on a...

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.