running out of resources

[sparks]

I am working on an old database that is to be expanded.
It is going from a 1 time data set to 9.
So it has more tables and forms and subforms.
the problem is once I added 3 more sets of forms I get
can not open any more tables.
(no more tables are being used than before its just a ton of sub forms
tied to those tables)

Right now I have a tabctl that has tabs for each date

then another tabctl that displays the tabs based on the previous
tabctl value.

Is there a way of breaking down this big tabctl with 48 tabs an have
6 tabs on each control and only those are open and visible to try and
cut down on the resource usage.

Just turning on and off the visible or enabled won't work since they
are opened on database load and will use of the resources anyway.

I need to have 6 of the subforms open and loaded at a time based on
what is selected on the main ctltab.

So main form with tabctl(1-8)
click 1 and either a form with the 6 tabs and forms comes up.

us a subform or another tabctl or ???

thanks for any ideas I have run out of ideas

[storrboy]

On Mar 6, 12:05 pm, sparks <[e-mail]:

I am working on an old database that is to be expanded.
It is going from a 1 time data set to 9.
So it has more tables and forms and subforms.
the problem is once I added 3 more sets of forms I get
can not open any more tables.
(no more tables are being used than before its just a ton of sub forms
tied to those tables)

Right now I have a tabctl that has tabs for each date

then another tabctl that displays the tabs based on the previous
tabctl value.

Is there a way of breaking down this big tabctl with 48 tabs an have
6 tabs on each control and only those are open and visible to try and
cut down on the resource usage.

Just turning on and off the visible or enabled won't work since they
are opened on database load and will use of the resources anyway.

I need to have 6 of the subforms open and loaded at a time based on
what is selected on the main ctltab.

So main form with tabctl(1-8)
click 1 and either a form with the 6 tabs and forms comes up.

us a subform or another tabctl or ???

thanks for any ideas I have run out of ideas

Are all the tabs by date the same subform just named differently to
show a specific (set of) record(s)? If so, would it not be easier to
filter one subform by date, that to repeat it numerous times?

[storrboy]

On Mar 6, 12:05 pm, sparks <[e-mail]:

I am working on an old database that is to be expanded.
It is going from a 1 time data set to 9.
So it has more tables and forms and subforms.
the problem is once I added 3 more sets of forms I get
can not open any more tables.
(no more tables are being used than before its just a ton of sub forms
tied to those tables)

Right now I have a tabctl that has tabs for each date

then another tabctl that displays the tabs based on the previous
tabctl value.

Is there a way of breaking down this big tabctl with 48 tabs an have
6 tabs on each control and only those are open and visible to try and
cut down on the resource usage.

Just turning on and off the visible or enabled won't work since they
are opened on database load and will use of the resources anyway.

I need to have 6 of the subforms open and loaded at a time based on
what is selected on the main ctltab.

So main form with tabctl(1-8)
click 1 and either a form with the 6 tabs and forms comes up.

us a subform or another tabctl or ???

thanks for any ideas I have run out of ideas

Are all the tabs by date the same subform just named differently to
show a specific (set of) record(s)? If so, would it not be easier to
filter one subform by date, than to repeat it numerous times?

[sparks]

Each of these subforms has numerous subforms on it as well.
It ended up that each visit had 6 tabs and each of these had a subform
that contained from 1 to 24 subforms on each one.
I finally just gave up and made an unbound form.
based on what the selection was on the tab I set the SourceObject of
that form to a form that just had the tabs and subforms for one
particular visit.. It was not fun but now it works.
Now all I have to do is figure out how to get to a subform on this in
code.
On 6 Mar 2007 16:12:45 -0800, "storrboy" <st******@sympatico.ca>
wrote:

>On Mar 6, 12:05 pm, sparks <[e-mail]:

>I am working on an old database that is to be expanded.
It is going from a 1 time data set to 9.
So it has more tables and forms and subforms.
the problem is once I added 3 more sets of forms I get
can not open any more tables.
(no more tables are being used than before its just a ton of sub forms
tied to those tables)

Right now I have a tabctl that has tabs for each date

then another tabctl that displays the tabs based on the previous
tabctl value.

Is there a way of breaking down this big tabctl with 48 tabs an have
6 tabs on each control and only those are open and visible to try and
cut down on the resource usage.

Just turning on and off the visible or enabled won't work since they
are opened on database load and will use of the resources anyway.

I need to have 6 of the subforms open and loaded at a time based on
what is selected on the main ctltab.

So main form with tabctl(1-8)
click 1 and either a form with the 6 tabs and forms comes up.

us a subform or another tabctl or ???

thanks for any ideas I have run out of ideas

Are all the tabs by date the same subform just named differently to
show a specific (set of) record(s)? If so, would it not be easier to
filter one subform by date, than to repeat it numerous times?

[Larry Linson]

Good relational database design principles can often overcome problems
similar to yours. It is entirely possible that, had you precisely and
concisely described the data / information you are dealing with, and the
business requirements of the application, someone could have suggested an
approach that didn't require such a complex interface to deal with the
business issue.

It is almost never _necessary_ to go to unbound forms to deal with business
issues, if the requirements and data have been carefully analyzed, and a
good relational design applied.

I can, without even seeing your application, tell you that the kind of
form/window structure you describe is NOT a user-friendly, easy-to-use
interface. On rare occasions, a very complex UI may be justified, but
"rare" is the operative word.

Larry Linson
Microsoft Access MVP
"sparks" <js******@swbell.netwrote in message
news:ef********************************@4ax.com...

Each of these subforms has numerous subforms on it as well.
It ended up that each visit had 6 tabs and each of these had a subform
that contained from 1 to 24 subforms on each one.
I finally just gave up and made an unbound form.
based on what the selection was on the tab I set the SourceObject of
that form to a form that just had the tabs and subforms for one
particular visit.. It was not fun but now it works.
Now all I have to do is figure out how to get to a subform on this in
code.
On 6 Mar 2007 16:12:45 -0800, "storrboy" <st******@sympatico.ca>
wrote:

>>On Mar 6, 12:05 pm, sparks <[e-mail]:

>>I am working on an old database that is to be expanded.
It is going from a 1 time data set to 9.
So it has more tables and forms and subforms.
the problem is once I added 3 more sets of forms I get
can not open any more tables.
(no more tables are being used than before its just a ton of sub forms
tied to those tables)

Right now I have a tabctl that has tabs for each date

then another tabctl that displays the tabs based on the previous
tabctl value.

Is there a way of breaking down this big tabctl with 48 tabs an have
6 tabs on each control and only those are open and visible to try and
cut down on the resource usage.

Just turning on and off the visible or enabled won't work since they
are opened on database load and will use of the resources anyway.

I need to have 6 of the subforms open and loaded at a time based on
what is selected on the main ctltab.

So main form with tabctl(1-8)
click 1 and either a form with the 6 tabs and forms comes up.

us a subform or another tabctl or ???

thanks for any ideas I have run out of ideas

Are all the tabs by date the same subform just named differently to
show a specific (set of) record(s)? If so, would it not be easier to
filter one subform by date, than to repeat it numerous times?