Search results
-
D
Between operator in my VBA Code isn't working
YES!!!!!! Thank you!!!!!:D:D IT WORKS! Private Sub StartTime_AfterUpdate() Dim Start As Date Dim Finish As Date Start = #12:00:00 AM# Finish = #6:00:00 AM# If Me.ActiveControl >= Start And Me.ActiveControl <= Finish Then Me.AfterHours = 10 Else: Me.AfterHours = 0 End If...- dianna_vasher
- Post #6
- Forum: Modules & VBA
-
D
Between operator in my VBA Code isn't working
Start = #12:00:00 AM# Finish = #6:00:00 AM# If Me.ActiveControl => Start And <= Finish Then Nope.- dianna_vasher
- Post #5
- Forum: Modules & VBA
-
D
Between operator in my VBA Code isn't working
Start = #12:00:00 AM# Finish = #6:00:00 AM# If Me.ActiveControl >= Start And <= Finish Then Me.AfterHours = 10 End If isnt debugging eaither :(- dianna_vasher
- Post #3
- Forum: Modules & VBA
-
D
Between operator in my VBA Code isn't working
How do I use the Between in this? I want to set a value of 10 dollars to AfterHours if User enters a start time that is between START and FINISH. Private Sub StartTime_AfterUpdate() Dim Start As Date Dim Finish As Date Start = #12:00:00 AM# Finish = #6:00:00 AM# If Me.ActiveControl Between...- dianna_vasher
- Thread
- Replies: 6
- Forum: Modules & VBA
-
D
Delete a record with a custom cmd button
Hi all! I am building a db for reservations for my limo company. I want to have a cmd button that verifies the user to make sure she wants to delete a run. This is what I have so far: Private Sub cmdDeleteRun_Click() Dim Response Response = msgbox("Are you sure you want to delete this...- dianna_vasher
- Thread
- Replies: 3
- Forum: Modules & VBA