[AccessD] Function No Go

As Joe said, it's references.

 Open a module in design view, click tools/references.  Look for any listed
as MISSING or BROKEN.  If they are, you'll need to figure out why.  If none
are, check any unchecked reference, close the MDB and Access, re-open and
uncheck the reference just checked.  Then try a compile.

  If still no go then a lib needs to be re-registered with regsvr32 (usually
it's DAO).

Jim Dettman


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Paul Rodgers
Sent: Thursday, November 11, 2004 6:06 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Function No Go


A new machine comes my way, and beautiful as it is, it is too haughty for
Functions. 'Functon is not available in expressions in query expression ...
' and then quotes the simplest function I've been using for ages. Is there a
Preference or some sort to encourage it to think differently, please.
Access2K. Cheers
paul

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com