input scanned documents in access 2003

[zhockz via AccessMonster.com]

greetings...i need help..does any1 knows how can i automatically input a
scanned a document, store & retrieve it (view it for later purposes) in just
1 click on a command button in ms access 2003? for example, i have a
database records of all employee in our company & each employee has a
particular training or seminar certificates. i want to scan the certificates
& store it in his files in my database & sometimes view or retrieve it for
employees needs. can it be possible? tnx in adance.

 

[Lord Kelvan]

i do this in another application but i dont have msaccess run the
scanner then automatically load the file. i have my staff scann the
file then attach it to the database then the database can then open it
and what not.

are you wanting the database to run the scanner or the latter.

You'll be really lucky if anyone know that but i can help you witht he
latter if you want.

as a note our scanner is our photocopier so it scans and emails the
user the document which he/she can then attach to the db.

Regards
Kelvan

 

[zhockz via AccessMonster.com]

i do this in another application but i dont have msaccess run the
scanner then automatically load the file. i have my staff scann the
file then attach it to the database then the database can then open it
and what not.

are you wanting the database to run the scanner or the latter.

You'll be really lucky if anyone know that but i can help you witht he
latter if you want.

as a note our scanner is our photocopier so it scans and emails the
user the document which he/she can then attach to the db.

Regards
Kelvan

tnx kelvan, i trying to figure it out also but no luck, mybe your rght. so
what should i do? our office scanner is also a photocopier (panasonic DP8035).
from the copier i fetching my scan documents to my pc. thats the way it works.
thnx

 

[Daniel Pineault]

It can be done. You can control Twain device through VBA... I had come
across the info on this very forum a while back.

I never went forward with the project to I'm affraid I can't provide you
with code, but dig through this forum and you should be able to find the
information you need.

FYI, MS' search is useless, you have to use Google Group Search tool if you
wish to actually find relevant information.

http://groups.google.ca/grphp?hl=en&tab=wg
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Lord Kelvan]

If your scanner emails you the scanned document again I don’t know how
to look into your email client and extract it i only know how to send
an email from VBA in GroupWise sorry.

Try to find what Daniel said to find if not ill try to help you set up
the attaching and opening thing I have some fresh tested and debugged
code in one of my systems I can try to modify with you for your
application.

Regards
Kelvan