[AccessD] Function No Go

Many thanks, Joe Hecht and Jim Dettman. Exactly the problem - and it was
DAO. Having that hint of DAO cut the corners and made it a very quick
correction. (I had feared it might take an hour or more). Most grateful.
Cheers
paul

-----Original Message-----
From: Jim Dettman [mailto:jimdettman at earthlink.net]
Sent: 11 November 2004 13:13
To: Access Developers discussion and problem solving
Subject: RE: [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