By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

How to check a library link in VBA

P: n/a
Dear Access friends,

If I install an application on an aliens PC the connection to a model
library in VBA seems to be OK. But by running there are some problems with
the query instructions Left(), Mid() and Right() and also with Date() and
Time(). After a reconnection of the model library in VBA these problems are
melted as snow for the sun. Is there VBA code available to check the
quality of the module library reference?

Thanks for any help,

Simon
Oct 21 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi,

If I install an application on an aliens PC the connection to a model
library in VBA seems to be OK. But by running there are some
problems with the query instructions Left(), Mid() and Right() and
also with Date() and Time(). After a reconnection of the model
library in VBA these problems are melted as snow for the sun. Is
there VBA code available to check the quality of the module library
reference?
Do you know the References Wizard ?

http://www.mvps.org/access/modules/mdl0022.htm

Regards
Jens
Oct 21 '06 #2

P: n/a
I think this is to do with COMCTL32.OCX versions.
What version of Access are you using 97?

You could recode to use MSCOMCTL.OCX which I think does not have the
problem.

If you can avoid using the reference library windows common controls, then
you will not have the problem at all.

I cant answer your specific question.

"Simon" <Sv********@Versatel.nlwrote in message
news:45**********************@news.tele2.nl...
Dear Access friends,

If I install an application on an aliens PC the connection to a model
library in VBA seems to be OK. But by running there are some problems
with
the query instructions Left(), Mid() and Right() and also with Date() and
Time(). After a reconnection of the model library in VBA these problems
are
melted as snow for the sun. Is there VBA code available to check the
quality of the module library reference?

Thanks for any help,

Simon


Oct 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.