Database problem

  mammak 22:33 26 Apr 05

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 05

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 05

did you get sorted out?

  mammak 21:32 04 May 05

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.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch