#ACROBAT PDFWRITER PDFFILENAME REGISTRY PDF#Third, you can do as I suggested in my previous post, which is send your report to your PDF printer, wait for the output, grab the file, rename it, and move it as desired. Second, you can export the report to RTF and automate Word to reinsert the graphical elements you lost on conversion to RTF then you can send to your PDF printer, naming your file in accordance with your invoice number, if you haven't already done so, and storing your file in a location that is not your PDF output directory (if you're using Adobe and worried about overwrites). You can automate the merge, file name, and PDF creation from Access. First, you can create a Document Template in Word with which to merge your data. It seems to me that you have three options. Printing to PDF is the only alternative when you want to share your reports electronically, but that's not always as desireable as a Word doc. Reports are meant to be shared, and although Access Reports can be exported in a variety of formats, each has their disadvantages. That's why I favor merging with Word to create reports over using Access Reports and exporting them to RTF. The problem with GaryB's method is that you still have to specify a filename to PDF it to when you print. Thx xCav8r, but the RTF export doesnt retain drawn lines which I have used to separate columns in the report. I hope this helps and that I have conveyed this correctly. #ACROBAT PDFWRITER PDFFILENAME REGISTRY FULL VERSION#To save as you must have the full version of Acrobat. The invoice previews and I tell it to print and it prints to the specified pdf printer and Acrobat opens with a print view of the invoice that I can either print,email or save as. When I click on the command button, the enter parameter value box appears and asks for the invoice number of the invoice I want to print. I Created a command button ?printinvoicereport? with the setting for it ?openreport? and in the view box ?printpreview? In pagesetup I set the printer to be a pdf printer I Created a report using the print invoice query as it?s data source. In that query, in the field Invoicenumber, I set the criteria with this will invoke the enter parameter value box I created a query name printinvoice based on the information from my invoice form and query. I have a query, a report and a command button:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |