If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Understanding Delete
I have a table with 3 fields making up primary key. If someone clicks the
new record button and then decides they want to scroll to a previous record, they get the 'Index or primary key cannot contain a null value' message. I assume that's because in order to scroll to a previous message the one they just created needs to be saved firt and one or more of the key fields is null. Correct? If, at that point then, a user decides they would like to delete the incomplete record, they click Edit/Delete and still get the 'Index or primary key cannot contain a null value message'. How can they delete a record that doesn't have one of the primary key fields completed? Thanks. |
#2
|
|||
|
|||
Understanding Delete
They can't delete the record, because it hasn't been saved. They have to
UNDO the record or hit ESC key. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Alex" wrote in message ... I have a table with 3 fields making up primary key. If someone clicks the new record button and then decides they want to scroll to a previous record, they get the 'Index or primary key cannot contain a null value' message. I assume that's because in order to scroll to a previous message the one they just created needs to be saved firt and one or more of the key fields is null. Correct? If, at that point then, a user decides they would like to delete the incomplete record, they click Edit/Delete and still get the 'Index or primary key cannot contain a null value message'. How can they delete a record that doesn't have one of the primary key fields completed? Thanks. |
#3
|
|||
|
|||
Understanding Delete
Undo rather than Delete.
"Alex" wrote: I have a table with 3 fields making up primary key. If someone clicks the new record button and then decides they want to scroll to a previous record, they get the 'Index or primary key cannot contain a null value' message. I assume that's because in order to scroll to a previous message the one they just created needs to be saved firt and one or more of the key fields is null. Correct? If, at that point then, a user decides they would like to delete the incomplete record, they click Edit/Delete and still get the 'Index or primary key cannot contain a null value message'. How can they delete a record that doesn't have one of the primary key fields completed? Thanks. |
#4
|
|||
|
|||
Understanding Delete
Alex wrote:
I have a table with 3 fields making up primary key. If someone clicks the new record button and then decides they want to scroll to a previous record, they get the 'Index or primary key cannot contain a null value' message. I assume that's because in order to scroll to a previous message the one they just created needs to be saved firt and one or more of the key fields is null. Correct? If, at that point then, a user decides they would like to delete the incomplete record, they click Edit/Delete and still get the 'Index or primary key cannot contain a null value message'. How can they delete a record that doesn't have one of the primary key fields completed? Thanks. You can't delete a recrd that was never saved in the first place. Have your users press Escape a couple times when they want to "cancel" the record that they started, but never saved. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#5
|
|||
|
|||
Understanding Delete
All very helpful - thank you!
"Rick Brandt" wrote: Alex wrote: I have a table with 3 fields making up primary key. If someone clicks the new record button and then decides they want to scroll to a previous record, they get the 'Index or primary key cannot contain a null value' message. I assume that's because in order to scroll to a previous message the one they just created needs to be saved firt and one or more of the key fields is null. Correct? If, at that point then, a user decides they would like to delete the incomplete record, they click Edit/Delete and still get the 'Index or primary key cannot contain a null value message'. How can they delete a record that doesn't have one of the primary key fields completed? Thanks. You can't delete a recrd that was never saved in the first place. Have your users press Escape a couple times when they want to "cancel" the record that they started, but never saved. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|