Hi
How can do Insert in Access Table, without Null,
How can I to remove null before insert in Access Table
:confused:
Printable View
Hi
How can do Insert in Access Table, without Null,
How can I to remove null before insert in Access Table
:confused:
Depends on the datat type of the field your inserting a value to. Doesn't the table have its default value property set? You won't have to worry about nulls (eg. skipped fields) in the insert statement then.
Hi
The fields are text value and data field , Whe I trying insert in table return me error
tks :( :confused: :blush:
What is the error? How is thge datafield defined and on what database system?
What's your erroneous SQL query and what's the error message?
in DataBase is Text format
in VB is textbox
the error is
Field 'TB01.TB01_FONE3' cannot be a zero-length string
If you need to accept zero length strings "" for blank entries, then you have to change the property of the field in the database.
Otherwise you'll have to resort to changing the string to " " if its "", in the text box's validate event
:wave: Thank You for all :wave: