|
 |
access thread: Can't use vba-functions in a query
Message #1 by "gerbert" <gsteenbergen@v...> on Wed, 25 Sep 2002 08:37:31
|
|
I've a strange problem:
I'm using Access 2000. I made a new database with tables and some query's
for reports. In some query's I used the function 'Left':
SELECT ... WHERE ... = Left(Field,2)
All's working fine, but when I copying this database to another computer,
and run the query there, Access create the following error:
This function is not available in query-expressions.
Each vba-function that I used in a query, generates this error on that
computer. What's wrong?
:Gerbert
Message #2 by jose.johnson@j... on Wed, 25 Sep 2002 17:21:51 +0900
|
|
check the vba libraries are already available in that new computer.
probably the vba utilities are missing from it. Please check it and
everything will be alright
gsteenbergen@v...
omputers.nl To: access@p...
cc:
09/25/2002 05:37 PM Subject: [access] Can't use vba-functions in a query
Please respond to
access
I've a strange problem:
I'm using Access 2000. I made a new database with tables and some query's
for reports. In some query's I used the function 'Left':
SELECT ... WHERE ... = Left(Field,2)
All's working fine, but when I copying this database to another computer,
and run the query there, Access create the following error:
This function is not available in query-expressions.
Each vba-function that I used in a query, generates this error on that
computer. What's wrong?
:Gerbert
Message #3 by "gerbert" <gsteenbergen@v...> on Wed, 25 Sep 2002 09:45:52
|
|
Thanx, but how can I check that?
>
check the vba libraries are already available in that new computer.
probably the vba utilities are missing from it. Please check it and
everything will be alright
Message #4 by jose.johnson@j... on Wed, 25 Sep 2002 17:55:39 +0900
|
|
open any of your forms in design mode and go the vba editor by selecting
any of the event procedure
select the Tools -> Reference
you will be provided all the utilities available there. see the items
checked and compare the same with
the new computer. check the unchecked ones in the new computer.
hope your problem can be solve by doing this.
Best Regards
gsteenbergen@v...
omputers.nl To: access@p...
cc:
09/25/2002 06:45 PM Subject: [access] Re: Can't use vba-functions in a query
Please respond to
access
Thanx, but how can I check that?
>
check the vba libraries are already available in that new computer.
probably the vba utilities are missing from it. Please check it and
everything will be alright
Message #5 by "gerbert" <gsteenbergen@v...> on Wed, 25 Sep 2002 10:57:48
|
|
Perfekt, it solves my problem. Thanx.
>
open any of your forms in design mode and go the vba editor by selecting
any of the event procedure
select the Tools -> Reference
you will be provided all the utilities available there. see the items
checked and compare the same with
the new computer. check the unchecked ones in the new computer.
hope your problem can be solve by doing this.
Best Regards
|
|
|
View Cart
