Filter by Date from Mainform textbox Simple but Desperate trying code everywhere :(

[radian89]

Hi All,

I'm desperate searching and trying VBA code for filtering by Date. I have main form with 2 unbound textboxes, each is StartDate, and EndDate. the goal is to able search/filter based on start & end date. if there's no data in the textboxes it'll display all data.

both StartDate & EndDate textbox is Unbound & formatted Short date and Show Date Picker = For Dates

I've been lookin for allen-browne code but that's too confusing for me (newbie here).

the form is name DailytransSummF. I'm attaching the database.


Thanks a lot for the help.

[ranman256]

After you enter the dates,click the filter button,
the code goes in btnFilter_click event,

me.filter = "[date] between " & txtDateStart & " and " & txtDateEnd
me.filterOn = true

[radian89]

After you enter the dates,click the filter button,
the code goes in btnFilter_click event,

me.filter = "[date] between " & txtDateStart & " and " & txtDateEnd
me.filterOn = true

Hi Ranman256,

I intend to hide the filter button (or navigationbutton). so I only use command11 button to do the search.
thanks for the help.

[radian89]

I've done it.
the filter works, after googling.

got the code from :
http://www.access-programmers.co.uk/...d.php?t=278246

thanks to Master VBALnet, and pds8475 to provide exactly like my situation