Form Export?

[woodman650]

Hey all,
I'm working on an invoice system in Access and I had just wondered if there was a way I could export a form to a format I could distribute to clients? (pdf, html...etc) thanks!

 

[gemma-the-husky]

yeah,

file, export

put it to excel say, and save as formatted gives users an excel file from a form or report

pdf is hard, because access doesn't have a native pdf generator - maybe a third party addon.

you can save to excel or csv programmatically also,

docmd.transferspreadsheet or docmd.transfertext

 

[woodman650]

yeah that could work... then I could export from excel to pdf. Maybe I can find something that will handle a direct export to pdf. Anyone know? thanks!

 

[Pat Hartman]

To export an Access report to a .pdf, just "print" it to the .pdf printer. When you install the .pdf writer, it installs as a printer that you can just select like any other printer. If you don't want to purchase a .pdf writer, you can export Access reports in .snp format. The .snp is a graphical format so changes cannot be made to the image which makes it an appropriate format for an invoice. The .snp reader/writer is normally installed with Office but if for some reason you or a customer doesn't have the program, it can be downloaded for free from the MS download site.

 

[gemma-the-husky]

thanks Pat, I'll have a look at that.