I need help to generate a sequenced text outout from Access. And I am absolutely newbie to VB.

I have 6 tables of records derived from a mastertable of data e.g. tbl 1, 2, 3, 4, 5, 6. These 6 tables records are from 1 record in the master table in Access.

I need to generate the report in the following sequence :

Tbl 1, 2, 6, 3, 4, 5. Can VB do such sequencing? I understand you can use Do While... Loop but I do not know how to write the code to prepare the output into Text.

Sometimes there can be more than 1 table 3 or 4 and also 6 will not be in the sequence if there are no data in the table, same goes for 3 and 4.

So a variety of sequencing can occur like:

1,2,6,3,3,3,4,4,5

or

1,2,6

or

1,2,3,4,5

or

1,2,4

and so on.

The output into text will be in rows of 1250 characters (all tables are limited to 1250 characters already)

i.e.

in text output: (only from 1 record in mastertable - there can be more 600 records in the mastertable)

1 (text)
2 (text)
6 (text)
3 (text)
4 (text)
5 (text)

Is there anyway to prepare this text report. Its near impossible to work out the text output in Access or Excel.

Hi,

   I am not sure what you are trying to do.

   If I understand correctly, you have a master table (let's call it "tblMaster") and 6 tables that look up to the master table (let's call them "tbl1", tbl2", etc.)

   Is this what the tables look like:

tblMaster
   MasterID - PK
   OtherFields - ???

tbl1
   1ID - PK
   MasterID - FK
   Text - text

tbl2
   2ID - PK
   MasterID - FK
   Text - text

etc.

  Is this correct?

  If so, it seems like you want to grab a PK from tblMaster, and then pull text from the sub tables in numerical sequence if there is a record using MasterID as the FK. Are any other fields needed or do you just want lines of text in numerical sequence from the sub tables?

  Is this correct?

  Do you want this output to go to a .txt file? .csv? Access report?

All this info is needed to write the code, but it is certainly doable in VBA.

Thanks,


mmcdonal