Using Access to create word documents and using a scanner

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • BenRatcliffe
    New Member
    • Jan 2008
    • 9

    Using Access to create word documents and using a scanner

    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!!!
Working...