VBA to print to PDF

[Sarge79]

Hello, first off I am a new member and this my first post. I did a search and found a few results but haven't been able to stitch them together.

So here is what I am trying to accomplish. I am using Access 2010. I import data into a table with numerous records. I then run a report that puts the records into a standard form. Currently when the form creates it lumps them into a multipage document. What I would like to do is have a code that will print to single page PDF. Whats more I would like it to name the document using the date a record entry of the persons name. Lastly save said PDFs to a designated folder.

Variables:

Table name: Phone
Record to name PDF: Agent Evaluated
Report name: Phone eval

Any help would be highly appreciated. Thank you all for your time.

[June7]

Review
https://www.accessforums.net/access/...pdf-25574.html
https://www.accessforums.net/import-...ges-25042.html

[Sarge79]

The second link looks like what I need. Could you help me implement it. Admittedly I am a bit new to this and I am more of a reverse engineering learner.

[June7]

I don't know your database and therefore cannot give specific code. 'Reverse engineer' the examples and attempt code for your situation. When you encounter issue, post question with code for analysis. Do you know anything about VBA programming? http://office.microsoft.com/en-us/ac...005186705.aspx

[jopap]

Install Free PDF Creator such as bullzip and use vba to print to it (it has an object library you can reference).

[June7]

I tried installing Bullzip PDFprinter but the GhostscriptLite component download and install fails. I tried downloading from another source but Bullzip doesn't find it. Ideas?