Making a paged form out of an existing one

[news2]

I have a form which has grown to the point I'd like to convert it to paged
style.

I have tried the tab control, placing it on the existing form, but while I
can easily add new controls onto the pages I can't seem to be able to move
or copy/paste existing control sets onto it.

Must I start over from scratch and build a new form? There's a lot of code
behind the existing controls and I'd hate to have to transfer those subs and
functions (I could copy/paste them, I guess).

Any trick to help me move or copy/paste controls from the existing form to a
paged version?

Dick

 

[Allen Browne]

The trick is to select the tab page you want to paste into.

1. Select the control(s) you want to move to a different page of the tab
control (by dragging mouse, or Shift+Clicking.)

2. Cut to clipboard (Ctrl+X.)

3. Click on the tab of the page you want to paste them onto (i.e. the actual
tab on the top of the tab control.)

4. Paste. (Ctrl+V.)

I can't recommend the old style of form where you use PgDn repeatedly to
flick down to various subsequent "pages." That kind of interface is not very
obvious, and went out with version 2 of Access (some 12 years ago.)

BTW, if you have that many fields in one table, the design might not be
normalized (unless we are large memo text boxes here.) You might like to see
what the table analyzer suggests. In Access 2003 and earlier, it's Analyzer
on the Tools menu. In Access 2007, it's on the Database Tools tab of the
ribbon.

 

[Wayne-I-M]

Hi

You could copy the form a few times. Redeisgn the copies to take off the
duplicate controls and then use these on the tabs of the main form. Don't
forget the leave the primary field control on the new subs and use this as
the linking child master control field.

Good luck

 

[news2]

Thank you both. I had been using copy vice cut. Now that I think about it,
I can see the difference.

FYI the original form is big because we keep an awful lot of unique info
about our members, including pictures, committee membership and so forth.

Dick

 

[news2]

I followed directions for the cut/paste and everything looked fine - then I
discovered that the code hadn't accompanied the controls. Sigh.

Back to the original form (thank goodness for backups!) and through some
reorganization and framing with rectangle borders it will do.

Dick