Database problem

  mammak 22:33 26 Apr 05
Locked

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.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…