Stuart,
If I have the employee information in my Access database and I want to print an employee application, what is the best way to get the information from the database on to the application in the correct blanks.
The only method I have come up with it to put Access form fields over a form that has been imported on to a blank report. The forms are too complicated to recreate in Access.
If that is the best method, I will work with it. I just want to make sure I am using the best method. Periodically forms change so the change process will add some grief it I have to recreate the report with the new pdf form.
Thanks for your reply.
Bill
Bill Singer
Minnesota, USA
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, May 3, 2019 12:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] filling PDF
I'm not sure exactly what you are understanding. I have worked with .pdf forms in both directions. That is, importing data from a .pdf into Access, and filling out a .pdf data form via Access. Is that what you are asking?
Stuart
On Friday, May 3, 2019, 10:07:42 AM CDT, Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Patty, thanks for the reply. I had thought about recreating the forms and I have done that in the past with some simple samples but the forms I am hoping to fill in are way too complicated and changing them would be a serious effort. As an example. Imagine a health insurance application.
I am not even sure if I remember how to import the form now. I believe I just inserted the PDF as an image on my Access form.
I am open to other suggestions.
Bill
Bill Singer
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, May 2, 2019 9:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] filling PDF
Hi Bill,
Without know more details about the forms you want to use, a comparable solution is to replicate the form in an Access report and incorporating the data from the da! tabase. Then you can output the report as a PDF.
One button click through. I have also done this for systems like invoicing where the process includes producing the report/pdf and saving to a specified directory. Then the process generates an email and attaches the pdf to the email.
Let me know if you are interested in more details.
Patty
Sent from my iPhone
On May 2, 2019, at 8:39 PM, 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have access 365 running on Windows 10.
I am hoping to develop a small database that gathers employees information and then displays that information on a pdf form for printing. For example, I want to print the employee application for life insurance using the information that the employee entered into the database.
The forms are alread! y developed in the pdf state.
What I am wondering is what is the best way to use Access to fill in the blanks on a pdf form. At this point the only method I have come up with is to put the pdf form in the background of a report and then put the fields of the report on top of the form. When this is printed it gives the illusion that the fields are filled in... It works fine but I am wondering if there is a better way.
I checked Youtube and did not see anyone doing what I was trying to do.
Thank you for your help.
Bill
Bill Singer
Minnesota, USA
Posted by: Stuart Schulman <stoughy@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar