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.
"Kira" wrote:
> 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...
>
> "Daniel" wrote:
>
> > 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,...)
> > --
> > Hope this helps,
> >
> > Daniel P
> >
> >
> >
> >
> >
> >
> > "Kira" wrote:
> >
> > > 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
Similar Threads
