By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,084 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,084 IT Pros & Developers. It's quick & easy.

Creating PDF's and Bookmarks

P: n/a
I automatically generate several PDF a night from a DB I manage. Below
is a snippet of code that just tweakes the registry settings to store
path and filename then prints the PDF. Typically a report is compiled
of multiple sites and I was wondering if there is a way to add
bookmarks to the PDF's. I'm also familiar with some visual basic
methods to merge single PDF's into one. But I dont know how, if
possible, to add bookmarks.

Can anyone offer suggestions?
code follows

adhSetRegistryValueFromPath "\HKEY_CURRENT_USER\Software\Adobe\Acrobat
PDFWriter\PDFFileName", "J:\TAC\WEB\pm_reports\" & hold_rs!UserName &
".pdf"

Print_Adobe.ChangeToAcrobat
DoCmd.OpenReport "discrepancy_report", acViewNormal
Print_Adobe.ResetDefaultPrinter
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
SA
Thomas:

Our PDF and Mail Libray for Access, PDF Pro Plus Edition, will allow you to
create bookmarks for your PDF files created from Access reports, including
nested child bookmarks. You'll find it on our web.

HTH
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Thomas Anderson" <th****************@hotmail.com> wrote in message
news:3c**************************@posting.google.c om...
I automatically generate several PDF a night from a DB I manage. Below
is a snippet of code that just tweakes the registry settings to store
path and filename then prints the PDF. Typically a report is compiled
of multiple sites and I was wondering if there is a way to add
bookmarks to the PDF's. I'm also familiar with some visual basic
methods to merge single PDF's into one. But I dont know how, if
possible, to add bookmarks.

Can anyone offer suggestions?
code follows

adhSetRegistryValueFromPath "\HKEY_CURRENT_USER\Software\Adobe\Acrobat
PDFWriter\PDFFileName", "J:\TAC\WEB\pm_reports\" & hold_rs!UserName &
".pdf"

Print_Adobe.ChangeToAcrobat
DoCmd.OpenReport "discrepancy_report", acViewNormal
Print_Adobe.ResetDefaultPrinter

Nov 12 '05 #2

P: n/a
In addition to purchasing tools that others offered, you may want to
read the free reference manual that comes with the Acrobat SDK. The SDK
provides a number of objects that allow you to manipulate contents of
PDF pages, bookmarks etc.
You can also combine bookmark management via the SDK with the Java
abilities of Acrobat itself.
I use bookmarks management extensively in one of my Access databases. I
must add that I encountered a couple of fatal glitches when using the
SDK (v. 5). Mainly, I had problems with re-using the same file objects
and, subsequently, bookmark trees. The code eventually crashed, unable
to open any more PDF files. I am saying this so that you are not
surprised if the SDK acts up with VBA.
But in the end, it works great.
Good luck,
Pavel

Thomas Anderson wrote:

I automatically generate several PDF a night from a DB I manage. Below
is a snippet of code that just tweakes the registry settings to store
path and filename then prints the PDF. Typically a report is compiled
of multiple sites and I was wondering if there is a way to add
bookmarks to the PDF's. I'm also familiar with some visual basic
methods to merge single PDF's into one. But I dont know how, if
possible, to add bookmarks.

Can anyone offer suggestions?

code follows

adhSetRegistryValueFromPath "\HKEY_CURRENT_USER\Software\Adobe\Acrobat
PDFWriter\PDFFileName", "J:\TAC\WEB\pm_reports\" & hold_rs!UserName &
".pdf"

Print_Adobe.ChangeToAcrobat
DoCmd.OpenReport "discrepancy_report", acViewNormal
Print_Adobe.ResetDefaultPrinter

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.