Dinamic PDF Stamp from Access 2007 table

Posted on 2009-12-17
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
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    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

    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

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


    LVL 11

    Accepted Solution

    Ok, this is what I would try to do.

    Create an access report, inserting the pdf with the ActiveX from Adobe ( 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

    More info here

    It seems there are other ways to show the pdf in the access report

    This is for the output

    Author Closing Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    The Adobe PDF proprietary file format is recognized as secure and formulated. But these PDF files are also prone to corruption and any external threat like virus attacks, improper storage can hit PDF file integrity.This type of damages can make cruc…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now