By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,374 Members | 2,993 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,374 IT Pros & Developers. It's quick & easy.

Error msg

P: n/a
Hi, First time using Access instead of excel (oh what have I done !!).
I am trying to set up a list of contacts, name address ect. I have a
table called "data", which has the raw information. I have even done a
report using a wizard to show the data. My problem is in forms, I have
a form to view and enter data, so far so good. When I have completed
the relevent fields and click on the small icon at the bottom left of
the page for a new record, I get the following error msg.

The field 'Data.4th childs name' cannot contain a Null value because
the Required property for this field is to true.Enter a value in this
field.

I have then changed the view to design, right clicked on 1st childs
name and looked at the properties. I can't see any difference between
1st & 4th Child.

Any suggestions ?

Jan 24 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 24 Jan 2006 01:08:00 -0800, "Decreenisi" <cy*********@hotmail.com> wrote:
Hi, First time using Access instead of excel (oh what have I done !!).
I am trying to set up a list of contacts, name address ect. I have a
table called "data", which has the raw information. I have even done a
report using a wizard to show the data. My problem is in forms, I have
a form to view and enter data, so far so good. When I have completed
the relevent fields and click on the small icon at the bottom left of
the page for a new record, I get the following error msg.

The field 'Data.4th childs name' cannot contain a Null value because
the Required property for this field is to true.Enter a value in this
field.

I have then changed the view to design, right clicked on 1st childs
name and looked at the properties. I can't see any difference between
1st & 4th Child.

Any suggestions ?


The Required property is in the table not the form.

Open up your table Data in design view, click on the field named in the error message.
Change the Required property (lower section) to false.
Wayne Gillespie
Gosford NSW Australia
Jan 24 '06 #2

P: n/a
The error your getting would come from the table's design, not the form
design. Open the table in design view, click on the field in question, and
look at the bottom part of the window to see if Required is set to Yes.

Moving from Excel, I recommend that you take a good look at the example
databases, such as Northwind.mdb. You shouldn't have everything in one
table. Access is a "relational" database. To get the most use out of it, you
place related groups of data in their own tables with a field that links
them to the other associated tables. The most common of these is what is
known as a one-to-many relationship. For this, one table would have
information on, for example, companies, and a second table would have
information on employees. There would be a one-to-many relationship between
the companies table and the employees table (assuming none of the employees
worked for more than one of the companies).

--
Wayne Morgan
MS Access MVP
"Decreenisi" <cy*********@hotmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
Hi, First time using Access instead of excel (oh what have I done !!).
I am trying to set up a list of contacts, name address ect. I have a
table called "data", which has the raw information. I have even done a
report using a wizard to show the data. My problem is in forms, I have
a form to view and enter data, so far so good. When I have completed
the relevent fields and click on the small icon at the bottom left of
the page for a new record, I get the following error msg.

The field 'Data.4th childs name' cannot contain a Null value because
the Required property for this field is to true.Enter a value in this
field.

I have then changed the view to design, right clicked on 1st childs
name and looked at the properties. I can't see any difference between
1st & 4th Child.

Any suggestions ?

Jan 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.