Recent content by SCase

we have 200+ employees and atleast 11 regular mandatory training qualifications. So it would be difficult to make a separate table for when they have completed it because then i would have to be making a new table every year. i also have a search form set up to search each employees current...

When a training is added using my 'Add Training' form, i have a button that has an event procedure that add's the record to the appropriate table (including employee data) and assigns an expiry date, using a Docmd.RunQuery. From here, i have a report that is populated with the criteria...

Hi, yes i didnt do a very good job at explaining the issue. The reason for needing it to go to a separate table is that when i generate a report to see the upcoming and overdue training dates, it doesn't reflect that employee XYZ has an overdue training when i have already added a new record...

Hi there! I am creating a database for tracking training at my workplace and have run into some trouble with archiving old training records. Basically i would like to create an append query that i can use to move previous training records to a separate table when i add a new training record...