Access 2010 function failed

Hello All,

I installed MS 2010 on a new computer with windows 10 pro 64-bit

when i run my application i get the following errors.
"Undefined function 'nz' in expression"
or "Method 'Item' of object 'Forms' failed"
i already installed twice also with Run All my computer

can you help please?
Thanks in advance
LVL 1
frimyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SquigglyMonkeyCommented:
If this 'application' runs on another computer, there are probably some functions or modules installed on that system that are not present on this new one.
0
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
are you running VBA codes in your Access program? if yes, try go to the Visual Basic Editor, and then go to Tools > References, and see if there's any library missing there. If yes, then try to fix it and try run your program again.

Visual Basic for Applications (VBA) functions break in a database with missing references
https://support.microsoft.com/en-sg/help/283806/visual-basic-for-applications-vba-functions-break-in-a-database-with-m
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
As Ryan has said, the issue is with references. You usually see the "common" VBA functions break when there is a missing reference. As the compiler loads references, it comes across a broken reference, and stops. Thus it never gets to the VBA reference, and the NZ function is never loaded into your project. Fix the missing reference and you should be good to go.

When migrating a project from 1 version of access/windows to another version, it can be a good idea to also do a decompile.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
and on the references (which is the problem), if none are listed as "MISSING" or "BROKEN" then:

1. Check any unchecked reference
2. Close the DB and Access
3. re-open and un-check the reference you just checked (it will be the last one).
4. Compile.
5. Save and close the DB, then close Access.
6. re-open and you should be good to go.

 This procedure forces VBA to refresh the references in the VBA project.

Jim.
0
frimyAuthor Commented:
You basically all said about the Reference, and it was a missing Reference.
I new that I have to uncheck the missing reference if I don't want to use it.

I have one particular form that is using a reference (but I'm not using this form all the time)
after I unchecked this reference it still didn't work, only when I deleted the Form.
This is something new, I didn't have to delete the form until now with the new computer.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 10

From novice to tech pro — start learning today.