Access 97 Undefied Function Help

[dbagley]

Hello,

I keep getting an 'Undefined Function <name>' error in my Access 97 database. It seems to be random, but all of the functions are built-in functions (Round, Nz, etc.). I've search the forum & Microsoft, but can't seem to get a clear answer. Is there a bug? Is it my version? Should I just not use any of these functions in my queries.

Thanks in advance,
Bagman

 

[KenReay]

Hi

Have you checked for missing references? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dbagley]

Hey Ken,

I keep seeing the 'check for missing references', but I'm not sure how. From the module menu, I click Tools, then References. I have 4 boxes checked:
Visual Basic For Applications
MS Access 8.0 Object Library
OLE Automation
MS ActiveX Data Objects 2.1 Library

The rest are unchecked and I don't see any references to 'Missing' in the dialog box.

Thanks,
Bagman

 

[KenReay]

Hi

OK, that is how you check for missing of broken links to references.

Aince you are using Access97, it surprises me that you have the ADO library present but not the DAO library, are you making no use of DAO objects like Databsae, DAO.Recordset, Querydef, etc?

Also many functions are present in the MS Office library, I would expect to see that checked too

Worth a try? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK