[AccessD] Dirty property

[Susan Harkins]

Yeah! This is going to help me a lot. Gustav, sorry for the
misunderstanding.

Susan H.

On Fri, Jul 24, 2015 at 5:53 AM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Steve
>
> Oh, missed that completely, sorry.
>
> I checked out the field validation (didn't work) but I missed the table
> validation. Never used that for anything.
> But it works! The syntax is:
>
>     Not IsNull([SomeField]) Or Not IsNull([AnotherField])
>
> That works also when the table is linked.
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af
> Steve Schapel
> Sendt: 24. juli 2015 11:26
> Til: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Emne: Re: [AccessD] Dirty property
>
> Oh Gustav, I fear it is you who have failed to read mine, and not the
> other way around!  :-)
>
> I most certainly did read what you wrote, and my reply was directly
> thereto.
>
> It looks like you were trying to enter:
>     Is Not Null Or [OtherField] Is Not Null as a field-level validation
> rule, not a table-level validation rule.  This is different from my
> suggestion of:
>     [SomeField] Is Not Null Or [AnotherField] Is Not Null as a table-level
> validation rule.
>
> Forgive me if I have misunderstood.
>
> Regards
> Steve
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>