Thanks to everyone who replied to my post.

My next question is, I'm writing an alarm clock application and I'm not sure how to compare the time entered for the alarm and compare it. I'm assuming I have to use some kind of loop?

Thanks in advance!

Mike

You can use the datediff function for this.
It can go in the timer function you have from the last post so it is tested every time the time changes.

if (DateDiff("s", YourAlarmDateTime, Now()) > 0) then
 'Alarm code
 msgbox("Ring Ring Ring.....")

 'Now that the time is after the alarm time you must either disable the alarm code or change the alarm time.
 'Because it will execute every time the timer function is run.

 'Add 24 hours to alarm
 YourAlarmDateTime= DateAdd("h", 24, YourAlarmDateTime)

end if



======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

You need a timer and a combo box (cboTime)

Option Explicit
Dim n As Integer

Private Sub Form_Load()
    Timer1.Enabled = True
    Timer1.Interval = 500
    Call pfLoadcboTime
End Sub

Private Function pfLoadcboTime()
For n = 1 To 24 * 4 - 1
  If n = 12 * 4 Then
   Else
     cboTime.AddItem Format$(TimeSerial(0, 15 * n, 0), "h:nn:ss AM/PM")
   End If
 Next
End Function

Private Sub Timer1_Timer()
 If Time() = cboTime Then
msgBox "Display your message here"
End If
End Sub

See if this helps.

Dunnie