Recent content by hazmatth

Hi, could anyone please take a look at my database. On the main form I have 4 text boxes, all of which have a control source on the subform. my objective is to have the percentage complete for each year. If anyone could take a look and advise, this would be appreciated.

Thank you so much for you help so far, I have got the code working. I'm signing out for the weekend, would you mind if I asked a few more questions via this forum next week when I am back :)

Thanks for you help so far. I have got the query to do what you said but cannot get the name to come from the form, I am required to input the name

Thank you for your help so far. I have got the query set up Thank you for replying but this isn't what I am looking for. I have attached an updated version of my db. In this version I am trying to get a checklist of the training required each year onto seperate tabs on the form.

Would you mind taking a look please, I think I have completed everything you said above but cannot get the append query to work how I want it to.

Thank you for the reply and I agree with everything you have said. I am only having a practice run at the minute and will clean everything up as I do the actual db, its been a while so I am very rusty. The main issue I am having is this: I want a table for apprentices, so a new record of an...

Start year* and Site is location, there are multiple sites that the apprentices are based

Yes every year new apprentices will start. After 4/5 year period the first lot of apprentices can be removed

ApprenticesTbl: UserID (Primary key) FirstName LastName Email SiteName TrainingYear ManagersFirstName ManagersLastName ManagersEmail TrainingTbl: TrainingID (Primary Key) ApprenticeshipType TrainingYear TrainingSection TrainingTitle TrainingDescription ApprenticesTrainingTbl: UserID TrainingID...

Hi, my DB is still in very early stages, I have attached for a better understanding

Hi all, I am in the process of creating an apprenticeship training matrix, essential a log of apprentices and a list of training that they are required to complete at different stages throughout their apprenticeship. - I have a table that is a basic profile of the apprentice - I have a table...