David Ball
Registered User.
- Local time
- Today, 10:29
- Joined
- Aug 9, 2010
- Messages
- 230
Hi,My database generates forms with a unique number displayed as a barcode.The paper forms are completed by employees and then scanned into a folder on the network in .TIFF format.I have seen other databases that can somehow “pick up” files like this and update the forms status in the database (ie, Completed), assign a completion date and create a link to the file (a PDF actually). I would really like my database to be able to do this but don’t even know where to start.• How do I get the file names for the .TIFF files to match the barcodes during the scanning process?• How do I get Access to check a “Completed” field for each document in the folder?• How do I get Access to put a link to the file in a field in the table?Thanks very muchDave