Prev: How to import data from Excel that has password protected shee?
Next: Changing data in Before Update
From: John W. Vinson on 17 Mar 2010 13:06
On Wed, 17 Mar 2010 07:50:35 -0400, "Mike B" <mDotByerley(a)VerizonDottieNettie>
wrote:

>Further, the timer function isn't the same as the timer object. Just for
>Sh*ts and Giggles, I did look in the AC2007 help and under Remarks:
>

Sorry, Mike! That was indeed the source of my confusion, and probably Owl's
confusion as well: his code was using BOTH the form's Timer property (which is
in milliseconds) and *also* the VBA Timer function. It's disquieting that
Access includes two quite different features with the same name; I had used
the Form Timer but not the Timer() function. Thanks for the heads-up!
--

John W. Vinson [MVP]
From: Mike B on 17 Mar 2010 16:12

"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message
news:ps22q5h5k34h3mpss2motjnigdushlc07t(a)4ax.com...
> On Wed, 17 Mar 2010 07:50:35 -0400, "Mike B"
> <mDotByerley(a)VerizonDottieNettie>
> wrote:
>
>>Further, the timer function isn't the same as the timer object. Just for
>>Sh*ts and Giggles, I did look in the AC2007 help and under Remarks:
>>
>
> Sorry, Mike! That was indeed the source of my confusion, and probably
> Owl's
> confusion as well: his code was using BOTH the form's Timer property
> (which is
> in milliseconds) and *also* the VBA Timer function. It's disquieting that
> Access includes two quite different features with the same name; I had
> used
> the Form Timer but not the Timer() function. Thanks for the heads-up!

That was the reason I used the parens after the Timer function statement
for clarity. At my age (I am a 1944 model), I need as much clarity as I can
muster.. ;-)

> --
>
> John W. Vinson [MVP]


First  |  Prev  | 
Pages: 1 2
Prev: How to import data from Excel that has password protected shee?
Next: Changing data in Before Update