Jumat, 03 Mei 2019

RE: [MS_AccessPros] filling PDF

 

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: <bill.singer@at-group.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar