 |
| Access VBA Discuss using VBA for Access programming. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
March 21st, 2006, 05:30 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 428
Thanks: 57
Thanked 2 Times in 2 Posts
|
|
Left$ returns Can't Find Project or Library
An Access database I wrote years ago is suddenly returning this error on Left$ in VBA. We've recently received new workstations, so it seems likely something vital is now missing. Any clues what, where to look for it, or how to fix this?
|
|
March 21st, 2006, 05:36 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
I used to use Left$ a lot as well, but I think that it has been replaced by Left without the $.
It could be that your older workstations either had an older version of Access or had an older DLL that let it still use Left$
Hope that helps, you could probably just do a Find & Replace for your entire projects and replace Left$ with Left, and I would think you would be good.
Mike
Mike
EchoVue.com
|
|
The Following User Says Thank You to echovue For This Useful Post:
|
|
|
March 21st, 2006, 05:46 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 428
Thanks: 57
Thanked 2 Times in 2 Posts
|
|
I've tried "Left", Mid$", and "Mid". They all get the same error. Something's missing.
|
|
March 21st, 2006, 05:50 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
Have you had a look under Tools -> References to see if anything is marked as MISSING?
Mike
EchoVue.com
|
|
The Following User Says Thank You to echovue For This Useful Post:
|
|
|
March 21st, 2006, 05:53 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
Actually come to think of it, I had a database some time ago that started doing this, and eventually just melted down completely.
One thing you may want to try is creating a new blank database and importing all the tables, forms, reports etc into it, and then seeing if that one works without a hitch.
I'll keep racking my brains to see if I can recall anything else about it.
Mike
Mike
EchoVue.com
|
|
The Following User Says Thank You to echovue For This Useful Post:
|
|
|
March 22nd, 2006, 09:31 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 428
Thanks: 57
Thanked 2 Times in 2 Posts
|
|
Tools -> References doesn't appear to exist. I could swear I've seen this before, too, but can't remember what I did then to fix it.
|
|
March 22nd, 2006, 11:09 AM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
Tools -> References should be in your VBA editor.
Mike
EchoVue.com
|
|
The Following User Says Thank You to echovue For This Useful Post:
|
|
|
March 22nd, 2006, 11:22 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 428
Thanks: 57
Thanked 2 Times in 2 Posts
|
|
That got me there, thanks! It was missing references to a couple of objects I wrote a while back that had nothing to do with Left$.
|
|
|
