How do I get an entry in one table to generate the rows in an additional table?

**Gavalar** · 04-03-2014, 07:35 PM

So I have set up my form (See Attached) but becaause of the protection on it you are unable to delete empty rows in the second table. Is there any way I can get the form to generate rows 2 and 3 (identified in the attachment) only when data is placed into the donation number field of table 1?

It's a long shot but it would save on seeing empty boxes and give the form a lot neater look.

Thanks in advance for any help

Gav

HPC form.docx

**macropod** · 04-04-2014, 08:53 AM

See: http://www.msofficeforums.com/word-v...html#post38461

**Gavalar** · 04-04-2014, 08:40 PM

Thanks for the link Paul

I have being amending an example to suit my needs but the examples were based on the row being added to the same table however I am wanting to add mine to the second table on my form. In addition my VBA knowledge is a work in progress.

I think I've sorted the 2nd table entry but have hit a slight problem in that my 2nd table contains merged rows and because of this the code below is giving me a runtime error

Please Login or Register  to view this content.

How can I change this to accept merged cells? Would it be better to enclose the entire code for you to view?

Thanks again

Gav

**macropod** · 04-04-2014, 10:51 PM

Working with tables that have merged cells is always problematic, since it's hard to write any generalised code that could work with the range of possibilities. Furthermore, it's impossible to reference a given row when there are merged cells above it. When you add a row to such a table in which, say, the last existing row has a vertically merged cell, an entire new row id added without extending the merged cell. Consequently, you then have to handle any merging requirements post-addition.

The best you can do when merged cells are involved is to work with the RowIndex & ColumnIndex of each cell, but even then it's hard to know whether, from a coding perspective, how cells with changing row & column indicies relate to a visual row/column. Basically, you have to know these details when writing the code. Tough if the table structure is dynamic.

My advice: avoid merged cells if possible and, if not, consider either unmerging/remerging either side of the row addition code or, if possible, temporarily split the table below the last merged row before adding the new row.

**Gavalar** · 04-16-2014, 08:07 PM

Thanks for the advice given the effort and time this requires I'm putting it in a too hard basket for now and may revisit another time.

Thanks again for your input.
Gav

How do I get an entry in one table to generate the rows in an additional table?

LinkBack

Thread Tools

Rate This Thread

Display

How do I get an entry in one table to generate the rows in an additional table?

Re: How do I get an entry in one table to generate the rows in an additional table?

Re: How do I get an entry in one table to generate the rows in an additional table?

Re: How do I get an entry in one table to generate the rows in an additional table?

Re: How do I get an entry in one table to generate the rows in an additional table?

Thread Information

Users Browsing this Thread

Similar Threads

updating pivot table to include additional rows

[SOLVED] Code to move data from an entry table to a historical table by date.

[SOLVED] Error in filtering table - additional rows shown, rows hidden when filter removed

Copy/insert additional data entry rows

Using Macro to link sql table to generate Pivot Table

Bookmarks

Bookmarks

Posting Permissions