Create PDF from form

[Guest]

I have a form with check boxes that indicate what information to include in
the report. How do I create a button/what is the code to have the form saved
as a PDF?

Another question, is it possible to have a button on the form export the
report to Word?

Thanks

 

[Guest]

Look at http://www.lebans.com/reporttopdf.htm with this you could easily
automated the creation og pdfs from a form

As for exporting your report to word take a look at the OutputTo Method but
you'll loose certain formating (lines, images,...)

 

[Guest]

I was looking at that site and quite honestly I'm new to Access and it's not
very clear to me what I use...

 

[IUnderstandSomething]

I was looking at that site and quite honestly I'm new to Access and it's not
very clear to me what I use...








- Show quoted text -

If you are new - do this:
-Install a PDF-maker (PrimoPDF or other)
-When in the form and every box is set, use File/Print/Choose printer
PrimoPDF etc..

Good luck!

Sincerely

Hans Kristian Eide

 

[Guest]

Don't give up that easily. Lebans application is worth the effort. I am no
programmer and I got it to work.

First, download it to your PC and start the application. Use the
instructions to save the two .DLLs to your system32 folder. Close the app.

Next, test the application by itself. If no problem then close the app.

Now start your application. Import Lebans table (customer), his forms (two
of them), his reports (three of them), and his Modules (two of them:
clsCommonDialog and modReportToPDF) into your application. You may not need
anything except the form and two modules but you can delete the objects later
if you want to. (Import is under File > Get External Data. You can use the
Select All on the Tables, Forms, Reports and Modules tabs. Click OK.)

Now create a command button on one of your forms to open the form
"HowToUse". Drop out of design mode and click on the button. You should see
all of the reports in your app. Select one of them and click the bar at the
bottom of the Convert Report to PDF tab.

Voila.

LDN

System: I am running Access 2003 and I don't have Adobe Acrobat installed.