Nz() is part of the Access library.
You can't uncheck that, but if any other library is missing, it won't work.
Try this:
1. Write down the name of all libraries that are checked.
2. Uncheck them all except the Access and VBA libraries (which are
required.)
3. Close Access, and restart it.
4. Find the libraries that were checked, and check them again.
You may even need to re-register the library between steps 3 and 4. The
article referenced in the previous reply shows you how to do that, and
indicates which libraries you should use with each version.
Note that you should be using DAO 3.51 with Access 97, but DAO 3.6 with
Access 2002.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Roy" <(E-Mail Removed)> wrote in message
news:6E89B6C0-2EF0-4F10-83B3-(E-Mail Removed)...
> There is nothing missing.
> do you know what reference to add on to work with the nz fuction??
> thanks
>
> "Allen Browne" wrote:
>
>> Yes, you can run multiple versions of Access on the one computer. The one
>> I
>> am posting from has Access 2, 97, 2000, 2002, and 2003.
>>
>> First, check your references.
>> From any code window, choose References on the Tools menu.
>> Anything marked 'MISSING'?
>> More info:
>> http://allenbrowne.com/ser-38.html
>>
>> Post back if that is not the issue.
>>
>> More info on setup and conversion issues between Access 97 to 2002, see:
>> Converting from Access 97 to 2000, 2002 or 2003
>> at:
>> http://allenbrowne.com/ser-48.html
>>
>> "Roy" <(E-Mail Removed)> wrote in message
>> news:39E3FC35-7FE3-4544-B5AC-(E-Mail Removed)...
>> >
>> > i put 97 and 2002 on the same computer, they are on diferent folders.
>> > they work fine until i use some nz fuctions in 2002, and it comes up
>> > with
>> > "#NAME?".
>> > if i use the database only with 2002 install, it works fine. any ideias
>> >
>> > thanks
Similar Threads
