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!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Undefined Function 'Mid' in Expression
- Thread starter diwin
- Start date
I have had the same problem, the database works perfectly on my machine but on a machine with the same version of Access, with the same references it comes up with the error described above. I have tried reinstalling Access and rechecking the references but still no joy - does anyone have any other suggestions?
Thanks
Thanks
hi
there is a microsoft kb article on this, sorry have forgotten the number, I believe it applies to pc's which have/have had more than one version of Access or Office installed, does that apply?
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
there is a microsoft kb article on this, sorry have forgotten the number, I believe it applies to pc's which have/have had more than one version of Access or Office installed, does that apply?
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Thread starter
- #5
Thanks for the replies.
The real issue is not simply that something is missing. The problem is that the 'Function' Mid is undefined. How can that be? Mid does not need definition. This is likely just evidence of some obscure problem that someone with my skill level will have no clue about. I am hoping some expert that has had this problem before recognizes it.
Any input is much appreciated.
Daniel Dillon
The real issue is not simply that something is missing. The problem is that the 'Function' Mid is undefined. How can that be? Mid does not need definition. This is likely just evidence of some obscure problem that someone with my skill level will have no clue about. I am hoping some expert that has had this problem before recognizes it.
Any input is much appreciated.
Daniel Dillon
Hi
While it may appear that functions such as Mid() "cannot", be missing, this is not in fact so. While YOU may not have to define them, since they are built in functions, they are defined somewhere, and that somewhere is an object library.
With Access much of the functionality is held in Object Libraries, if you open any code module in design view, then choose Tools \ References from the menu, you will see a list of available and selected libraries.
What has been suggested to you is that you check this lsit to see if any of the selected (ie ticked) libraries have the word "Missing" alongside them.
In addition I was saying that I do recall seeing a Microsoft Knowledge base article on this subject. If my memory serves me correctly, the problem was applicable to PC's which had more than one version of office installed.
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
While it may appear that functions such as Mid() "cannot", be missing, this is not in fact so. While YOU may not have to define them, since they are built in functions, they are defined somewhere, and that somewhere is an object library.
With Access much of the functionality is held in Object Libraries, if you open any code module in design view, then choose Tools \ References from the menu, you will see a list of available and selected libraries.
What has been suggested to you is that you check this lsit to see if any of the selected (ie ticked) libraries have the word "Missing" alongside them.
In addition I was saying that I do recall seeing a Microsoft Knowledge base article on this subject. If my memory serves me correctly, the problem was applicable to PC's which had more than one version of office installed.
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Thread starter
- #7
Thanks guys.
Problem fixed. I had used the now() function to display the system date. Then I chopped it up and pasted it together as part of a product ID code. The problem that I had was the format of the system date. On one machine it was mm/dd/yyyy, on the other it was yyyy/mm/dd. So the manipulation of the date was choking.
For others with the same problem moving apps to other machines: check the format of your date and see if you use it in your code.
Daniel Dillon
Problem fixed. I had used the now() function to display the system date. Then I chopped it up and pasted it together as part of a product ID code. The problem that I had was the format of the system date. On one machine it was mm/dd/yyyy, on the other it was yyyy/mm/dd. So the manipulation of the date was choking.
For others with the same problem moving apps to other machines: check the format of your date and see if you use it in your code.
Daniel Dillon
- Status
Similar threads
- Locked
- Question
- Locked
- Question