"Arno R" <ar****************@planet.nlschreef in bericht
news:47***********************@text.nova.planet.nl ...
"drt" <di********@chelloSPAM.nlschreef in bericht
news:26***************************@news.chello.nl. ..
In ENGLISH:
Hallo,
I made some functions in Access, they work fine in Access (Query's and so
on).
When I want to retrieve the data with Excel in a pivot table (Access as a
foreign database), I get the message that there are undefined functions
then
Microsoft Query stops.
Is there someone able to help me solve this problem?
Thanks in advance.
Dick
We speak English here.
The problem is that your functions (even when they are 'public') are not
available for MS Query.
You could try to 'output' the needed data to a temptable and retrieve the
data from that table.
Or you could try to use pivot tables in Access.
Arno R
Yhank you Arno.
Yes I figured that out also (making a temp table in Access). But isn't there
another way? Forse MsQuery to use the VBA functions from Access?
Dick