I am using vb6 and ms-access for my database.
I used DAO to access data from ms-access, the problem is after i have entered the date and saved into my database then i realise that i do not need the date.
So, i just delete it from textbox and save it BUT the system not allow me to save the empty textbox after updated, it said "Run-time error '524': Data type conversion error."
I have set Required = No, Indexed = No for my database.
Any others way to delete it or set it to null?
P/s : This problem occur when i used data type = Date/Time