Dinamic PDF Stamp from Access 2007 table

Posted on 2009-12-17
Medium Priority
Last Modified: 2013-11-28

I would like to have the possibility of digital stamping the pdf files attached in an Access 2007 database, by pressing a command button from a form and the stamp to contain some table fields.

I am using both Access 2007 and Acrobat Professional but I don't have much experience on scripts and programming.

 Practically the pdf file is attached in Access 2007 table field through a form and now I am searching a way of stamping the attached document with some data fields that I type in the form (data, number, and other document references ).

Does anyone knows how to do this?

Thank you very much!
Question by:radu580
  • 2
  • 2
  • 2
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 26082367
Please clearly define what you are calling a "Digital Stamp"?

If it were me I would just create another field ("StampData") in the table record to store this "Stamp" data.


Author Comment

ID: 26083048
What I mean is to create a dynamic stamp for the PDF files. The stamp should be created every time I'm pressing the button in the form, using some fields from the form, stamping the attached pdf file.  As I sow adobe professional has dynamical stamp option  only for a few elements like user name and data.

LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 26083151

Then wait a while, an Adobe Expert should be along soon.


Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

LVL 11

Accepted Solution

enriquecadalso earned 2000 total points
ID: 26104369
Ok, this is what I would try to do.

Create an access report, inserting the pdf with the ActiveX from Adobe (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21505140.html). Create the OLE object and modify its properties using vb code.

Insert, overlaping the PDF object, the fields to conform the "Digital stamp".

Create a new pdf by printing the report to a pdf file, use a temp filename.

Replace the attached pdf in the database with the new one.

LVL 11

Expert Comment

ID: 26104408
More info here http://forums.adobe.com/message/1165275.

It seems there are other ways to show the pdf in the access report http://forums.adobe.com/message/1781017

This is for the output http://forums.adobe.com/message/1163404

Author Closing Comment

ID: 31667229
Sound's like a good path to follow. I'll try after Holidays and update the forum with results. Thanks!

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question