Undefined function IsNull in expression

  • Thread starter Thread starter Kate McDonald
  • Start date Start date
K

Kate McDonald

Access 2000 displays the message "Undefined function IsNull in expression"
when I try to run a query using the IsNull function in a query field.
Access displays the same message for Len and other built-in functions.



The functions worked on an NT machine running Access 2000, but not after I
e-mailed the mdb file to my home computer.



I'm running Windows XP on a Dell Inspiron 8100 laptop, Microsoft Access 2000
(9.0.2720), and Visual Basic 6.3 (according to Help About in the VB Editor
accessed from Access.



The following References are selected in the Available References list:

- Visual Basic for Applications

- Microsoft Access 9.0 Object Library

- OLE Automation

- Microsoft ActiveX Data Objects 2.1 Library

- Microsoft DAO 3.6 Object Library



I've tried the following fixes suggested in several posts to this and other
newsgroups.

- Microsoft Visual Basic for Applications Extensibility 5.3 is not
selected in References

- No references are missing

- I downloaded a References Wizard, but got the message that it was
for a previous version of Access

- The SandboxMode Hkey is 2 (not 3)



Several Knowledge Base articles purportedly deal with this problem, but when
I search for them there is no text: Q197110, Q248941, Q208218, Q208884,
etc.



Thanks in advance for any suggestions.
 
Often when no references show as MISSING:, it'll work if you select an
additional reference at random, back out of the dialog, then go back in and
unselect the reference you just added. If that doesn't solve the problem,
try to unselect as many of the selected references as you can (Access may
not let you unselect them all), back out of the dialog, then go back in and
reselect the references you just unselected. (NOTE: write down what the
references are before you delete them, because they'll be in a different
order when you go back in)
 
Access 2000 displays the message "Undefined function IsNull in expression"
when I try to run a query using the IsNull function in a query field.
Access displays the same message for Len and other built-in functions.
Click to expand...

See the following page at Doug Steele's web site dealing with the references
issue:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

This page is one of the most comprehensive collection of helpful (and
educational <g>) information I have seen on the subject and should get you on
the right track if it is a references problem (and it sounds like one to me).
 
Thanks for your response. Alas, I forgot to mention that this is one of the
steps that I already tried as it was suggested in another post.

Do you think reinstalling Access would help?
 
It's possible, but I'd hold out as a last resort.

On the workstation where it works, check where each referenced file is
located, and go and check the version of each file. Check that the same
version exists in the same location on the workstation where it doesn't
work.

As for the various KB articles, they should all be there. I checked 197110
just now, and got text.

Try:
http://support.microsoft.com/?id=197110
http://support.microsoft.com/?id=248941
http://support.microsoft.com/?id=208218
http://support.microsoft.com/?id=208884

(or, as Bruce suggested, my page
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html )

And assuming the References Wizard you downloaded was Terry Kreft's and Dev
Ashish's from http://www.mvps.org/access/modules/mdl0022.htm at "The Access
Web", it's in Access 97 format, but you should be able to convert it to
Access 2000 without any difficulty.
 
Back
Top