SLAMAN! An answer to your question

[JoeMiller]

You posted a while ago and asked me about making a comma-delimited list out of a bunch of records.

I found a way to do what you're looking for, it's not my code but it works splendidly...

http://www.mvps.org/access/modules/mdl0008.htm

Joe Miller
joe.miller@flotech.net

 

[slaman]

Heh thanks... that caught my attention... twice I will check it out

 

[slaman]

I am using Access 2002 which has VB6. Unfortunately, I can't use that code because I can't define a data-type As Database. I don't know what its equivalent type is in VB6... Any help would be appreciated.

 

[JoeMiller]

Sorry, can't help on that one. Did you check MSDN or the help files?

Joe Miller
joe.miller@flotech.net

 

[hellferret]

You need to make a reference to Microsoft DAO if you want to use the Database type.


HF

 

[slaman]

Thanks, I just found that out from the help files. This is how I am calling the function. I get Runtime errors 0 and 20.

[Former Name(s)] = Me.fConcatFld("[Former Names]", "Corporation ID", "[Former Name]", "Number", "String&quot

I am so frustrated. Nothing ever seems to work for me =/

 

[slaman]

http://www.mvps.org/access/modules/mdl0004.htm

This is the module I need... This is how I call it

[Former Name(s)] = Me.fConcatChild("[Dates]", "[Corporation ID]", "[Former Name]", "Long", 1)

where the Corporation ID is 1. I get nothing - no errors, no display, nothing...