Duplicating tabs

  • Thread starter Thread starter google3luo359
  • Start date Start date
G

google3luo359

Hello,

I could really use some help in simplifying the creation of tabs in a
form.
I would like to save a lot of time by simply copying everything
(subforms and their EXACT location in the first tab) onto Tab2, Tab3
and Tab4.

When i try to do this I get varying results, none of which are desired.
Sometimes I'll get all four tabs copied into one tab!!!
Sometimes I'll get the tab copied but one of the subforms doesn't
appear properly.
And the most frustrating is that when the tab is copied the subforms
are situated at different locations on the new Tabs. The whole idea
being to avoid moving things around so that switching from tab to tab
shows no movement of the subforms, everything appearing to be in the
exact same location.

Is there a foolproof easy way to accomplish this? Access 2000.
I know that I'll have to go in and change some code in each tab
(names/labels etc.) but that's relatively easy.

TIA Ric
 
I don't know that there is any built-in way to do this.
Usually, I just set the numbers for the Top and Left of each subform control
in the Properties box. For example, 0.35" for Top and 0.2" for Left works
for me.

It is possible to write some code that loops through each Control of the
Form, and if the ControlType is acSubform, set its Top and Left properties.
It would not be worth the effort unless you were doing this regularly. If
you do set these numbers programmatically, supply the value in twips, where
1440 twips = 1 inch.
 
Allen said:
I don't know that there is any built-in way to do this.
Usually, I just set the numbers for the Top and Left of each subform control
in the Properties box. For example, 0.35" for Top and 0.2" for Left works
for me.

It is possible to write some code that loops through each Control of the
Form, and if the ControlType is acSubform, set its Top and Left properties.
It would not be worth the effort unless you were doing this regularly. If
you do set these numbers programmatically, supply the value in twips, where
1440 twips = 1 inch.
Click to expand...


OK thanks very much Allen. It's not really a that important, so I
won't try to write code to do this. I just thought that if there was an
automated way to do it it would help.

Thanks!
Ric
 
Back
Top