undefined function while retrieving data with excel (in dutch and in english)

drt

NEDERLANDS:
Hallo,
Ik heb eigen functies gemaakt in access, die werken perfect in de access
query. Zodra ik echter vanuit excel een draaitabel maakt naar de access
query (als een externe database) krijg ik de foutmelding dat er een
'ongedefinieerde functie' in de access database aanwezig is.
Kan iemand mij op weg helpen dit probleem op te lossen?

Alvast bedankt voor de reactie,

Dick

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

Mar 15 '08 #1

Arno R

"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

Mar 15 '08 #2

drt

"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

Mar 15 '08 #3

Tom van Stiphout

On Sat, 15 Mar 2008 18:20:18 +0100, "drt" <di********@chelloSPAM.nl>
wrote:

You can't use VBA functions from MsQuery or from any other environment
(e.g. ASP, Coldfusion).
If you REALLY wanted to, you could use Access Automation to have
Access perform the query (IT can use VBA) and export the data to
Excel.

-Tom.

>
"Arno R" <ar****************@planet.nlschreef in bericht
news:47***********************@text.nova.planet.n l...

"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

Mar 17 '08 #4

drt

"Tom van Stiphout" <no*************@cox.netschreef in bericht
news:m3********************************@4ax.com...

On Sat, 15 Mar 2008 18:20:18 +0100, "drt" <di********@chelloSPAM.nl>
wrote:

You can't use VBA functions from MsQuery or from any other environment
(e.g. ASP, Coldfusion).
If you REALLY wanted to, you could use Access Automation to have
Access perform the query (IT can use VBA) and export the data to
Excel.

-Tom.

Thank you Tom,
That's also a way to do it. I like Arno's way better. It's less work in
Excel's pivot table.

Thank you all for reacting.

greetings
Dick

>

>>
"Arno R" <ar****************@planet.nlschreef in bericht
news:47***********************@text.nova.planet. nl...

"drt" <di********@chelloSPAM.nlschreef in bericht
news:26***************************@news.chello.n l...

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

Mar 17 '08 #5