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

validation for a field on a form to make sure its not duplicated.

P: 2
I have a access database. I have a form that as a field that i need to check to make sure is not been duplicated. Possible validation required? The field data type is number so the user have to input data.Remember the form is taking from a query. Is it possible for me to have a vb code which checks and input the number 1 to 50 automatically for each new record? This breaking down human errors by typing a number that already exist. Do i need a loop?
Apr 13 '07 #1
Share this Question
Share on Google+
2 Replies


100+
P: 149
I have a access database. I have a form that as a field that i need to check to make sure is not been duplicated. Possible validation required? The field data type is number so the user have to input data.Remember the form is taking from a query. Is it possible for me to have a vb code which checks and input the number 1 to 50 automatically for each new record? This breaking down human errors by typing a number that already exist. Do i need a loop?
What is your exact requirement. If I understand you need to check the number that is entered by the User against the numbers that are there in the Database.

-ansuman sahu
Apr 13 '07 #2

P: 2
What is your exact requirement. If I understand you need to check the number that is entered by the User against the numbers that are there in the Database.

-ansuman sahu
its a cd database. Track numbers of a CD should not be duplicated so the cd should not have the same track number. So i need to validate track number so its not duplicated when user is added a new song on a CD. So yes to your question.
Apr 16 '07 #3

Post your reply

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