Database problem

  mammak 22:33 26 Apr 2005
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 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

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?