Use pdf file to create report

[Rayashe]

Hi,
I have imported my data from an Excel file correctly but now need to put it
into a specific pdf file layout.
How can I place this pdf file into the reports design area so that I can
specify where various fields need to go?
Thanks.

 

[Chuck]

Hi,
I have imported my data from an Excel file correctly but now need to put it
into a specific pdf file layout.
How can I place this pdf file into the reports design area so that I can
specify where various fields need to go?
Thanks.

Open the pdf file in Adobe. Edit/Select All. Edit/Copy.

Open your data base, click on Report/New. Click on design view. Highlight
the Detail section
Edir/Paste.

The pdf form should now be in the report. Position it where ever it needs to
be so that when it is printed an a blank form, that everything lines up.

If I were doing this job, I would make a query of the table with your data so
that I could easily filter it for the data I want to print

Now place text boxes on the form every place that data will be entered. Make
the control source be your query. Print a sample on a blank form to check that
everything is still lining up.

Delete the pdf image you started with. Only the text boxes should be left in
your report.

Chuck

 

[Rayashe]

Open the pdf file in Adobe. Edit/Select All. Edit/Copy.

Open your data base, click on Report/New. Click on design view. Highlight
the Detail section
Edir/Paste.

The pdf form should now be in the report. Position it where ever it needs to
be so that when it is printed an a blank form, that everything lines up.

If I were doing this job, I would make a query of the table with your data so
that I could easily filter it for the data I want to print

Now place text boxes on the form every place that data will be entered. Make
the control source be your query. Print a sample on a blank form to check that
everything is still lining up.

Delete the pdf image you started with. Only the text boxes should be left in
your report.

Chuck

Hi Chuck,

Thanks - I understand that and did manage to copy/paste with some insert
object button.
Part I don't understand is how would I merge the database report to the pdf
if I delete it after I have placed the text boxes?
Thanks,
Ray

 

[Chuck]

Hi Chuck,

Thanks - I understand that and did manage to copy/paste with some insert
object button.
Part I don't understand is how would I merge the database report to the pdf
if I delete it after I have placed the text boxes?
Thanks,
Ray

The instructions were for printing filled in hard copies to existing blank hard
copies of a pdf form.

You will need to have a pdf printer installed in your computer. There are many
of them around and a fair number are free. Check printers in the control
panel. You may already have a necessary printer installed.

Do not delete the pdf image from your report. When you click on file/print, a
print dialog box opens. Click on the down arrow at the end of the printer name
box. Select a pdf printer.
It will make a filled in pdf file. {Report Name.pdf}

Chuck

 

[Rayashe]

The instructions were for printing filled in hard copies to existing blank hard
copies of a pdf form.

You will need to have a pdf printer installed in your computer. There are many
of them around and a fair number are free. Check printers in the control
panel. You may already have a necessary printer installed.

Do not delete the pdf image from your report. When you click on file/print, a
print dialog box opens. Click on the down arrow at the end of the printer name
box. Select a pdf printer.
It will make a filled in pdf file. {Report Name.pdf}

Chuck

Hi Chuck,

Thanks for the suggestions. I have just upgraded to Adobe Acrobat Pro 9 and
see that it has put an add-in into Access for creating pdf - so I shall have
a play around with that.
Cheers,
Ray