library missing

[Henriette van de Haar]

Hi all,

a long time ago I wrote an access program containing a visual basic
module, using access 2000.

This program I used for many years without altering any code, but now
suddenly I get the message that a library is missing. The debugger
always stops at the funcion "LCase". Obviously some other program
installation has deleted a library containing this function and others.

Does anybody know what library this could be?
Or how I can find out?
I must admit that meanwhile I quite forgot how to work with access VBA.

Best regards,
Henriette/Hamburg, Germany

 

[Rick Brandt]

Hi all,

a long time ago I wrote an access program containing a visual basic
module, using access 2000.

This program I used for many years without altering any code, but now
suddenly I get the message that a library is missing. The debugger
always stops at the funcion "LCase". Obviously some other program
installation has deleted a library containing this function and
others.
Does anybody know what library this could be?
Or how I can find out?
I must admit that meanwhile I quite forgot how to work with access
VBA.

Problems with missing references are rather common with Access. The first
thing to be aware of when diagnosing them is that in most cases the specific
functions that you see malfunctioning have nothing to do with the missing
reference. Any missing reference will cause many functions (even totally
unrelated functions) to stop working.

What you have to do is open the VBA window and then go to Tools - References
and see what libraries your app is referencing and if any are marked as
"Missing" in that dialog.

 

[Linq Adams via AccessMonster.com]

Here are Doug Steele's instructions on how to troubleshoot the problem:

******************** Quote ********************

Any time functions that previously worked suddenly don't, the first thing to
suspect is a references problem.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target machine).
Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in and
reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out of
the dialog, then go back in and reselect the references you just unselected.
(NOTE: write down what the references are before you delete them, because
they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Just so you know: the problem will occur even if the library that contains
the specific function that's failing doesn't have a problem.

**** End Quote ****

 

[Henriette van de Haar]

Problems with missing references are rather common with Access. The first
thing to be aware of when diagnosing them is that in most cases the specific
functions that you see malfunctioning have nothing to do with the missing
reference. Any missing reference will cause many functions (even totally
unrelated functions) to stop working.

Thanks a lot for this help. I actually found one missing reference and
unselected it. And then: after a new compilation my program worked
again!!!!!!!!
This missing reference is Microsoft Access Calender Control
(msacal70.ocx). The only thing in my program that doesn't work now is
the calender. Somehow this file got lost. Would you know where I can get
this file?

Best Regards,
Henriette, Hamburg/Germany

 

[Douglas J. Steele]

Do yourself a huge favour, and use the all-API solution Stephen Lebans has
at http://www.lebans.com/monthcalendar.htm or one of the many others Jeff
Conrad has listed at
http://www.accessmvp.com/JConrad/accessjunkie/calendars.html If you do that,
you won't run into problems with the calendar control.

If you cannot (or will not) change your application, scroll through the list
of available references. It's quite likely that the control does exist on
the machine, but that it was a different version than what was on the
development machine.

 

[Henriette van de Haar]

Do yourself a huge favour, and use the all-API solution Stephen Lebans
has at http://www.lebans.com/monthcalendar.htm or one of the many others
Jeff Conrad has listed at
http://www.accessmvp.com/JConrad/accessjunkie/calendars.html If you do
that, you won't run into problems with the calendar control.

If you cannot (or will not) change your application, scroll through the
list of available references. It's quite likely that the control does
exist on the machine, but that it was a different version than what was
on the development machine.

That would be the best solution. Actually this calender control "works",
only in the beginning there are some error messages, telling me that
"click", "beforeupdate" and "afterupdate" are not known. After these 3
messages, the calender works fine!
Obviously library msacal70.ocx is missing. I looked in the internet to
download it, but meanwhile there are virus files with this name offered
so I don't dare to download such a file.

I scrolled though the available references on my computer, but there are
hundreds and hundreds and none looked like the right one. Could it be
one of the "Microsoft ActiveX Data Objects 2.x Libraries"?

Best Regards,

Henriette, Hamburg/Germany

 

[Henriette van de Haar]

Do yourself a huge favour, and use the all-API solution Stephen Lebans
has at http://www.lebans.com/monthcalendar.htm or one of the many others
Jeff Conrad has listed at
http://www.accessmvp.com/JConrad/accessjunkie/calendars.html If you do
that, you won't run into problems with the calendar control.

If you cannot (or will not) change your application, scroll through the
list of available references. It's quite likely that the control does
exist on the machine, but that it was a different version than what was
on the development machine.

Hi Douglas,

meanwhile I solved the problem! I found Microsoft Calender Control 10.0
(mscal.ocx) in Windows/System32. Funny enough this control was not
listed in the reference list. I just looked throught System32 and found
it! And it works! Thanks for helping!

Best Regards,
Henriette

 

[Henriette van de Haar]

Problems with missing references are rather common with Access. The first
thing to be aware of when diagnosing them is that in most cases the specific
functions that you see malfunctioning have nothing to do with the missing
reference. Any missing reference will cause many functions (even totally
unrelated functions) to stop working.

What you have to do is open the VBA window and then go to Tools - References
and see what libraries your app is referencing and if any are marked as
"Missing" in that dialog.

Hi Rick,

meanwhile I solved the problem! I found Microsoft Calender Control 10.0
(mscal.ocx) in Windows/System32. Funny enough this control was not
listed in the reference list. I just looked throught System32 and found
it! And it works! Thanks for helping!

Best Regards,
Henriette

 

[Tony Toews [MVP]]

meanwhile I solved the problem! I found Microsoft Calender Control 10.0
(mscal.ocx) in Windows/System32. Funny enough this control was not
listed in the reference list. I just looked throught System32 and found
it! And it works! Thanks for helping!

It works on your machine. But what about the users? They could have
different versions of that control.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/