Database problem

  mammak 22:33 26 Apr 2005

Hi i am ashamed to say i have a problem in access database i need to in one field put a validation rule in and a validition text but alas it wont work i need to put, Only type "DVD OR VHS" sorry its so lame but need to keep you on your toes bright peeps, again sorry kindest regards Mammak.

  harps1h 23:59 26 Apr 2005

you don't necesarily need to put in a validation rule but if you did it would read "dvd" OR "vhs"- the validation text could read please enter format. in the row required make it yes

go into the look up tab and do this

1/ make it a combo box

2/row source type should be set at value list

3/row source is then "dvd";"vhs"

try that and see what happens

  harps1h 23:32 29 Apr 2005

did you get sorted out?

  mammak 21:32 04 May 2005

Thanks harps1h i did,validation text "DVD OR "VHS" validation rule MUST BE ONE OF THE FOLLOWING, thanks again sorry i took so long to get back but college is real tough at the moment.regards Mammak.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?