Search results

  1. S

    Date Range in Macro

    I recognise this is an old thread, but does this code also work on opening reports?
  2. S

    Solved How to create a search filter using a "from" and "to" date range picker on a continuous form

    I have a runtime error "3000" reserved error "3201" Private Sub BTN_REQReport_Click() Me.Filter = "[DateREQ] between #" & Format(DateFROM, "dd/mm/yyyy") & "# AND #" & Format(DateTO, "dd/mm/yyyy") & "#" Me.FilterOn = True End Sub
  3. S

    Solved How to create a search filter using a "from" and "to" date range picker on a continuous form

    Update: I have decided that I will use a click event when creating a report from a continuous form. I have a button for my report, and I have two text boxes as date pickers. where the filter condition should get the filter parameters from. This should help clarify what conditions I have to...
  4. S

    Solved How to create a search filter using a "from" and "to" date range picker on a continuous form

    Hi all, I have a continuous form with a whole bunch of dates. I would like to create a search filter with the criteria "from" date and "to" date using a date picker. I have not yet designed this, so do not have any existing code. The reason behind this request is so that I can create a report...
  5. S

    Solved How to create a dynamic search filter using text box and multiple filters on a continuous form

    Thank you for this solution, works just fine. Note, after posting the code I tidied it up somewhat. Again, Thanks.
  6. S

    Solved How to create a dynamic search filter using text box and multiple filters on a continuous form

    Hi All, I have been working on making improvements to an Asset Management Database that I have been building for some months now. I am finding it quite difficult to create a dynamic search filter using a text box to search both text and date fields on a KeyUp function. I would like your help...
View older results
Back
Top Bottom