PDF file

[history]

Hello Friends

I have my database ,,, and I designed some official forms to be filled from the data stored in employees table ,, in order to print out these forms filled with data.

My problem is : the government developed a new design for these forms in PDF format ,, and ordered us to fill the data in these forms and print out them again ,,, now it's a very big problem to me that I have to fill one by one all these forms in the time I have more than 1000 employees ,,, it will cost time and effort ,,, because before I was printing any number of forms with one click , as I have all data stored.

My question is : is there any way to join this PDF file to my table ???
or any solution you can advise me.

Thank you in advance

and waiting to hear from you

 

[HiTechCoach]

Hello Friends

I have my database ,,, and I designed some official forms to be filled from the data stored in employees table ,, in order to print out these forms filled with data.

My problem is : the government developed a new design for these forms in PDF format ,, and ordered us to fill the data in these forms and print out them again ,,, now it's a very big problem to me that I have to fill one by one all these forms in the time I have more than 1000 employees ,,, it will cost time and effort ,,, because before I was printing any number of forms with one click , as I have all data stored.

My question is : is there any way to join this PDF file to my table ???
or any solution you can advise me.

Thank you in advance

and waiting to hear from you

Depending on the design of the PDF, it may be possible to merge it with data exported form you database in XML format.

What I have done often with success is to embed the PDF in the background of a report. I place text boxes over the PDF.

 

[highandwild]

Can you get the original source document from the government? I may have been done in something like Word or Publisher.

You could double print, have a source of the PDF's printed and put the paper through the printer again. Clumsy but it gets the job done.

I use Clickbook for various things, there must be something similar that will print two pages at once.

I'll keep my eye out.

 

[history]

Depending on the design of the PDF, it may be possible to merge it with data exported form you database in XML format.

What I have done often with success is to embed the PDF in the background of a report. I place text boxes over the PDF .

Thank you for reply
This is wonderful solution ,but how to do in this way ???

waiting to hear from you

 

[history]

Can you get the original source document from the government? I may have been done in something like Word or Publisher.

You could double print, have a source of the PDF's printed and put the paper through the printer again. Clumsy but it gets the job done.

I use Clickbook for various things, there must be something similar that will print two pages at once.

I'll keep my eye out .

Thank you for reply
In fact I did this 3 days ago but sometimes the problem occurs
because the printer cannot adjust the places accurately and you know this is official forms , so it should be accurate, the data sometimes go outside the desired place and it shouldn't be happened.
Hope to declare my point

Thanks again for your help
waiting you

 

[history]

Hello friends

I still need a help

There is nobody can ????
​

 

[highandwild]

I've just been able to save the contents of a PDF file to the clipboad and paste it into a MSPaint as that is all I have on this LAptop,

Save it as a JPEG file and set it up as the Picture on the Format tab of the Access report properties.

This takes a few seconds for each one but may not be practical for your scenario.

Give it a go and see what happens.

Try using a better image editor such as Paint Shop Pro or Fireworks.