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!

Mid Function

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.



 
Sort by date Sort by votes
My question is how do I make it so that the Mid, Right, and Left functions work in 2000 not what do they do.
 
Upvote 0 Downvote
Try Checking that you haven't got any missing references in your module.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rudolfelizabeth
  • Locked
  • Question
day function in ms access doesn't return the day name and there isn't a function date name
Replies
3
Views
126
Andrzejek
Andrzejek
PWD
  • Locked
  • Question
Access 2019 IIF + Public Function 1
Replies
5
Views
100
PWD
PWD
qqp
  • Locked
  • Question
Aggregate function error in query 1
Replies
11
Views
188
JordanSanders
JordanSanders
rudolfelizabeth
  • Locked
  • Question
datepart d function oops 1
Replies
7
Views
113
rudolfelizabeth
rudolfelizabeth
monkeysee
  • Locked
  • Question
NZ Function in query? 1
Replies
6
Views
123
monkeysee
monkeysee

Part and Inventory Search

Sponsor

Back
Top