Built-In Functions not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a DB that was built in Access 97. There are serveral queries that use
the Mid, Right, or Left function. After converting to 2002 I am now getting
the error "Undifined function "Mid" in expersion"

I tried rebuilding the queries and can see the Mid and other functions in
the list of Built-In functions.

Any help would be greatly apperciated.

Kevin
 
Kevin said:
I have a DB that was built in Access 97. There are serveral queries that use
the Mid, Right, or Left function. After converting to 2002 I am now getting
the error "Undifined function "Mid" in expersion"

I tried rebuilding the queries and can see the Mid and other functions in
the list of Built-In functions.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Common problem. Open a VBA module. On the menu bar select Tools >
References. Make sure any Missing items are removed. Make sure you
have a VBA library checked, like "Visual Basic for Applications" or
"Microsoft Visual Basic for Applications Extensibility 5.3." Compile
and compact.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQl7Xy4echKqOuFEgEQIAKQCg86Ks2SMa4sFwpfOzkGQmbKeKUOoAoPC6
r0lQJW3jToXKSxsg7dqDpiTM
=6BaC
-----END PGP SIGNATURE-----
 
Back
Top