When I export the form to PDF (form view) I find the last part of the first page is the first part of the second page, and the last part of the seond page is the first part of the third page, etc......... I want each page in the form is in a single page in the PDF (single page not single file), HOW CAN I DO THAT??
Export to PDF
- Thread starter fathyano
- Start date
- Local time
- Today, 06:42
- Joined
- Feb 19, 2002
- Messages
- 47,466
If you had the professional version of Adobe (on every computer that needed to run this code), you could use automation. Why would that be easier than making a report? The report doesn't need all the editing code that the form has. It may not need any code at all. You could even start by copying the form controls and pasting them into a report and then rearranging them.
Not sure what you mean by automation. I have been given a form in adope pdf format that needs to be used to submit information to a company. They want that specific form. I want to use information in an access data base to fill out that pdf form. I could make a copy of the adobe form in access reports that may work but thought it to be easier to some how export to the fields of the adobe form. I do have the professional version of adobe acrobat 9 on my machines. Can you name the fields in the access database with similiar names as the fields in the adobe form and export? I have looked all over for an example of VBA code to do this but have not found anything.
Thanks for your help
Thanks for your help
- Local time
- Today, 06:42
- Joined
- Feb 19, 2002
- Messages
- 47,466
You're going to have to get the code sample from Adobe. The automation client (in this case Adobe) defines its interface and tells you what methods and properties you can use to interface with it. You may not find a VBA sample. If you're lucky, you'll find a VB sample. VB.Net or other .Net language samples won't help you. Change your search from Access/VBA/Adobe to VB/Adobe and you should have better luck.
