Time Bracket Code

[Survane]

Is this correct?

If Time > #1:00:00 PM# And Time >= #2:00:00 PM# Then
If CurrentUserInGroup("usrgrp1") = False Then
MsgBox "This is usrgrp2's time"
DoCmd.Quit
Exit Sub
End If
End If

 

[jebry]

Hi!

Do you want the first line to read:

If Time > #1:00:00 PM# And Time <= #2:00:00 PM# Then

instead of:

If Time > #1:00:00 PM# And Time >= #2:00:00 PM# Then?

Where is this code running?


Jeff Bridgham
bridgham@purdue.edu

 

[Survane]

This code is running behind my splash form. I want to see if the time is between 1 and 2 PM.

 

[jebry]

Hi!

Then definitely change the code as I have it in my previous post. Also, it looks like you would want to change the user group being passed to the module to usrgrp2.

hth


Jeff Bridgham
bridgham@purdue.edu