Point me in the direction of a good resource for learning vb validation

[JFo]

I know how to do all validation and setting default values within a table in access. However due to the nature of the current database I am designing this now all needs to be achieved at a form level.

For example I will need to display a default values for a number of different records that are actually the same field on one specific form. Furthermore I want to be able to only allow certain values to be input into specific records in same field as well.

Therefore can anyone point me in the direction of a good resource to do this in vb at form level or if they have any examples of this I would be great?

Thanks

[ajetrumpet]

are you aware that table-level validation that is set also transfers to form entries with bound fields? you can also set this at the form level via the prop sheets.

[JFo]

yes I am aware if I understand you correctly however I want to use the same field with different types of validation for each record so it needs to be done from a form level.

Thanks

[ajetrumpet]

different validation for the SAME field, having it change record by record is not normal. I won't support such a thing. sorry. good luck to ya.

[JFo]

Thanks for your feedback, I have actually been on this forum for well over a month simply attempting to discover the best way to design my database and this was the way I was encouraged to design it. Please let me know which way you would design my system as the validation is extremely important. I have multiple forum topics that you can find in my account listing however here is one of the main ones that I have started to try and figure out best way to design my system

https://www.accessforums.net/access/...ase-16943.html

Cheers

[Rainlover]

Why do you need to Validate when the user can only choose from a prepopulated list.

You can't mix Numbers, and Date with Text when the field if formated to Text.

[JFo]

I don't understand what you are talking about the user will be entering there own comment which is different for each question, different for each piece of equipment, different for each check-list.

There is no pre-populated list. It is impossible to know what would be recorded for each question

This is why I originally had a different table for each check-list

I thought this was why we chose this design?

Cheers

[Rainlover]

There is no pre-populated list. It is impossible to know what would be recorded for each question

If this is true then what is tblCheckListAnswers used for.

[JFo]

That is what I have been wondering the whole time. For every question there must be a comment and a yes, no or n/a answer. Every comment/ answer is different.

You asked me to give you an example of a number of questions and that is what I have done. Every question from tblchecklist matches up with an (possible) answer in tblChecklistAnswer.

however this is only one possible answer per question not a list of possible answers for each question.

[Rainlover]

If there is only one possible answer then why ask the question in the first place as you already know the answer.

[JFo]

there is infinite answers for each question, it is a comment whatever the inspector wants to write

[JFo]

however some questions must be dates, times, serial numbers etc so need validation for these ones and all should default to a value to make data entry quicker as well

[Rainlover]

I am struggling to understand.

Please supply a sample Question followed by the FULL answer.

Also if you have many questions how do you expect to have a different default answer for each.

[JFo]

As per the database that I poulated 1 question is

Local Isolator Identification present

The answer(s) are

ID present, shielded

and

yes

That is the same for every different question in tbChecklist and the corresponding answers in tblChecklistAnswer

Another question is

Registration Number posted on beam

and the answers are

Posted in top left

and yes

As you can see from all those questions and answers it is basically anything that can be an answer as well as yes, no, or N/A

thanks

1 more the question is

SWL sign posted on beam

and the answers are

Not Sighted

and

No

[Rainlover]

It appears that you need more than one field in your Table for results.

A Text Field, A Yes/No Field, a Number Field and a Date field. (These are examples and may not reflect exactly what you need)

Suggest that you don't use an Input Mask on the Date field. Just Format it the way you want it.

FYI. Access does not store dates. It stores Numbers. So no matter what it looks like it is still a Number. But you Must use the Date Type for your Field.