ACC2K - How can I generate a large amt of text by concatenating many fields

  • Thread starter Thread starter Bomber
  • Start date Start date
B

Bomber

Hi all,

I have 2 tables:

(1st Table)
RecID , Text
i.e.
1 , Some Text
2 , Some More Text
3 , Even Some More Text

(2nd Table)
ID , Text

I would like to have the user tick various records from table1 and have it
build the string to insert into table2.

i.e. the user would "tick" the records form table1 in a form that they want
added. They would then hit a button "Merge" to merge the text into a decent
format that could be cut and pasted into Word as a List.

Any ideas ? Clear enough ?

cheers,

Adam
 
by "tick" you mean check a checkbox

if so, then I sugest you add a field for it one of the tables

then when the user clicks the merge button you run two queries. The 1st is an append query that does your merge and adds the records (based on the critiera checkbox=yes) the 2nd is a modify query that sets all the checkboxes back to no, so the user can do it again

now if this is a MULTIUSER db, that checkbox needs to be in a table on the LOCAL machine, (frontend MDB) so two users doing this at once don't conflict

hth blm
 
Thanks Blm,

I tried doing it this way but all it did was just append each record as a
unique record and not as 1 record with the text appended.

I need it to somehow take all the records and append them as 1 record
(separated by a line).

Any ideas ?


blm said:
by "tick" you mean check a checkbox?

if so, then I sugest you add a field for it one of the tables.

then when the user clicks the merge button you run two queries. The 1st is
Click to expand...
an append query that does your merge and adds the records (based on the
critiera checkbox=yes) the 2nd is a modify query that sets all the
checkboxes back to no, so the user can do it again.
now if this is a MULTIUSER db, that checkbox needs to be in a table on the
Click to expand...
LOCAL machine, (frontend MDB) so two users doing this at once don't
conflict.
 
Back
Top