H
Hines86
I am getting "undefined function" error after upgrading from Acc 2000 to 2003.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J Steele
Just because you're having the problem with the Trim function doesn't mean
that there's necessarily a problem with the actual reference that contains
the Trim function (which, for what it's worth, is the Visual Basic for
Applications library). References are like apples: one bad one can spoil the
whole bunch!
Open any code module, then select Tools | References from the menu bar.
Examine all of the selected references.
If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.
If none have "MISSING:", 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)
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
that there's necessarily a problem with the actual reference that contains
the Trim function (which, for what it's worth, is the Visual Basic for
Applications library). References are like apples: one bad one can spoil the
whole bunch!
Open any code module, then select Tools | References from the menu bar.
Examine all of the selected references.
If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.
If none have "MISSING:", 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)
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
2003.Hines86 said:I am getting "undefined function" error after upgrading from Acc 2000 to
D
Dirk Goldgar
Hines86 said:I am getting "undefined function" error after upgrading from Acc 2000
to 2003.
Check all your references (in VB Editor, click Tools -> References...)
and look for one marked MISSING. It may not be the VBA reference
itself -- probably won't be, in fact. If you find a missing reference,
and even if you don't, follow Doug Steele's directions posted here:
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
H
Hines86
Thanks. It was a missing SQL Parser reference. This "Compile All Modules"
sounds interesting. How do I do that?
sounds interesting. How do I do that?
D
Douglas J Steele
It's on the Debug menu when you're in the VB Editor. Compile All Modules is
what the option was called in Access 97. Newer versions of Access only have
a single Compile option, which should be equivalent.
what the option was called in Access 97. Newer versions of Access only have
a single Compile option, which should be equivalent.