date field

[pedcab]

I am having a problem interacting between Access and VB for date fields.

I have a field that takes car of timedefined in Access. In Vb I enter a time in a textbox but whenever I try to save it, it does not allow me to. Viceversa, whenever I try to bring one from the database, it does not allow me.

Do I have to have a mask....

 

[johnwm]

Access datetime fields are delimited with # characters:

rst!datefield = "#12/1/03#"
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'