Hi there. im relatively new with Access and database construction but have dabbled in some vba throughout my database's construction.
im currently creating a rudimentary database in order to store 'learner details', 'certificate details' and 'course details' for a health and safety company, on the premise that they need somewhere to store this information and have the ability to search through it. Considering it is a company that runs courses and, once completed, hands out certificates, the clients have pdf copies of all the certificates that they have handed out. On the database there is a record for each certificate handed out, detailing the learner that corresponds with it, and the course details that the certificate applies to. The problem i have is that the client wants the pdf of each certificate to match the certificate details record on the database through the use of an image pane. The only viable option i can see is that the name of the pdf must correspond to the name of the certificate ID on the database, which will then import it into the pane. If you have any ideas how i can do this please help!
im currently creating a rudimentary database in order to store 'learner details', 'certificate details' and 'course details' for a health and safety company, on the premise that they need somewhere to store this information and have the ability to search through it. Considering it is a company that runs courses and, once completed, hands out certificates, the clients have pdf copies of all the certificates that they have handed out. On the database there is a record for each certificate handed out, detailing the learner that corresponds with it, and the course details that the certificate applies to. The problem i have is that the client wants the pdf of each certificate to match the certificate details record on the database through the use of an image pane. The only viable option i can see is that the name of the pdf must correspond to the name of the certificate ID on the database, which will then import it into the pane. If you have any ideas how i can do this please help!
