A REAL CHALLANGE

A

AndrewDB

I need to (from within Access) 1. Open a document scanning software so that a
document can be scanned; and then, after scanning, record the file name of
the scanned document in a database without having to enter the file name by
typing it. (The scanning software automatically enters a file name for the
document in the "save as" dialogue box) As I see it the created file name
needs to be copied to the clipboard when the document is saved; and then
pasted to the correct field in the Access database. Anybody know if this can
be done?
 
T

Tom van Stiphout

On Mon, 15 Feb 2010 00:55:01 -0800, AndrewDB

RunCommand acCmdCopy
will copy to the clipboard. The difficulty will be that the name needs
to be selected and have the focus, just like if you would hit Ctrl+C
yourself.
Perhaps better to use scanning software that has an Automation
interface, so you can tell it which document name to use, or at the
least retrieve the document name used.

-Tom.
Microsoft Access MVP
 
A

AndrewDB

Hi Tom
Thanks for your response. I Knew it would not be a simple solution. Just
wondered if there was a way to capture the name of the last file saved in
Windows considering "My Recent Documents" (In XP) facility is available.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top