Error in DAO AddNew

[tobymom]

Function Is Not Available In Expression In Table Level Validation Expression"

This error comes up when Access tries to enter a new entry using DAO Recordset .AddNew.

Very weird thing is some machines work fine with this. All of our office computers have Win XP Pro with Office XP installed with same setting - same directories and etc.

If you have any ideas, it'll be greatly appreciated.

Thank you.

 

[randy700]

On the systems giving you trouble, check for missing references.


Randy

 

[tobymom]

Ranfy:

Thank you so much. There was a missing reference!! It works fine now.

I love tek-tips.

 

[Remou]

tobymom

It is always nice to click:

Thank randy700
for this valuable post!

 

[TheAceMan1]

tobymom . . .

We call it a [fuchsia]pinky![/fuchsia]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886