My Assistant
|
|
Feb 24 2012, 07:41 AM
Post
#1
|
|
|
UtterAccess Member Posts: 38 |
Hi, I hope someone can help!
I have a database that was working fine yesterday. I tired to enter in information into my form and today I am getting a pop up box that indicates I have a Index or primary key containing a null value. I have checked all of my tabels and relationships and I cannot seem to find this "null value" am I missing something? It seems I can enter in data into my table directly but not the form linked to that table.... I have looked and no relationship are broken... I am stumped. Thanks in advance. M (IMG:style_emoticons/default/iconfused.gif) This post has been edited by miedward: Feb 24 2012, 08:13 AM |
|
|
|
![]() |
Feb 24 2012, 08:54 AM
Post
#2
|
|
|
UtterAccess Member Posts: 38 |
Hey I Figured it out, all I had to do was go into my tables design view and delet the primary key row, insert a new row and selet it as autonumber and save and its working again!! DUH on my part... sometimes there is a simple answer. thanks for your help and your time. (IMG:style_emoticons/default/thanks.gif)
|
|
|
|
miedward Index Or Primay Key Cannot Contin A Null Value Error Feb 24 2012, 07:41 AM
niesz You will not be able to find it in the tables beca... Feb 24 2012, 07:45 AM
accesshawaii Are you using a free text type field as your prima... Feb 24 2012, 07:58 AM
miedward the primay key is set as an autonumber. I have tri... Feb 24 2012, 08:19 AM
BruceM I would try removing the record source from the fo... Feb 24 2012, 08:50 AM
accesshawaii Glad you got it working. Good luck with your proje... Feb 24 2012, 09:00 AM![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 24th May 2013 - 07:51 PM |