Hi There,
I'm wondering if you super programmers can help me. I have been asked to develop a database for recording all incoming and outgoing post. Physically recieved letters will need to be scanned and saved (as a pdf or word doc or something) that can be linking in access (i'll be using a hyperlink no doubt).
I have got very little experience automating word file creation and using twain and scanners etc with access, so would anyone be able to give me any pointers?
Basically i will need the user to create a record and at some point during this they will opt to scan the letter which will then pop up word which will contain a macro or the scanner software. I would ideally like the filename to be called the unique key in the database (or contain it) and save it in a specific location. then the file is linked to the database record.
Is this possible? Thanks in advance!!!