Here is the design that I have created quite a few years back when I decided to put this on a 'subform the search button no longer works I'm guessing there is a problem with the coding in the button as it works perfectly when it's on its own form

Here is the current code a person who did this for me was not one of Richard students so I would like to get it working plus yet into the format that Richard and stayed out there coding which is in it now I would like to stick to Richards methods

Private Sub Command48_Click()

End Sub

Public Sub SearchButton_Click()
Dim txtEndDates As String
Dim txtStartDates As String
Dim task As String

txtStartDates = "[DateBanked]"
txtEndDates = "[DateBanked]"
Dim strDateField As String

Const strcJetDate = "\#mm\/dd\/yyyy\#"

    
If IsDate(Me.txtStartDate) And IsDate(Me.txtEndDate) Then

strCriteria = "(" & txtStartDates & " >= " & Format(Me.txtStartDate, strcJetDate) & ")"

strCriteria = strCriteria & "AND " & "(" & Format(txtEndDates, strcJetDate) & " < " & Format(Me.txtEndDate, strcJetDate) & ")"


End If



task = "select * from TransactionsHeader where (" & strCriteria & ") order by [DateBanked]"
        
DoCmd.ApplyFilter task
    


End Sub


Public Sub Command51_Click()
' Search Financial Year
Call FSearch
End Sub

Sub FSearch()
Dim strCriteria, task As String
Me.Refresh
    strCriteria = "([DateBanked] >= #" & "1-Apr-16" & "# And [DateBanked] <= #" & "31-Mar-17" & "#)"
    task = "select * from TransactionsHeader where (" & strC

Search Dates - Tech Help

Search Seminar

Thanks Alex

Hi Michelle, if you want to send me the form I will take a look at it.

John

hello john

First of all I would like to apologize for any funny words that may appear in this message because of voice recognition it sometimes makes mistakes specially this one I'm using at the moment wow my main one is down also I like to apologize for the delay in answering health reasons I'm not able to do as much as I used to do it takes me a bit longer these days too keep up with my emails and messaging

If you are interested in helping by having a look I can send you the URL to the video which explains what I'm trying to do I've tried to look at the database which Richard wrote to see if I could figure out the coding but could not work out which part of code was the one to do with the button

Just contact me if you would like to know more such as the URL

Michelle