Recent content by ResTech

SopTbl SopNum : SopDesc : SopRev : AnnualTrn BUS003 : Data Ent : 2 : Y BUS005 : Drawing : 4 : N CUS001 : Customer : 1 : Y I am adding to the criteria each SOPNum that each person needs training on so that I can give them a training...

Table name: SOP Table Field Names: SopNum, SopDesc, SopRev, AnnualTraining BUS002 BUS003 CUS001 CUS003 Product Training There are 183 or so SOP's and I need it to display what training is for each individual.

I have attached my query

Plog, I have created the table as you suggested in this post and now I'm having trouble with my query criteria. There is a list of SOP's that people may need to train on, some may need to train on all of them like myself so I did the Like"*", some may need to train on many of them but not all...

I'm just trying to figure out how to take my current info and turn it into the junction table without retyping everything.

So can I change my first attachment "Training Records Example" from peoples names to their Id number and query from that or do I need to rearrange the whole table?

Some people need to train on all SOP's and others need to train on a few select depending on their position. As a revision changes on an SOP I need to send out the new one to anyone that has previously trained on it and then go back and update their training records. I have attached a training...

Plog, Thanks for the info so far, I am reading up on junction tables. I have attached my other 3 sample tables (they didn't convert very well). I know using names for fields isn't a good idea but I chopped up the excel spreadsheet where our training records are kept and I couldn't come up with...

I am trying to build a database for Training records, these are the tables that I have created..Training, Employee, Position and SOP. I have attached a sample of my training record table. As you can see not every person gets trained on the same SOP's so each employees training record is...

I'm using 2007

I think I switched it after that, I've got almost 3 pages of info on my single form.

I am currently setting up a continuous form, I did begin setting it up on a tab control but that didn't seem user friendly either, I wasn't sure where to have the tab section sitting and where the "find record" and "print" buttons should go. When I am done with my continuous form I can easily...

I have attached a screen print of the first page of my form that is used to collect data on the first two pages, the last two are used for write in and sign offs. We currently use an editable pdf. Thanks.

I have put 2 pages of info on my form and also some test data in my database but when I print my form I get copies of everything that has been entered.

Is is possible to create a form that is 4 pages in length? After info is entered in first two pages I would like to print out all 4 pages to pass on to another person.