AllenK wrote:
I am using Mr. Hookums formula he gave me for concatenation in Access
2003 and it works fine. As soon as I copy it into 2007 I get error
messages. I have tried converting the database to 2007, but get
errors. I created 2007 database and imported all files from 2003.
Switchboard and concatenation no longer work.
Here is what I am getting for messages.

Microsoft Visual Basic "Compile error: User-defined type not defined"
and here is the code, first three lines below are highlighted yellow;
Function Concatenate(pstrSQL As String, _
Optional pstrDelim As String = ", ") _
As String

Dim rs As New ADODB.Recordset

You need to set a reference to the ADO library ... open the module
containing the code, go to Tools|References, and scroll down and select the
latest version of the Microsoft ActiveX Objects installed on your machine
(probably 2.8)
--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"