Don't *EVER* treat a date/time as a *STRING*. Period.
Only exception: When you are accepting user input from a <form>. And even then you should convert it to a DATE value as soon as you can.
First of all, since you are working in the UK, make sure you have done
Session.LCID = 2057 ' specifies to use UK dates, money, etc.
And then you should enter *CONSTANT* dates as
someDate = #24/06/2013# ' with #...# around them!
and if you are processing <form> input, you should do something like:
someDate = CDate( Request("someDate") ) 'immediately convert to a date!
And *THEN* you can use those date values with the ISODate
function I gave you.
To fetch all results for a certain date, when then the field in the database contains dates and times, you use DateValue( )
with Access, exactly the same as you do in VBScript.
SQL = "SELECT * FROM table WHERE DATEVALUE(someField) = " & ISODate(someDate)