I seem to have forgot how to use acess...

  Josquius 21:43 05 May 2007
Locked

Or expressions rather.
Very simple question really: what is the command for a integer or a text character being inputted on the validation rules?
Its not simultaneous expressions is it?
Its something like =TTTT for 4 letters but...not T clearly.

  TOPCAT® 23:00 05 May 2007

results from a Google search. TC.

click here

  Josquius 12:15 06 May 2007

I can do this but they do not give the simplest commands so easy. I know its just one or two characters

  Legolas 12:45 06 May 2007

Not sure what you mean but is this any good click here

  Josquius 13:39 06 May 2007

Sorry, my English is terrible today for some reason.

I mean I want a text field to only contain text (no numbers or anything). There was something like =TT which would mean = two text characters (but its not T).
This could be done with assuming N as numbers to be =TTTNN so BUS12 would be the only acceptable kind of data.

  TOPCAT® 13:42 06 May 2007

Don't know if you have this version but here's a pdf user manual for Access 2000. I hope this helps you. TC.

click here

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?