Forums

This topic is locked

Cannot add to db with blank fields

Posted 23 years ago
1
has voted
23 years ago Saeed Abdi posted:
My site works ok, and I can add, delete and update the database but I have this problem where I cannot leave any field blank. What I want to do is to have someone enter a record in the db but it will not be complete after few days someone else will update the database, so my problem is how to enter some of the fields while leaving the rest blank

Replies

Replied 23 years ago
23 years ago Tuan Hoang replied:
Greetings xlarge:
I'm not sure how any of the active members on this list would respond, but from my limited knowledge, you would have to make sure your Database allows null (empty) values in the all of your fields or just the fields that you want to allow to be blank. In Microsoft Access, I believe it's to set the field to Not be required. Hope this helps.
Replied 23 years ago
23 years ago Rick Harding replied:
In access there is a property for a field that is "allow empty string".
Required is another issue.

Rick Harding
U of M CS Student / Network Admin for MSU FAME
www.ricks-web.info
"Techies just think differently...at least that's what they keep telling me"
Replied 23 years ago
23 years ago cap lock replied:
If you are using Access DB make sure that "Allow Zero Length" is set to YES and "Required" is set to NO.
Replied 23 years ago
23 years ago cap lock replied:
Oh by the way, here is a link that i ran through while browsing. Hope this is what you are looking for.

www.robgt.com/ultradev/tutorials/blankentries.asp
Replied 23 years ago
23 years ago Saeed Abdi replied:
Thanks guys, isn't easy when you know how.

Reply to this topic