Create text string from data in fields

[Earl G via AccessMonster.com]

I'm using Access 2000. I want to create a query or open a table then loop
through the fields and concatenate the fields into a string. e.g.( field1 &
chr(9) & field2.... etc..) This is, as you can see, is a tab delimited
string which I will then write to a text file. Then move to the next record
in the table or query and repeat.

There is a good reason for doing this. I've tried using several examples for
looping through the fields but I continue to have problems.

 

[Debra Farnham]

Hi Earl

I might be missing something here, but won't the export feature to what you
are trying to do?

Debra

 

[Debra Farnham]

Oops .. hit the send button too fast

Won' t the export feature DO what you are trying to accomplish?

Debra

 

[Earl G via AccessMonster.com]

Thanks for the response Debra.
The need is to create a tab delimited record. This delimited file may have a
header file with the exact same header name for an unknown number of fields.
I will need to be accessing a second and third table to generate that part of
the delimited string. It is a requirement of the application that will be
importing this delimited file. Along with the duplicate field headers, there
will be need to generate an 'XML' style string for some of the table fields.
The delimited file must be built programmatically.
I have am sure of the design but as you can see, I am like a child while
learning this new (to me) tool called Access/VBA. My past experience was in
Foxpro for DOS.

I guess that was the long way to say no.

Oops .. hit the send button too fast

Won' t the export feature DO what you are trying to accomplish?

Debra

I'm using Access 2000. I want to create a query or open a table then loop
through the fields and concatenate the fields into a string. e.g.( field1 &

[quoted text clipped - 4 lines]

There is a good reason for doing this. I've tried using several examples for
looping through the fields but I continue to have problems.