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!

please help....

Status
Not open for further replies.
varean

varean

Technical User
Apr 9, 2001
17
US
This used to work in access 97, I upgraded my computer to access 2002; I get "undefined function MID in expression" when I run query.
DISP: Mid([ACTV_STATE],16,1)
 
Sort by date Sort by votes
You have lost a reference which is a .ocx that provides the function.
Go to modules and open up the code window then go to Tools>references and you will see a list of the references in use.
You will find that one of them has missing against it...
Reinstall that!
 
Upvote 0 Downvote
thanks for your quick reply, I'll try it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SoLost1
  • Locked
  • Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
146
dhookom
dhookom
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
141
serino
serino
eerich
  • Locked
  • Question
IIF Help on complex query
Replies
5
Views
154
Andrzejek
Andrzejek
WimDC
  • Locked
  • Question
Help on grouping by TIME Range
Replies
1
Views
125
dhookom
dhookom
K. Reed
  • Locked
  • Question
Can anyone help me figure out what i've done wrong?
Replies
18
Views
161
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top