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 Rhinorhino 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
Joined
Apr 12, 2000
Messages
15
Location
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
MID is a function that returns a determine size of characters so?
 
Upvote 0 Downvote
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 Question
day function in ms access doesn't return the day name and there isn't a function date name
Replies
3
Views
579
Andrzejek
Andrzejek
PWD
  • Locked
  • Question Question
Access 2019 IIF + Public Function
Replies
5
Views
437
PWD
PWD
qqp
  • Locked
  • Question Question
Aggregate function error in query
Replies
11
Views
776
JordanSanders
JordanSanders
rudolfelizabeth
  • Locked
  • Question Question
datepart d function oops
Replies
7
Views
520
rudolfelizabeth
rudolfelizabeth
monkeysee
  • Locked
  • Question Question
NZ Function in query?
Replies
6
Views
541
monkeysee
monkeysee

Part and Inventory Search

Sponsor

Back
Top