Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access training class - primary key

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training class - Primary key

microsoft access training class - Primary key

ResolvedVersion Standard

David has attended:
Access Introduction course

Primary key

I have recently put a new client into the database. All ok.
Then I need to create a new form, with client details of monthly sales. As soon as I go to save I am told that the "Index or Primary key cannot contain a null value."
However I have put one in the database. It is a reference code made up of the clients name.
We have been using this system for quite awhile. It was originally set up by someone who has since left the company and the Primary key has been established with using the clients name as the code.
What am I doing wrong?
Any advice will greatfully received.

Edited on Thu 13 Sep 2007, 15:50

RE: Primary key

Hi David

As I cannot see your database, I do not exactly what the problem is. I would make sure that you are definately entering the primary key in the correct field and that the primary has not been used before.

Hope this helps
David

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.