Create, name and save PDFs documents from a MSAccess form
I am hoping to create certificates directly from my database and have them named and saved as PDFs.
I've attached an example database to help explain what I am hoping to achieve. What I need help with is some code attached to a button on a form (frmCreateCerts), that will create certificates for all records appearing in the qryCreateCerts query.
When the button is clicked I need the code to do the following actions...
- create and save certificates as PDFs for all records in the qryCreateCerts query by inserting the [Full Name] into the certificate (frmCertificate)
- save them into C:\Certificates\ folder on my computer
- name each one using this format: [Full Name]_[Course]_[Today's Date].pdf, e.g. Stephen Lowe_Digital Practice_2016-08-09.pdf
- once PDFs have been created, update the fields [CertIssued] = TRUE and [IssueDate] = Today's Date, in the tblRegistration table
I really don't have the knowledge to manipulate code snippets I've found and so would be very appreciative if anyone could please help me achieve this.