hi there
I've got a calendar in my access Vb application and when I click the ady I want it will input that day in a text box in the follwong format dd/mm/yyyy. Then I save this with some more information into a table. The problem is when I use the following code: count3 = DSum("[Duration]", "tblIncident", "[ddate] >= #" & txtdateFrom & "#")
This code or any query I run will search date with a different format: mm/dd/yyy. any ideas on how to sort this out?
Thansk in advance
I've got a calendar in my access Vb application and when I click the ady I want it will input that day in a text box in the follwong format dd/mm/yyyy. Then I save this with some more information into a table. The problem is when I use the following code: count3 = DSum("[Duration]", "tblIncident", "[ddate] >= #" & txtdateFrom & "#")
This code or any query I run will search date with a different format: mm/dd/yyy. any ideas on how to sort this out?
Thansk in advance
