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

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

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a

"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

P: n/a
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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.