Connecting Tech Pros Worldwide Help | Site Map

Form Layout problem

  #1  
Old November 13th, 2005, 06:20 AM
Scott
Guest
 
Posts: 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?


  #2  
Old November 13th, 2005, 06:20 AM
Bas Cost Budde
Guest
 
Posts: n/a

re: Form Layout problem


Scott wrote:[color=blue]
> 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!)[/color]

You can insert a tabcontrol and put the other two forms in, from the
graphical interface, without trouble.
[color=blue]
> 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?[/color]

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
  #3  
Old November 13th, 2005, 06:20 AM
Scott
Guest
 
Posts: n/a

re: Form Layout problem


Thiught as much but I was hopefull. Thanks anyhow.


"Bas Cost Budde" <b.costbudde@heuvelqop.nl> wrote in message
news:cpmg2u$6ta$1@news2.solcon.nl...[color=blue]
> Scott wrote:[color=green]
>> 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!)[/color]
>
> You can insert a tabcontrol and put the other two forms in, from the
> graphical interface, without trouble.
>[color=green]
>> 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?[/color]
>
> 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[/color]


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems With CSS Form Layout DDubya answers 12 March 25th, 2009 08:21 PM
MDI Parent Form Layout Problem mafaisal answers 0 February 12th, 2008 05:27 PM
Controls of Panel Layout problem JimWu answers 2 August 30th, 2007 05:41 PM
layout problem: aligning several datagrids vertically Mark Wiewel answers 3 March 8th, 2006 11:05 PM