Search results

  1. 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...
  2. 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.
  3. 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 :(
  4. 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...
  5. 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...
Back
Top Bottom