Minty
AWF VIP
- Local time
- Today, 01:41
- Joined
- Jul 26, 2013
- Messages
- 10,646
That's a similar method I use to get PO's signed off - they are stored as PDF's out of our accounts system to a dedicated network share.
Access reads the PO Data from the SQL Database they were generated from, and checks to see if there is an unsigned version(by name) in the folder.
If there is the Purchasing Supervisor opens the file (from the Access DB list), digitally signs it off in Acrobat, saves it with the -Signed suffix into the same folder. He then clicks the approved cmd button which emails back the originator the signed copy, deletes the unsigned version and moves the final version to a supplier specific folder for archive purposes.
Simples
Access reads the PO Data from the SQL Database they were generated from, and checks to see if there is an unsigned version(by name) in the folder.
If there is the Purchasing Supervisor opens the file (from the Access DB list), digitally signs it off in Acrobat, saves it with the -Signed suffix into the same folder. He then clicks the approved cmd button which emails back the originator the signed copy, deletes the unsigned version and moves the final version to a supplier specific folder for archive purposes.
Simples

Last edited: