Stephen Lebans ReportToPDF Help Needed Part2

This questions is similiar to the one i posted on 02/03/11 07:10 PM, ID: 26797025, Which was answered and solved very good, however when i try to use it again I'm getting error's. I would like to use Stephen Lebans ReportTOPDF to create PDF's for each Unique SITE_KEY. On The database attached the Table Complete Data has 14 unique Site_Keys, i would like to create 14 PDF's by automating this task, The table is sample data but the real table contains almost 5000 PDF's i need to create. Can anybody set up the database attached using Stephen Lebans solution? Since there might be some coding involved im offering 500 points for this.

Lastly the naming convention used when exporting to pdf can be simply the Site_Key. Example 12.pdf, 13.pdf etc. and the location to save these files should be
C:\Documents and Settings\jquijano\Desktop\ReportsToPDF

Thank you very much for this help. If you have any questions please feel free to ask, i respond fast.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Do you want someone to install Lebans PDF utility and configure it for you, and build your reports and interfaces? That's not really what EE is all about. We'll be glad to help you do it, but we're not going to do it for you. Your question reads very much like a "work requirement" than a request for assistance with a coding issue.

Your database contains a table, a query and a report. You've not even installed the Lebans PDF modules, so obviously you've got some work to do.

Note that once you get the Lebans stuff installed, you can build a single report that shows the data you wish, than filter that report based on your SiteKey:

Dim rst As DAO.Recordset
Set rst = Currentdb.OpenRecordset("SELECT SiteKey FrOM YourTable")

Do Until rst.EOF
  DoCmd.OpenReport "YourReport", acViewNormal, , "SiteKey='" & rst("SiteKey") & "'"

This would "print" a unique report for each SiteKey in your database.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
Yes, the sample DB is a fully functional.
Did you investigate it?

It is fairly easy to set this up to create the PDF, the looping, as LSM outlined above, seems to be the key to your specific issue .

Like LSM, I am a little confused about the scope of what you are asking for here...

So get as far as you can on your own, then post back with a specif question.


Dare626Author Commented:
Thank you LSMConsulting and Boag2000 for the insight, perhap's I set up the question to seem like I wanted a whole project done by the EE team and that was not my intention, Upon further reading into LSM i did notice i was missing key components in the DB like the Lebans modules i went ahead and loaded them and fixed some minor things. The only part that i cannot figure out right now is the code,behind it but that is too complex for me right now. I was able to produce the reports to PDF how wanted, Thanks LSM and Coach for encouraging me to figure how to solve the question at hand.
Dare626Author Commented:
Thank you for you're proper response! I appreciate it.
Jeffrey CoachmanMIS LiasonCommented:
<The only part that i cannot figure out right now is the code,behind it but that is too complex for me right now.>

The key is understanding *how* to use it, ...not the inner workings of the code
(Which I don't understand either)

You can glean some info from the comments Stephen puts in the code.
I seems like he first exports the report to an "SnapShot" file then converts it to a PDF...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.