Search results

  1. J

    run query based a date range pulled from a form

    oops that sould be project and not frmproject
  2. J

    run query based a date range pulled from a form

    made changes to table and modified the assigning still getting error Dim startdate2 As String Dim enddate2 As String startdate2 = Me.start_date enddate2 = Me.end_date Dim SQL As String SQL = "SELECT FROM frmproject WHERE [RepairDate] between #" & startdate2 & "# and #" & enddate2 &...
  3. J

    run query based a date range pulled from a form

    Thank you, i will make the changes and see how it goes.
  4. J

    run query based a date range pulled from a form

    I have form with two date text boxes. One is start date and the other is end date. I want to query a table and only pull records that the date field is between the start date and end date. my code I am working on is: Dim startdate2 As String Dim enddate2 As String Me.start_date = startdate2...
Back
Top Bottom