Copying Table text to tables 
Author Message
 Copying Table text to tables

You can see of the layouts here if they look funny below

http://www.*-*-*.com/

Hi

I need some help in doing the following.

I have been able to set up a macro to create a table layout that then
needs to be populated with information from the active document -
essentialy a summary fo information already contained in the document
presented as a table.

The original infomration in the documented is also contained in a
series of tables that are set out as such:

+-------------------------------------------+
| TEXT 1                                    |
+-------------------------------------------+
| Title                  | Heading | TEXT 3 |
| TEXT 2                 |---------|--------|
|                        | Heading | TEXT 4 |
|                        |         |        |
+-------------------------------------------+
| Heading                | TEXT 5           |
|                        |                  |
|                        |                  |
+-------------------------------------------+

TEXT 1 is a Category level type heading with various numnbers of levels
of the TEXT 2, 3, 4 and 5 underneath each category.

Each TEXT has its own Style assigned

What I want to be able to do is capture the TEXT 1, TEXT 2, TEXT 3,
TEXT 4 and TEXT 5 into a new table with the follwing format:

+-------------------------------------------+
| TEXT 1                                    |
+-------------------------------------------+
| | TEXT 5 | TEXT 3 | TEXT 4 | | | | |      |
+-------------------------------------------+

What I can do at the moment is copy any one of the particular texts and
place it in the correct cell.

What I cant get working is to get the entire series placed into each
respective cell.

I have also tried assigning the text to a constant which works
in populating all the cells but operates like a cartesian join.

Any Ideas ?

Thanks !!!!

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Mon, 19 May 2003 10:10:53 GMT  
 Copying Table text to tables
Hi,

Have you tried solving the problem one step at the time? Putting Text1
in its cell first, then Text2 et cetera? If you do it like this you
should not get the join you experienced, I think

Richard (NL)


Quote:

> You can see of the layouts here if they look funny below

> http://Groupware_Survey.tripod.com/sampletable.html

> Hi

> I need some help in doing the following.

> I have been able to set up a macro to create a table layout that then
> needs to be populated with information from the active document -
> essentialy a summary fo information already contained in the document
> presented as a table.

> The original infomration in the documented is also contained in a
> series of tables that are set out as such:

> +-------------------------------------------+
> | TEXT 1                                    |
> +-------------------------------------------+
> | Title                  | Heading | TEXT 3 |
> | TEXT 2                 |---------|--------|
> |                        | Heading | TEXT 4 |
> |                        |         |        |
> +-------------------------------------------+
> | Heading                | TEXT 5           |
> |                        |                  |
> |                        |                  |
> +-------------------------------------------+

> TEXT 1 is a Category level type heading with various numnbers of
levels
> of the TEXT 2, 3, 4 and 5 underneath each category.

> Each TEXT has its own Style assigned

> What I want to be able to do is capture the TEXT 1, TEXT 2, TEXT 3,
> TEXT 4 and TEXT 5 into a new table with the follwing format:

> +-------------------------------------------+
> | TEXT 1                                    |
> +-------------------------------------------+
> | | TEXT 5 | TEXT 3 | TEXT 4 | | | | |      |
> +-------------------------------------------+

> What I can do at the moment is copy any one of the particular texts
and
> place it in the correct cell.

> What I cant get working is to get the entire series placed into each
> respective cell.

> I have also tried assigning the text to a constant which works
> in populating all the cells but operates like a cartesian join.

> Any Ideas ?

> Thanks !!!!

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy.


Mon, 19 May 2003 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Copy fields from record in table A to record in table B using VBA

2. Copy Record from Table 1 to Table 2 - Acc97 - VBA

3. HowTo Copy a Recordset from a Table to an identically structured table

4. Copying the structure of a table to a new table

5. Copy a Table to another Table

6. Copying table definition to create new table

7. Copy a Table to another Table

8. copy dbase table to access table

9. Copy Dbase table to Access Table

10. Help Help Need to copy a field from one table into another table

11. MS Access DB - Copy Table A from Database A to Table A Database B

12. SQL and Copying Table to Table

 

 
Powered by phpBB® Forum Software