A REAL CHALLANGE

[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?

 

[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

 

[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.