473,405 Members | 2,300 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

'Tab Control' (TabCtl), subforms; performance question

Hello,

If I have a form containing a Tab Control with N pages, each page
containing a subform, are those subforms loaded into memory when
another page has the focus? I have tried iterating through the
AllForms collection, but it only shows the parent form as being loaded.
I have a project with a large number of single forms that I would like
to group together under one or a few parent forms, using Tab Controls
to accomplish this; however, my users are in a shared-resource
environment (Citrix) with limited resources, and if all subforms in all
pages are loaded at all times, I would probably need to keep the page
count for each parent form to a minimum.
If anyone has any comments ofradvice, I would very much appreciate
hearing them.

Much Thanks,

Robert Waters

Sep 26 '06 #1
2 4525
ro***********@gmail.com wrote in
news:11*********************@m7g2000cwm.googlegrou ps.com:
If I have a form containing a Tab Control with N pages, each page
containing a subform, are those subforms loaded into memory when
another page has the focus?
Yes. The subforms are populated when the main form is loaded.
I have tried iterating through the
AllForms collection, but it only shows the parent form as being
loaded.
That's because the subforms are loaded as children of the main form,
so their name is not the same as their name when they are not
imbedded. You'd find the same thing when you use the Forms
collection (which is for open forms only).
I have a project with a large number of single forms that I would
like to group together under one or a few parent forms, using Tab
Controls to accomplish this; however, my users are in a
shared-resource environment (Citrix) with limited resources, and
if all subforms in all pages are loaded at all times, I would
probably need to keep the page count for each parent form to a
minimum. If anyone has any comments ofradvice, I would very much
appreciate hearing them.
Load the subforms in the OnChange event of the tab control.

Or use the tab control as a tab strip and use its OnChange event to
swap out multiple subforms in a single subform control (if you don't
have any other controls on your tab pages).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Sep 26 '06 #2

David W. Fenton wrote:
Or use the tab control as a tab strip and use its OnChange event to
swap out multiple subforms in a single subform control (if you don't
have any other controls on your tab pages).
Thank you David; I've swapped the SourceObject property of the subform
when TabCtl onChange occurs. Thank you very much for your help.

-Robert

Sep 26 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: AccessWhiz | last post by:
I have had some good success using MouseHook from Stephen Lebans. (I've downloaded and am using the current version of MouseHook dated 7/2/2003). However, I do have a question regarding...
0
by: Jenni | last post by:
I currently have a query that is joining two distinct pools of information and turning them into one records with a unique identifier This query is dependent on criteria passed from a form in a...
3
by: Not Me | last post by:
Hi, Just trying to get my head around tab controls, is there anywhere which would describe the structure of how they work? I seem to be ok so far, being able to check which page I'm on etc......
3
by: Steven | last post by:
My from has a Tab Control on it with four Pages. I want to run some code when one of the Pages get selected. How can I tell when one or even which one gets selected? The "click" event for the...
0
by: misscrf | last post by:
I have an entry form which has a tab control. If print screens are needed, please let me know and I will prepare them and post them. Anyway, this tab control has 3 pages. When I am on one of the...
2
by: pietlinden | last post by:
I have a stupid question (so finish swallowing now... I don't want to be accused of any beverage-related mishaps). I have a form with several subforms, with each subform on a separate tab. I'm...
7
by: ApexData | last post by:
I am using the following code in my TabControl to manage subform loads. The code assigns the subForms SourceObject. - Do I also need code to DeAssign the SourceObject when leaving the Tab, I'm...
1
by: (PeteCresswell) | last post by:
Posted this on microsoft.public.access a few days ago, but no nibbles. ---------------------------------------------------------------------------------------------------- I've got a form with a...
2
by: angi35 | last post by:
I hope this is an easy question for someone out there. In Access 2000…I have a MainForm with a tab control (MAIN TABS) with 7 tabs. Within each tab is a SubForm. Within each SubForm is a tab...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.