Ms access and Adobe

cmatni

Registered User.
Local time
Yesterday, 23:26
Joined
Dec 11, 2006
Messages
19
Hello, i have a question or a case for you and i hope you would help me with it, after seeing your browser sample.

I have a table with 2 fields, ID and title and each title is hyperlinked into a pdf file.
i want to creat another field yes/no "choose"

My boos aked me that he wants to choose the links and then a command button print to print them all the records he chose,
Is that feasable between access and acrobat reader,
Thanks
 
To accomplish this, you need something that talks to Access AND understands Adobe format. In general, this means at the very least that you have to have a reference to this Adobe-conversant program such that you could assign references to it. I have never tried this, but the last time I looked, there was no such animal. Search the web for the combined topics of Adobe PDF format and ActiveX (or Common Object Model) support.

If you found such a beast and it at least exposed some reasonable controls and methods, you could write a VBA module to open an application object based on this (hypothetical) Adobe support program. One of those methods would be a PRINT (or QUEUE TO PRINTER) method. So if you found the right tool, you could at least write some VBA to do what you wanted.

There is ALSO the possibility that if your version of Adobe includes a command-line option to print something, you could synthesize a command line string that runs your Adobe program, names the targeted file, and includes the required print command. Then you could create a shell and run the (one-line) script to do the printing.

If the latter looks like the way you will go, search this forum for command shell operations. This topic has appeared many times, not only for printing but for many other commands as well.
 
Assuming you have Acrobat Reader on your machine, then there's already a reference available to VBA. In the VBA code window, go to Tools->References, scroll down a little and you'll see this:

Acrobat Access x.0 Type Library

The "x" will depend on the version of Acrobat Reader you are using. From there, you'll have to "distill" (get it?) what the properties and methods actually do as it's not exactly clear by their names. A good place to start is:

http://www.adobe.com/devnet/acrobat/
 
Ah, Moniker. That didn't used to be the case. Which version of Acrobat started having that?
 
Not exactly sure. I want to say since Acrobat 6.0, but I'm not 100% when that DLL became exposed to VBA. It's been around a year or so though.
 

Users who are viewing this thread

Back
Top Bottom