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.

 

[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/