I have been asked to make some modifications to a database an outside vendor built years ago for CPR training for a department here at our hospital. I am trying to figure how everything works because its a complex built Access db.
Its a linked database with the data part sitting on the network and the front end on two workstations
What was needed and what I attempted to add is detailed as follows
A place to record the Instructor ID as provided by a government affilated agency- I created a field in tblAHAInstructors and a form to add going forward that can be accessed from the main startup form. However instructors and attendees are both entered on a form for Contacts. if they check that the contact is an instructor part of the data will feed into the tblAHAInstructors table.
Print the ID on the report they use with laminated card stock. This is where it gets complex. When you come up to the main form you click on Enter/Edit Classes(frmClasses). It will take you to a screen where you Enter a new class or search on an old class by date. There is a button on there that will allow you to print cards(rptLaminatedCards) if the check box for Cards on the frmClasses form beside the persons name is unchecked. I think part of the data comes from the classes table but if you look at in designed view for the report there is a subreport to pull the instructors first and last name onto the printout. I attempted to manipulate the query statment so it would print the insructor id on there by joining the tblcontacts and tblAHAInstructors on the ContactID both share. When I preview afterwards(did not save it thankfully) the instructor name completely disappear.
I think it would be helpful if I share the database so I someone can offer suggestions and advice since I don't have a clue how to proceed since I did not build this but since its linked I am not sure how I would attach it. Help is defintely appreciated.:banghead:
Its a linked database with the data part sitting on the network and the front end on two workstations
What was needed and what I attempted to add is detailed as follows
A place to record the Instructor ID as provided by a government affilated agency- I created a field in tblAHAInstructors and a form to add going forward that can be accessed from the main startup form. However instructors and attendees are both entered on a form for Contacts. if they check that the contact is an instructor part of the data will feed into the tblAHAInstructors table.
Print the ID on the report they use with laminated card stock. This is where it gets complex. When you come up to the main form you click on Enter/Edit Classes(frmClasses). It will take you to a screen where you Enter a new class or search on an old class by date. There is a button on there that will allow you to print cards(rptLaminatedCards) if the check box for Cards on the frmClasses form beside the persons name is unchecked. I think part of the data comes from the classes table but if you look at in designed view for the report there is a subreport to pull the instructors first and last name onto the printout. I attempted to manipulate the query statment so it would print the insructor id on there by joining the tblcontacts and tblAHAInstructors on the ContactID both share. When I preview afterwards(did not save it thankfully) the instructor name completely disappear.
I think it would be helpful if I share the database so I someone can offer suggestions and advice since I don't have a clue how to proceed since I did not build this but since its linked I am not sure how I would attach it. Help is defintely appreciated.:banghead:
