Re: Timer function interrupted
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Aug 2007 17:34:03 -0400
Even if it doesn't, you're only asking for trouble using SendKeys.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Mark CHP IMD" <MarkCHPIMD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:15030D4B-720D-4AFF-A0B6-3DC10D4815BD@xxxxxxxxxxxxxxxx
I have a pop up form that I'm trying to use as a progress meter that works
off the forms timer property. The following code works great when there is
no
other code working on another form, for example, DoCmd.RunSQL. If I put
the
objects on the main form I still find it interrupted by other code.
Does running SQL stop the timer function on a form as apparently it seems
to?
If MForm.[MeterBase].Tag = "Forward" Then
MForm.[Meter].Width = MForm.[Meter].Width + 0.01 * 1440
If MForm.[Meter].Width > 1.975 * 1440 Then MForm.[MeterBase].Tag =
"Backward"
Else
MForm.[Meter].Width = MForm.[Meter].Width - 0.01 * 1440
If MForm.[Meter].Width < 0.025 * 1440 Then MForm.[MeterBase].Tag =
"Forward"
End If
If Not MTask Then DoCmd.Close acForm, MForm.Name: SendKeys "{F11}",
True
Thanks for your input.
Mark
.
- Prev by Date: Re: Posting in Word issue
- Next by Date: Re: Access 2003 Reports
- Previous by thread: Re: Posting in Word issue
- Next by thread: Re: Timer function interrupted
- Index(es):
Relevant Pages
|
