By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,930 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,930 IT Pros & Developers. It's quick & easy.

Form Layout problem

P: n/a
Hi.

I have an Access database which has three forms which open on start up. It
was an unusual design that I want to clean up. One of the forms also has sub
forms involved.

My question is if anyone knows of an easy way to extend one of the forms to
incorporate all the forms by adding a "Tab Control" with two pages which
would then allow to add the second and third page. (Hope this makes sense!)

My problem is all the code that is under lying. Is there an easy way to copy
the forms into the tab control which will automatically update the modules
to let them know the new location of the Sub forms?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Scott wrote:
Hi.

I have an Access database which has three forms which open on start up. It
was an unusual design that I want to clean up. One of the forms also has sub
forms involved.

My question is if anyone knows of an easy way to extend one of the forms to
incorporate all the forms by adding a "Tab Control" with two pages which
would then allow to add the second and third page. (Hope this makes sense!)
You can insert a tabcontrol and put the other two forms in, from the
graphical interface, without trouble.
My problem is all the code that is under lying. Is there an easy way to copy
the forms into the tab control which will automatically update the modules
to let them know the new location of the Sub forms?


If the code you mean uses a lot of addresses like Forms!whatever, no,
there is no way around a (limited) re-write. Subforms cannot be found in
the Forms collection, as you are undoubtedly aware.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #2

P: n/a
Thiught as much but I was hopefull. Thanks anyhow.
"Bas Cost Budde" <b.*********@heuvelqop.nl> wrote in message
news:cp**********@news2.solcon.nl...
Scott wrote:
Hi.

I have an Access database which has three forms which open on start up.
It was an unusual design that I want to clean up. One of the forms also
has sub forms involved.

My question is if anyone knows of an easy way to extend one of the forms
to incorporate all the forms by adding a "Tab Control" with two pages
which would then allow to add the second and third page. (Hope this makes
sense!)


You can insert a tabcontrol and put the other two forms in, from the
graphical interface, without trouble.
My problem is all the code that is under lying. Is there an easy way to
copy the forms into the tab control which will automatically update the
modules to let them know the new location of the Sub forms?


If the code you mean uses a lot of addresses like Forms!whatever, no,
there is no way around a (limited) re-write. Subforms cannot be found in
the Forms collection, as you are undoubtedly aware.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.