[AccessD] Concatenating data into lists

In XP wouldn't you use something like the following:

Dim db AS ADODB.Connection
Set db = CurrentProject.Connection

Paul Hartland

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David & Joanne
Gould
Sent: 07 December 2005 11:05
To: Access Developers discussion and problem solving
Subject: [AccessD] Concatenating data into lists

I have been trying to learn how to use Dev Ashish's wonderful module to turn
data from a child table into a comma delimitered list. It works perfectly
every time I use Northwind to test it and even works if I import tables and
queries into Northwind from another database. But I can't get it to work in
any other database. One line in the code has me thinking (Set db as Database
- I am using Access XP and it doesn't recognise this code. But I just
comment it out and Northwind is happy.

I don't get any error messages, it just doesn't put anything into the query
field. Anyone who wants to see an example of what I have been working on, I
can send a copy of the test database (only about 20kb zipped)

TIA

David Gould
DG Solutions


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com