I have asked this question before, received some answers, but still can not fathom how to write the code in VB, everything I tried failed.
I have a query and want to filter the data by “Date Done”, and using a text box to enter the start date and another to enter the end date. I would appreciate how to do this using VB coding, would I also have to base this query on an Unbound form? I am using variables to accept Start and End date. Q_Final is the query I am trying to filter.
Dim SeqText
Sdate = Text2
Edate= Text4
SeqText = "SELECT * FROM Q_Final WHERE DateDone BETWEEN Sdate AND Edate”
Is the code above correct and if not what else is missing?
Your advise would be appreciated.
kevsim
I have a query and want to filter the data by “Date Done”, and using a text box to enter the start date and another to enter the end date. I would appreciate how to do this using VB coding, would I also have to base this query on an Unbound form? I am using variables to accept Start and End date. Q_Final is the query I am trying to filter.
Dim SeqText
Sdate = Text2
Edate= Text4
SeqText = "SELECT * FROM Q_Final WHERE DateDone BETWEEN Sdate AND Edate”
Is the code above correct and if not what else is missing?
Your advise would be appreciated.
kevsim