Re: Validation Rule for field

Tech-Archive recommends: Fix windows errors by optimizing your registry

Klatuu,

What on earth are you talking about? The facility to put field-level and table-level Validation Rules in your table design is one of Access's great features. It is very often the correct, best, and easiest approach. Why wouldn't you use this?

--
Steve Schapel, Microsoft Access MVP

Klatuu wrote: 
Absolutely wrong.  Never put validation rules in tables.
The proper way to do this would be in the Before Update event of the form.

.

Relevant Pages

  • Re: OOP/OOD Philosophy
    ... The methodology is well-documented. ... It is agile because the term 'extreme' as been so over-exposed that the ... > in which you do design can enable the team to respond to change, ... > that surveys of users have shown that nearly 50% of all features in a BDUF ...
    (comp.object)
  • =?windows-1252?Q?www=2Eelectronics=2Dmac=2Dsony=2Ecom___Motorola_KRZR_K1_Phon?= =?windows-12
    ... Product Features and Technical Details ... the KRZR K1 is the definitive handset for those who ... design, you get Bluetooth wireless technology, an integrated music ... detailing and premium materials shrouded within a distinctive metallic ...
    (alt.cellular.verizon)
  • Re: Code generation - Was: AOP in PHP - Was: OO in PHP
    ... It's called meta programming and though the concepts ... else (or there is no performance problem at all), ... There is much design humbug with respect to C++ and Java ... More features usually means more code. ...
    (comp.lang.php)
  • Re: OOP/OOD Philosophy
    ... in which you do design can enable the team to respond to change, ... Even Scrum, which is my area of practice, requires training for all members. ... We delivered the functionality that the customer desired, ... that surveys of users have shown that nearly 50% of all features in a BDUF ...
    (comp.object)
  • Re: Newbie object design questions
    ... A good profitable business needs to adapt to a changing ... And before you jump on that, I am saying that these "features" ... rather it leverages frameworks. ... IMHO it undermines the true usefulness of oo design. ...
    (microsoft.public.dotnet.languages.csharp)