code for start scan and save

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Can any one help me pleases ?

I have DB in Access 2000 with some tables and some forms, one of those forms
when I show one record I have command button called "Scan document".

In addition, I have scanner in my PC, acrobat reader pro. Install or paper
2PDF

What I want when I click the button "Scan document" start scan document from
the scanner.
Save the file must be as PDF type and this file name must be one of the
record felid.
All those I prefer in background (scan and named the files)

What I need to that program, coded VBA?
any thing helping me and is there any deffrent if i used derrent type of
scaner ?
Thanks to every one

khal
 
Hello!

I've done that already, but I was helped by having bought the scanner
program with the code!
if you can manage to find the code of an application that scans (compatible
with your scanner), you can lunch this software from access using:
Shell "ApplicationName"
and then when your application is loaded, you get it connected to your table
and get the current record that you're working on.
put or let the user put a fileName for the pdf file and then lunch the
scaning
save and then update the access record (you can put the filePath)
and quite the application.

and when you return to access, if your record has the filePath as hyperLink,
you can open it streight.

hope it gave some ideas
 
Back
Top