[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 503
  • Last Modified:

Access Report to PDF

Hi, I have been looking at Stephen Lebans great solution to creating password protected PDF's but am not a VBA expert and so have two questions I need to answer:

1: Can the save location of the PDF be specified by referencing a field on the form?
2: Can the name of the PDF be specified by referencing a field on the form?

I have attached Stephen Lebans database and the required dll files.

Many thanks
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can tell the function where to put your report by including the full path and name. The 3rd argument is where you'd specify this:

ConvertReportToPDF(ReportName, vbNullString, Me.YourOutputPathField & "\" & Me.YourReportNameField, False, True)

jonlakeAuthor Commented:
Great, thanks for the help! Merry Xmas!

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now