This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.
Course Of The Month
10 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Access 2003 SubForm Limit
Posted on 2013-01-02
Is there a limit to the number of subforms in MS Access 2003?
I think I read somewhere it's 7...but what does that mean?
Does it mean that THIS would be the limit?
MainForm
SubForm1 Subform2 Subform3
SubForm1_1 SubForm1_2 SubForm1_3
Or THIS?
MainForm
SubForm1
SubForm1
SubForm1
SubForm1
SubForm1
SubForm1
I think I read somewhere it's 7...but what does that mean?
Does it mean that THIS would be the limit?
MainForm
SubForm1 Subform2 Subform3
SubForm1_1 SubForm1_2 SubForm1_3
Or THIS?
MainForm
SubForm1
SubForm1
SubForm1
SubForm1
SubForm1
SubForm1
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5
3
9 Comments
Active today
ah just did a double check and that changed at some point from 3 to 7. 3 was the old limit for nested forms.
BTW, the other way (non-nested) is just a limit on resources available; I'm not aware of any limit there other then 754 controls over the lifetime of a form (which I'm thinking as I'm saying that, has changed as well to over 1200).
Jim.
BTW, the other way (non-nested) is just a limit on resources available; I'm not aware of any limit there other then 754 controls over the lifetime of a form (which I'm thinking as I'm saying that, has changed as well to over 1200).
Jim.
Active today
'over 1200'
really ... about time.
wait ... this spec is still showing 754 ...
http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx
where did you see this ?
mx
really ... about time.
wait ... this spec is still showing 754 ...
http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx
where did you see this ?
mx
Active today
<<where did you see this ?>>
I actually tested it. With each release since A97, the number of controls has gone up.
I'll see if I can find the post...I may even have the DB I tested with lying around.
Jim.
I actually tested it. With each release since A97, the number of controls has gone up.
I'll see if I can find the post...I may even have the DB I tested with lying around.
Jim.
Active today
OK found my old posts (it is from another developers list):
A2 - 653
A97 - 752
A2000 - 800
A2002 - 894
A2003 - 895
A2007 - 1040
A2010 - 1040
So the current limit is not as high as I was thinking (1200), but it's 1040 which is well above the published spec.
Code that was used to check this is below. Control type didn't seem to make a difference (I only tested labels and text controls though) as I got the same numbers each way. This code was also run on multiple machines and verified by different people. All got the same numbers.
So apparently the control creation limit is not a hard limit, but based on some other internal constraint. This is similar to the table ID limit, which is stated as 2048, but actually floats a bit.
These limits are somehow tied to the way Access internally handles open objects, but what that process is is un-clear.
Jim.
Public Sub CheckControlCreation()
Dim frm As Form
Dim ctlText As Control
Dim ctlLabel As Control
Dim intK As Integer
' Create form based on Customers form.
Set frm = CreateForm()
For intK = 1 To 2000
' Create unbound default-size text box in detail section.
Set ctlText = CreateControl(frm.Name, acTextBox, acDetail, , , 100 + intK, 100 + intK, 200, 200)
' Create child label control for text box.
Set ctlLabel = CreateControl(frm.Name, acLabel, , ctlText.Name, "", 100, 100)
Debug.Print ctlText.Name, ctlLabel.Name
Next intK
End Sub
A2 - 653
A97 - 752
A2000 - 800
A2002 - 894
A2003 - 895
A2007 - 1040
A2010 - 1040
So the current limit is not as high as I was thinking (1200), but it's 1040 which is well above the published spec.
Code that was used to check this is below. Control type didn't seem to make a difference (I only tested labels and text controls though) as I got the same numbers each way. This code was also run on multiple machines and verified by different people. All got the same numbers.
So apparently the control creation limit is not a hard limit, but based on some other internal constraint. This is similar to the table ID limit, which is stated as 2048, but actually floats a bit.
These limits are somehow tied to the way Access internally handles open objects, but what that process is is un-clear.
Jim.
Public Sub CheckControlCreation()
Dim frm As Form
Dim ctlText As Control
Dim ctlLabel As Control
Dim intK As Integer
' Create form based on Customers form.
Set frm = CreateForm()
For intK = 1 To 2000
' Create unbound default-size text box in detail section.
Set ctlText = CreateControl(frm.Name, acTextBox, acDetail, , , 100 + intK, 100 + intK, 200, 200)
' Create child label control for text box.
Set ctlLabel = CreateControl(frm.Name, acLabel, , ctlText.Name, "", 100, 100)
Debug.Print ctlText.Name, ctlLabel.Name
Next intK
End Sub
Active today
How funny ... imagine - a spec that Microsoft has wrong. I wonder how many others of off ?
Interesting difference between A2002 and A2003 .... one control.
mx
Interesting difference between A2002 and A2003 .... one control.
mx
Active today
I think the spec was written at the time of A95/A97 (that's when it first appeared), and has simply been carried forward without anyone really checking it.
Meanwhile, the process that's involved with the limit has evolved over time and allows more. Whether that's by design or just a by-product of other changes is hard to say.
Seems strange too that it's gone up in every release, so my guess it's a result of something else.
and the really weird part; no where did we come up with 754!
Jim.
Meanwhile, the process that's involved with the limit has evolved over time and allows more. Whether that's by design or just a by-product of other changes is hard to say.
Seems strange too that it's gone up in every release, so my guess it's a result of something else.
and the really weird part; no where did we come up with 754!
Jim.
Featured Post
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read our article on Experts Exchange.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 17 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
628 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.