Thanks for the feedback.
Just to confirm I have understood whats being said...
I don't need to do anything in the SQL statement other than enclose the variable (string from textbox) with # ie
......between #" & datStart & "#.....
I have an input mask on the textbox such that the...
Hi
I have an input box with input mask for two dates as dd/mm/yyyy which I pass as variables to several SQL queries in VBA. When the date is, for example, 17th November the date is passed as 11/17/2002 (correct for SQL) but 1st November is passed as 01/11/2002. Both dates are treated in the...
Sean
I'm currently undergoing the very same thing myself. I've got the users stored in a table as they access the DB, all I need to implement now is the date, time, old field value and new field value! I'll post the salient bits of the code when I'm done.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.