By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,777 Members | 1,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,777 IT Pros & Developers. It's quick & easy.

Autonumber in data entry form causing blank entries into table

P: 2
I am working on a database, and have been having some trouble with the auto number feature. Occasionally, the data entry form is saving blank records into the table. I am trying to figure out a way to create a record validation rule to not update an entry when the auto number field is the only one that contains data. I'm pretty new to access, and can't seem to figure out how to do this. Can anyone help?

Thanks,

Johnny
Feb 23 '07 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi Johnny

If you set one of the other fields to Required (Duplicates OK) in the table design properties then it won't save any record without data in that field. Make sure it's a field that will always contain data in a valid record.

Mary
Feb 23 '07 #2

P: 2
Thanks for the quick answer...

Unfortunately, there are no fields in the table that will always be populated (save for the autonumber). Is that really the only way to do it? I'm just trying to keep it so that once it is built, my colleagues can make inputs easily, and I will be able to spend less time and energy going back in and reorganizing it. Not to mention, blank entries will screw up the querying system that I have worked out...

Any advice?

Thanks again,

Johnny
Feb 24 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks for the quick answer...

Unfortunately, there are no fields in the table that will always be populated (save for the autonumber). Is that really the only way to do it? I'm just trying to keep it so that once it is built, my colleagues can make inputs easily, and I will be able to spend less time and energy going back in and reorganizing it. Not to mention, blank entries will screw up the querying system that I have worked out...

Any advice?

Thanks again,

Johnny
This is really the only way unless you get into complicated validation using VBA. There must be one field that you can make required. Even if it's a matter of setting a value like N/A or something into it. What about the foreign key reference to another table.

Mary
Feb 26 '07 #4

NeoPa
Expert Mod 15k+
P: 31,489
Perhaps if you were to post the table's MetaData (re-usable example below) then we could think of an appropriate way for you. It can depend on exactly what you're working with.
Expand|Select|Wrap|Line Numbers
  1. Table Name=tblStudent
  2. Field; Type; IndexInfo
  3. StudentID; Autonumber; PK
  4. Family; String; FK
  5. Name; String
  6. University; String; FK
  7. Mark; Numeric
  8. LastAttendance; Date/Time
Feb 26 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.