microsoft access training class - primary key

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

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

microsoft access training class - Primary key

resolvedResolved · Low Priority · Version 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:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Server loaded in 0.09 secs.