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

help with access validation to cannot figure it out

P: 1
hi. ive searched the net for days for help hope some one here can help on this.

i am using micosoft access2003.

i have a table where i import fields from seach forms. as i import a field i need it to validate that a specific field ie. [power]=7.00 and that the new field [powerb] is the same as [power] or fit[eight] new field [fitb] to be eight also.

the problem is this is for multiple fields both text and numbers

basically i am combining four records into one and their criteria have to be the same to be grouped together their power, fit, make and model.

i think this has to be done in vb as the table will not allow me to add something as simple as[fitb]=[fit]
May 28 '07 #1
Share this Question
Share on Google+
2 Replies

MMcCarthy
Expert Mod 10K+
P: 14,534
I am moving this to the Access forum.

ADMIN
May 28 '07 #2

ADezii
Expert 5K+
P: 8,750
hi. ive searched the net for days for help hope some one here can help on this.

i am using micosoft access2003.

i have a table where i import fields from seach forms. as i import a field i need it to validate that a specific field ie. [power]=7.00 and that the new field [powerb] is the same as [power] or fit[eight] new field [fitb] to be eight also.

the problem is this is for multiple fields both text and numbers

basically i am combining four records into one and their criteria have to be the same to be grouped together their power, fit, make and model.

i think this has to be done in vb as the table will not allow me to add something as simple as[fitb]=[fit]
I would like to help, but I am a little confused.
  1. Post some sample data that you are Importing, and the code you use to Import it with.
  2. Post what you would like the final results to be.
  3. What is your Validation Criteria for each Field.
  4. What happens if a Field does not pass the Validation?
  5. Please provide any other information that you think is relevant.
May 29 '07 #3

Post your reply

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