Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Functions

Status
Not open for further replies.
hollyann

hollyann

Technical User
Apr 12, 2000
15
US
I converted an Access 95 database to 2000 and now I get the error message:

Run- Time Error '3085'
Undefined Function Mid in expression

The Left and Right functions do not work either.

How do I make these functions work again?
 
Sort by date Sort by votes
This usually happens if your references are not in order meaning your Access 95 DB contains references that your Access 2000 does not.
You can check that by opening a module window and selecting from the menu "tools" -> "References" compare the 2 databases to see which references you are missing.

Regards.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

chunter33
  • Locked
  • Question
Access 2007 Cstr() Versus Str() SQL Functions 1
Replies
9
Views
161
TheAceMan1
TheAceMan1
nikilee
  • Locked
  • Question
Can Access calculate similar to Excel's offset/match functions?
Replies
3
Views
52
Remou
Remou
cbarrol
  • Locked
  • Question
Functions not working in Access 2000 2
Replies
7
Views
53
cbarrol
cbarrol
vamoose
  • Locked
  • Question
How Access 2000 functions when launched via shortcut ?
Replies
5
Views
49
gearhead03
gearhead03
lorirobn
  • Locked
  • Question
set permissions for forms/functions/users
Replies
0
Views
25
lorirobn
lorirobn

Part and Inventory Search

Sponsor

Back
Top