Really annoying error with Microsoft Office Access

Asked By Michael L London 0 points N/A Posted on - 06/24/2013

 

Hi,

 Access provides a number of error messages, but many are confusing to the users. I find it sometimes useful to replace the system error messages with custom error messages. The Null primary key is a case in point.

When I try to leave a record on a form without a primary key value, the form will display the following error message. I am very upset how to resolve this issue? Help me to resolve this problem. Thanks.

Error Message: Index or primary key cannot contain a null value.

• Status: Open
• Question Views: 737
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Nichols Fryman 15 points N/A #184358

Really annoying error with Microsoft Office Access

Hi Michael,
The error is because two or more primary keys are declared on different tables, stored in the MS Access.
Solution 1:
If your form control is a Text Box, you need to add a default value to it. It can generate a null string value, if proper input is not supplied to it.
Solution 2:
If your form control is a Combo box,try using UNION to set a special value, instead of representing NULL.

About Nichols Fryman

Questions
0

Answers
701

Best Answers
99

• Vote Up 0 Vote Down

• Posted on - 10/15/2013
• Question Category: MS Access