scanning a docuement to a specific record

[BOB]

I would like to scan in a papers docuement and attach it to a specfic record. How can this be done?

 

[Fornatian]

i have never performed a job like that before but what I would do is is look at setting up a hyperlink field in your database that links to the scanned datasource(document). Then when you click on the hyperlink the scanned in document will load -ensuring you have the correct programme for viewing the document on your local PC.

If there is a simpler answer will someone please add to thsi because I woudl like to read it aswell

 

[Jman]

I am not sure but could you scan the document as a text file then use the transfertext import command on a forms command button click properties and read the document into the table using the import fixed width specs.
This process may seem longer but if the document you wish to read to the table is always in the same format this process could save the user a lot of time and give you and the user a table to work with in dao or ado.
This is just a suggestion it really depends on the software you are using to scan the document and what you are using the document for in you project
JOHN C

 

[bornl]

Hyperlink may not solve all your problems

when a file is referenced via hyperlink you cannot edit the file (append pages) in embedded file (at least if u use acrobat). I have not tried with imaging yet so no sure that will yeild same result but consider it.

My solution to the problem was to use the shell command along with the hyperlinked value (truncated of #) to edit the file.

Just my contrib.