Re: Trouble debugging: unknown function name in table-level validation expression

The table-level validation is different from the Validation Rule for the
fields in the lower part of the table design window.

In table design view, open the Properties box (View menu).
The rule for the table is in there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mog" <mojomcginley@xxxxxxxxxxx> wrote in message
news:e6GxcXpYFHA.1404@xxxxxxxxxxxxxxxxxxxxxxx
> Friends,
>
> My replicated database began throwing errors without my having changed the
> design. The main error, when I try to open a specific table is:
>
> "unknown function name in table-level validation expression"
>
> There are no values or expressions in any of the field validation
> properties.
>
> I did have the expression Now() entered as a default value in a Date/Time
> field. This worked to date, but Access now won't accept it. Clearing the
> expression does not get rid of the first error above however.
>
> I have run compact and repair. The database is in 2000 format. It will not
> convert successfully to 2003.
>
> Can anyone suggest a solution of a strategy to find the problem?
>
> Thank you.
>
> mog
>


.

Relevant Pages

  • Re: Validate Two Date Fields
    ... Whatever message you wish to display, you can place in the Validation Text ... changing the sort order, closing the form, closing Access, pressing ... Open your table in design view. ... Beside the Validation Rule in the Properties box, ...
    (microsoft.public.access.formscoding)
  • Re: Location of Validation Text
    ... validation rule is set on the table or the form. ... design and cannot find any expression built for this validation rule. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: validation code for dates
    ... Allen Browne - Microsoft MVP. ... A simple way to do that is to use the Validation ... Open your table in design view. ... Please don't use the Validation Rule in the lower pane of table design: ...
    (microsoft.public.access.forms)
  • Re: data scaling and validation for learning classifier
    ... My definitions of validation and testing are ... the standard in neural network design (See the ... Test = Current Nondesign + Future Nondesign ... your best design or fold your tent. ...
    (sci.stat.math)
  • CfP : Workshop on Model Design and Validation (MoDeVa) at Models
    ... Design and validation methods appear to be more and more necessary ... modular first order languages are suitable for this ... Robert France ...
    (comp.theory)