Global Bookmarks in Access to Adobe .pdf conversion

[Suzanne]

Where to start:

I have a huge Access DB that will be sorted into several hundred reports as
Adobe .pdf files. Here is my question: How can I globally create a bookmark
for each record in the "new" .pdf file. The bookmark should contain two
elements of the DB: each record may or may not have a company name, but each
record will ALWAYS have a DUNS#. Also, each record may be two or three pages
long, and I only want to mark the first page of the record with the bookmark.

Further, I have no idea if whatever I do should be created in Access (or how
to do it), or if I should create the bookmark in Adobe (or how to that).

My research has turned up the concepts of "macros", which concept I
understand but don't know how to use in this instance, as well as
VisualBasic, which I don't know how to use. Are they appropriate here? I
don't know that, either. The bottom line is that I simply don't know where
to begin...or how!

Thanks in advance to anyone who can walk me through this process, because
I'm convinced there has to be a way to accomplish this.

Sue

 

[Klatuu]

Are you using Access reports to create the pdf files?
Does a record in the pdf file = a record in the Access database?
Does each Access record contain the Duns number and the Company Name?

 

[Suzanne]

Yes, I am using Access reports to create the .pdf files.
One Access record = 1 pdf. file
Not all records have a company name (it's data from a survey and divulging
company name is not required), but all records have a DUNS#.

Sue

 

[Klatuu]

Than it will be pretty easy.
Use the report's Sorting and Grouping to Group by Duns number. In the Group
Header, put text boxes for both fields that are bound to the Duns number and
Company Name fields in the report's recordset. Put the rest of your data in
the Detail section of the report.

Now you will get a line with the number and name just above the detail data.
If you want to add a label like "BookMark = " on the line with the number
and name, you can add that, too.

 

[Tudou.com-ad]

dear sir
I think you wil be well

 

[Suzanne]

Our DB is already set up so that the Company Name and DUNS# reside in the
header, with everything else in the detail portion of the record. So, what
does Acrobat require in the report to automatically identify, create, and
record the bookmark in the .pdf?

Sue