Confusing error message - Null Value (Access 2000)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Guys,

I'm constructing a form for an engineering application, when i'm in 'form
view' and I try and switch back to 'Design view' I get the error message:

"The field 'Pump Process Data (test).operation:' Cannot contain a Null value
because the required property for this field is set to True. Enter a value
for this field."

The problem is that the field 'Operation:' is not on the form in question
and is not even available on the field list for the form in design view.
There are however fields from the same table as 'Operation:' included on the
form as the form is based on query and uses fields from three different
tables.

I've checked the properties of 'Operation:' in the table it was created and
I can see no reference to the 'required property', or it being set to 'True'.

This has befuddled me and is holding back the progress of my project, which
obviously isn't going down too well with my boss, so any help/suggestions
would be very much appreciated.

Thanks in advance,
Alastair
 
Ask Access what this thing is.

Open the Immediate Window (Ctrl+G), and enter:
? TypeName(Forms![Form1]("Pump Process Data (test).operation"))
substituting your form name for Form1.

If Access responds:
Text Box
you should be able to open the form in design view and locate the text box
by selecting it from the left-most combo on the Form Design toolbar. From
there you can find out the Control Source, and trace it back.

If it responds:
AccessField
you can track it back further with something like this:
? Forms![Form1].RecordsetClone.Fields("Pump Process Data
(test).operation").SourceField

Hopefully you will be able to trace this back to the source of the problem.

The Name AutoCorrect bugs could interfere with this process, so you may want
to uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
and then compact before you begin.

There is another possible issue that could impact this if the form is based
on a multi-table query, and it related to having a Default Value specified
in the primary table, which fails when you try to use the form to create an
entry in the related table.
 
Cheers Allen - I seem to be making some progress now.

Alastair

Allen Browne said:
Ask Access what this thing is.

Open the Immediate Window (Ctrl+G), and enter:
? TypeName(Forms![Form1]("Pump Process Data (test).operation"))
substituting your form name for Form1.

If Access responds:
Text Box
you should be able to open the form in design view and locate the text box
by selecting it from the left-most combo on the Form Design toolbar. From
there you can find out the Control Source, and trace it back.

If it responds:
AccessField
you can track it back further with something like this:
? Forms![Form1].RecordsetClone.Fields("Pump Process Data
(test).operation").SourceField

Hopefully you will be able to trace this back to the source of the problem.

The Name AutoCorrect bugs could interfere with this process, so you may want
to uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
and then compact before you begin.

There is another possible issue that could impact this if the form is based
on a multi-table query, and it related to having a Default Value specified
in the primary table, which fails when you try to use the form to create an
entry in the related table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Alastair said:
Hi Guys,

I'm constructing a form for an engineering application, when i'm in 'form
view' and I try and switch back to 'Design view' I get the error message:

"The field 'Pump Process Data (test).operation:' Cannot contain a Null
value
because the required property for this field is set to True. Enter a value
for this field."

The problem is that the field 'Operation:' is not on the form in question
and is not even available on the field list for the form in design view.
There are however fields from the same table as 'Operation:' included on
the
form as the form is based on query and uses fields from three different
tables.

I've checked the properties of 'Operation:' in the table it was created
and
I can see no reference to the 'required property', or it being set to
'True'.

This has befuddled me and is holding back the progress of my project,
which
obviously isn't going down too well with my boss, so any help/suggestions
would be very much appreciated.

Thanks in advance,
Alastair
Click to expand...
Click to expand...
 
Back
Top