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!

 

[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.

 

[Tony Toews [MVP]]

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

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!