Board index Office Access

Index or primary key cannot contain null values

Index or primary key cannot contain null values

Post by Dan » Sat, 17 Jul 2004 00:30:19


When the primary key is null and a record is being
inserted I get this error: "Index or primary key cannot
contain null values"

I just want to change what the message says but I can't
seem to get any message boxes to pop up when it occures.

This is my code:
If Err.Number = 3058 Then
MsgBox "..."
End If

when should I run my code and should that work
 
 
 
Top

Index or primary key cannot contain null values

Post by Wayne Morg » Sat, 17 Jul 2004 00:39:35

This would probably be handled in the form's Error event.

--
Wayne Morgan
Microsoft Access MVP

 
 
 
Top

1. Index or primary key cannot contain a null value.

2. Index or primary key cannot contain a Null Value

3. Index or primary key cannot contain a Null value (Error 3058)

4. Index or primary key cannot contain a Null value

5. Error Message "Index or Primary Key cannot contain a null value"

6. What is meant by "Index or primary key cannot contain a Null value

7. Changing "Index or Primary Key cannot contain a null value" message

8. Index or Primary Key Cannot Contain a Null Value

9. Use of List box and 'Index or primary key cannot contain null"

10. Help: Error - Index or primary key can not contain Null value.

11. Invald or Primary Key Cannot contain a null value

12. Primary key cannot contain a null value.

13. Index or Primary Key Cannot Have A Null Value

14. Index orPrimary key cannot contain a null value error #3058

15. Primary Key Contain a Null Value

All times are UTC
Board index