Link to home
Start Free TrialLog in
Avatar of JOHN_STIBBARD
JOHN_STIBBARDFlag for Australia

asked on

Execute a command after a certain time

Hello Experts,

I'm having trouble trying to run a command after 4 PM.

I've tried the following:

If (CurrentTime >= #4:00:00 PM#) Then
         ' DoCmd
 ElseIf (CurrentTime < #4:00:00 PM#) Then
         ' DoCmd
 End If

However the first command runs regardless.

Can't see the wood for the trees - can someone please assist?

Thanks

John
ASKER CERTIFIED SOLUTION
Avatar of E C
E C
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JOHN_STIBBARD

ASKER

Thanks,

Just the kick I needed!

Cheers

John