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
'ongedefinieerd e 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

[Arno R]

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


"drt" <dicterANTI@che lloSPAM.nlschre ef in bericht news:26a28$47db a15a$1884e3a4$2 8633@news.chell o.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

[drt]

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


"Arno R" <arracomn_o_s_p _a_m@planet.nls chreef in bericht
news:47dbf15d$0 $25482$ba620dc5 @text.nova.plan et.nl...

"drt" <dicterANTI@che lloSPAM.nlschre ef in bericht
news:26a28$47db a15a$1884e3a4$2 8633@news.chell o.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

[Tom van Stiphout]

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

On Sat, 15 Mar 2008 18:20:18 +0100, "drt" <dicterANTI@che lloSPAM.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" <arracomn_o_s_p _a_m@planet.nls chreef in bericht
>news:47dbf15d$ 0$25482$ba620dc 5@text.nova.pla net.nl...
>
>"drt" <dicterANTI@che lloSPAM.nlschre ef in bericht
>news:26a28$47d ba15a$1884e3a4$ 28633@news.chel lo.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
>

[drt]

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


"Tom van Stiphout" <no.spam.tom774 4@cox.netschree f in bericht
news:m3hrt39ofp hlenlcm797h5ss8 si7k1qlin@4ax.c om...

On Sat, 15 Mar 2008 18:20:18 +0100, "drt" <dicterANTI@che lloSPAM.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" <arracomn_o_s_p _a_m@planet.nls chreef in bericht
>>news:47dbf15d $0$25482$ba620d c5@text.nova.pl anet.nl...
>>
>>"drt" <dicterANTI@che lloSPAM.nlschre ef in bericht
>>news:26a28$47 dba15a$1884e3a4 $28633@news.che llo.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
>>