troubleshooting Question

Create, name and save PDFs documents from a MSAccess form

Avatar of darls15
darls15 asked on
Microsoft AccessVBA
5 Comments1 Solution146 ViewsLast Modified:
Hi Experts

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.

Thanks
darls15
Create_Certificates.accdb
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros