I am running an external application's script file, which is of the
extension ".avsauto" (Avaya application) . I want Access to run this
script file every half hour, so that the script can integrate with the
application to export data into excel sheets. When Access calls for
this script through Hyperlink, then Windows throws up a warning message
"Do you want to run this? This may be a virus blah blah" .
I want to use Access Sendkeys to override this by doing a TAB and
ENTER. I am currently unsuccessful with this, because access keeps
running in the background, and is not the active window.
Could someone please help me with the code? I am a novice Access user.
Cheers
Sunny
Steve - 28 Dec 2005 21:13 GMT
You can actually disable the warning messages in Access (you must have
2003 if you're describing the warning I'm thinking of). It's Tools >
Macro > Security... and select Low.
sunilkeswani@gmail.com - 28 Dec 2005 21:46 GMT
Steve,
I only use Access 2000. Any other way out with the SendKeys?
Regards
Sunny
Steve - 29 Dec 2005 14:00 GMT
Wait a minute, didn't you bring this up before and get a bunch of
replies on it? That Avaya script is a pretty out-of-the-ordinary
thing...have you contacted Avaya for more information about scheduling
the script?
sunilkeswani@gmail.com - 31 Dec 2005 06:49 GMT
Yes Steve. That did not turn out to be helpful. Anyway, I will see how
else I can get this done. If it is not possible, its time for an
upgrade to a higher office version.
Cheers
> Wait a minute, didn't you bring this up before and get a bunch of
> replies on it? That Avaya script is a pretty out-of-the-ordinary
> thing...have you contacted Avaya for more information about scheduling
> the script?