data validation

[sunvir.sangha]

Hello,

I'm designing a questionnaire for a friend as was wondering if you can
help me.

It is an electronic questionnaire.

I was wondering if i could have general tips about data validation i.e.
how to make the software robust so that people cannot mess it up. for
example, i ask someones age in years and i dont want them entering
text, what is the validation for that?

How do i validate 'checkboxes', i have about 5 checkboxes within a
question and if any of them are not ticked i would like an error
message of some kind.

The thing is i'm new to programming so you'l need to simplify
everything for me.

Another thing is that the results need to be sent to a Word document
and also to an excel document, i was wondering what code i will need
for both.

Thank you before hand. cheers, Tony.

 

[Doug Robbins - Word MVP]

Sure you haven't bitten off more than you can chew?

Considering that you are new at this, I suggest that you take a look at the
following:

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136

When you have digested that, to check for a numeric entry, use the IsNumeric
function.

Re you question on the check boxes, what about the case where the valid
answer is for a check box not to be checked?


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP