How to open a PDF file with Reader from an Access table.
This code sample is posted here for the general benefit of the PDF development community. Attribution and usage guidelines are as noted in the code source; please respect the wishes of the author when using this code.
Option Compare Database
On Error GoTo ErrorHandler
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("Filenames")
Do Until rs.EOF
' Start Acrobat Reader
Shell "c:\acrobat3\Reader\AcroRd32.exe " + rs("strFilename"), vbHide
Set rs = Nothing
Set db = Nothing
' Display error message
OK, so you want to stamp your document. Maybe you need to give reviewers some advice about the document's status or sensitivity. This tip from author Ted Padova demonstrates how to add stamps with the Stamp Tool along with related comments.