Update table from .tiff files?

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
 
Too much questions at once.
What mean "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)" ????
Have you a lot of pics (.tiff) and you like to "scan" this files, via your program, in order to know if the exist one with the same barcode as in your form ?

Try to explain step by step what you are trying to do.
 

Users who are viewing this thread

Back
Top Bottom