Add/Copy a set of fields & assign field names/bookmarks

[Eric]

Hi all, I have a template that has several user form fields. One "set" of
these fill in fields represents a group of related fields. I want the user
to be able to add/copy the group multiple times if needed. Each of the
fields throughout the template has their own name/bookmark. These fields
will eventually be exported to a comma delimited .txt file and imported into
Access.

I'm trying to write a macro that will not only add or copy the fields and
labels, but also name the bookmarks in a sequential order. This will allow
multiple groups and maintain individuality for the Access database.

I have seen several different ideas such as a table type format and the
corresponding code to copy rows etc. I'm not sure I like the table idea, but
am willing to go that direction if needed.

Here is what the group of fields look like in the template. The fields
follow these lables.

Observation 1:
Discussion:
Recommendation:
Action for Compliance: 0
Recommended Compliance Date:


If I could get an example of how to add/copy a field and label and also
assign a name/bookmark, I could replicate the code accordingly.

Any thoughts or ideas?

Thanks in advance

 

[Eric]

I just re-analyzed a thread posted: 10/12/2004 8:57 AM PST Titled: Add new
row in Table + new set of Form Fields. The answer from Stephanie Krieger was
awesome.

If I were to use a table type format, I would want to be able to copy the
entire table and name the corresponding fields sequentially.

Not sure which way to go?

 

[Eric]

The Panel has been Stumped?
--
Eric the Rookie

I just re-analyzed a thread posted: 10/12/2004 8:57 AM PST Titled: Add new
row in Table + new set of Form Fields. The answer from Stephanie Krieger was
awesome.

If I were to use a table type format, I would want to be able to copy the
entire table and name the corresponding fields sequentially.

Not sure which way to go?

 

[Doug Robbins - Word MVP]

See the article "How to assign a Name to a FormField that doesn't already
have a Name, using VBA" at:

http://www.word.mvps.org/FAQs/MacrosVBA/AssignNameToFmFld.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Eric]

Thanks Doug
--
Eric the Rookie

See the article "How to assign a Name to a FormField that doesn't already
have a Name, using VBA" at:

http://www.word.mvps.org/FAQs/MacrosVBA/AssignNameToFmFld.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP