Null field in DAO database
Can anybody advise me some code to solve this problem?
[280 byte] By [shuvo] at [2007-11-11 6:42:14] 
I have made a project in VB6 using DAO. My database is of Access 97. I have some number (numeric) fields that I don't need to use everytime. When I left the field blank it shows error and cannot update database.
Can anybody advise me some code to solve this problem?
# 1 Re: Null field in DAO database
Open your database in Access and view each table in Design mode. Ensure that the Required attribute of the numeric fields is set to "No."Phil Weber at 2007-11-11 17:28:08 >
# 2 Re: Null field in DAO database
Hi I have put the "Required" attribute "No" and also tried by putting "Default Value" 0 and also without 0. But it is showing a run-time error '3421', Data type conversion error.
Can I solve this null value problem, like we solve in ADO?
shuvo at 2007-11-11 17:29:08 >
