[AccessD] Concatenating data into lists

The code was likely written using Miscrosoft DAO rather than ADO which is
set by default in Access 2003.

If you feel like the exercise you can probably convert the code to ADO,
but since I haven't looked at it I don't know how much other ado specific
code it contains.

For a simple solution, the easiest thing would be to add a reference to
DAO and change the declares for database and recordset to DAO.Database and
DAO.recordset.

To change the reference, from a code window, click on the tools menu and
then references...

The one you are looking for is called the Microsoft DAO x.x Object
Library.  In my case its 3.6, but I'm not using access 2003.

Make sure the reference stays below the Microsoft ActiveX Data Objects
library so that your existing code doesn't need to change.

Stuart


-----Original Message-----
From: David & Joanne Gould <dajomigo at tpg.com.au>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Date: Wed, 07 Dec 2005 22:05:08 +1100
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