Hi Liz,
Would Windows Task Scheduler work instead? Access Timer events can have
other problems too, especially after a few days ... and if you do use
Access anyway, perhaps lengthen the time interval. You can probably run
an update query or something -- be much better than using SendKeys
respectfully,
crystal
http://www.MsAccessGurus.com
connect to me, let's build it together
~ have an awesome day ~
On 5/3/2017 10:25 AM, Liz Ravenwood liz_ravenwood
[MS_Access_Professionals] wrote:
> Pros, I have a database that runs on a timer and is supposed to run every 6 hours. It has to run within Citrix. Citrix has a timeout of 3 hours of inactive keyboard input to go to disconnect, and then another 2 hours to log out. My timer event is set on a one minute interval but only runs the report at 3 and 9 AM and PM.
> This all works beautifully as long as I am logged in and keeping my session active.
>
> So, I coded a SendKeys("{ENTER}") to happen at the one minute interval hoping that this would keep the session active, but it did not.
>
> Suggestions? Ideas? Thanks.
>
> Respectfully,
> [RCEmailSigLogo]
> Liz Ravenwood
------------------------------------
------------------------------------
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
Tidak ada komentar:
Posting Komentar