PDA

View Full Version : Sleeper: VBA Error message



gsdonald
10-10-2005, 03:31 AM
Hi again,
I'm developing an application (a kind of dictionary for my students) and when I try it on their computers, it gives me weird errors:
Things like LCase(myString) where LCase gives the problem, or Mid().
Is it because certain Libraries are not loaded on their pcs?
Is there a way around this?

Does anyone have any ideas?

GSD

TonyJollans
10-10-2005, 04:08 AM
Yes, it sounds like a references issue.

In the VBE, look under Tools > References and see if anything is flagged as MISSING.

gsdonald
10-10-2005, 11:25 AM
Thanks,
That confirms what I thought. The problem remains, however.
Is there anyway that the "missing" included using VBA?
Thanks

Bob Phillips
10-10-2005, 11:51 AM
Thanks,
That confirms what I thought. The problem remains, however.
Is there anyway that the "missing" included using VBA?
Thanks

Are you sure? Did you uncheck the MISSING items in the list?

TonyJollans
10-10-2005, 03:41 PM
Thanks,
That confirms what I thought. The problem remains, however.
Is there anyway that the "missing" included using VBA?
Thanks

It isn't easy and it does depend on what the missing reference is and why it's missing. It isn't something that can be done for a general case.

Can you not use late binding so that the reference isn't needed?

What is missing anyway?