PDF Loop

[dhoover via AccessMonster.com]

I have a form with a dropdown box (cboFindCustomer). When a button is
clicked on the form, a report (Customer instructions) is opened and filtered
so that only information for the customer selected in cbofindcustomer appears.

Once the report is opened, i need to be able to print it to a pdf file. I
have adobe instalelled so I already have the print driver. I do not have the
option to switch to another pdf file creator, not can I use leeben's program.
Can someone please help me with the code to print the opened file to a pdf.
thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200711/1

[Daniel]

What version of Acrobat do you have? (different version require different
coding).

Also, if you google you'll find examples. That is where I managed to find
the info to put my code together.
--
Hope this helps,

Daniel P

[Tony Toews [MVP]]

"dhoover via AccessMonster.com" <u26355@uwe> wrote:

>I have a form with a dropdown box (cboFindCustomer). When a button is
>clicked on the form, a report (Customer instructions) is opened and filtered
>so that only information for the customer selected in cbofindcustomer appears.
>
>
>Once the report is opened, i need to be able to print it to a pdf file. I
>have adobe instalelled so I already have the print driver. I do not have the
>option to switch to another pdf file creator, not can I use leeben's program.

Adobe likely have some API code you can use but you'll need to poke
about on their website. Look for Visual Basic (not .NET) as that will
usually work inside Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[dhoover via AccessMonster.com]

I'm using 6.0

Daniel wrote:
>What version of Acrobat do you have? (different version require different
>coding).
>
>Also, if you google you'll find examples. That is where I managed to find
>the info to put my code together.

>> I have a form with a dropdown box (cboFindCustomer). When a button is
>> clicked on the form, a report (Customer instructions) is opened and filtered

>[quoted text clipped - 5 lines]

>> Can someone please help me with the code to print the opened file to a pdf.
>> thanks!

--
Message posted via http://www.accessmonster.com