Prev: Missing files
Next: read/write for some users, read only form others
From: zhockz via AccessMonster.com on 30 May 2010 21:21
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1

From: Lord Kelvan on 30 May 2010 21:31
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
From: zhockz via AccessMonster.com on 31 May 2010 04:02
Lord Kelvan wrote:
>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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1

From: Daniel Pineault on 31 May 2010 09:02
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.



"zhockz via AccessMonster.com" wrote:

> Lord Kelvan wrote:
> >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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1
>
> .
>
From: Lord Kelvan on 31 May 2010 16:47
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


 | 
Pages: 1
Prev: Missing files
Next: read/write for some users, read only form others