Using MS Access VBA Function using Query in VB6

Question

I have defined a Function in MS Access database. I am using that function in Query. I saved that query as "Query1". This query runs successfully in MS Access. But, when I call the same query from VB (using ADO), it is giving me error:

Run-time error '-2147217900 (80040e14)':

Undefined function 'Concatenate' in expression.

Below is the code I use to access "Query1":

rs.Open "Select * From Query1", CN1, 2, 2
If Not rs.EOF Then
'Get Data
End If
rs.Close

You haven't made clear whether your VB call is in Access still or another program, if still with Access then I suggest using DAO instead of ADO. — Matt Donnan
– Matt Donnan, Commented Feb 13, 2012 at 10:32

Fionnuala · Accepted Answer · 2012-02-12 12:39:20Z

3

You cannot use user defined functions (UDFs) outside of Access.

answered Feb 12, 2012 at 12:39

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Fionnuala Over a year ago

You can post the UDF if you want SO people to look at an alternative approach.

Chintan Shah Over a year ago

I am using Concatenate function to get comma separated string from one column of rows. Can this be done using normal ms access query?

Fionnuala Over a year ago

@Chintan Shah No, you cannot concatenate without a UDF (stackoverflow.com/questions/92698/combine-rows-in-access-2007/…, stackoverflow.com/questions/230241/…)

Collectives™ on Stack Overflow

Using MS Access VBA Function using Query in VB6

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related