A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

input scanned documents in access 2003



 
 
Thread Tools Display Modes
  #1  
Old May 31st, 2010, 02:21 AM posted to microsoft.public.access.forms
zhockz via AccessMonster.com
external usenet poster
 
Posts: 7
Default input scanned documents in access 2003

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/For...forms/201005/1

  #2  
Old May 31st, 2010, 02:31 AM posted to microsoft.public.access.forms
Lord Kelvan
external usenet poster
 
Posts: 637
Default input scanned documents in access 2003

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
  #3  
Old May 31st, 2010, 09:02 AM posted to microsoft.public.access.forms
zhockz via AccessMonster.com
external usenet poster
 
Posts: 7
Default input scanned documents in access 2003

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/For...forms/201005/1

  #4  
Old May 31st, 2010, 02:02 PM posted to microsoft.public.access.forms
Daniel Pineault
external usenet poster
 
Posts: 658
Default input scanned documents in access 2003

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/For...forms/201005/1

.

  #5  
Old May 31st, 2010, 09:47 PM posted to microsoft.public.access.forms
Lord Kelvan
external usenet poster
 
Posts: 637
Default input scanned documents in access 2003

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.