Dynamically Inserting Pages into Tab Controls

[Wendy]

I'm trying to create a school report system whereby the Tutor has overall
view of the tutees subject reports for that semester. I've got a XTab query
that displays all the reports for each of the students subjects, but each
student may study a different number of subjects.

Is there a way that I can generate the Tab pages when the student record is
accessed? I can give further detail of the tables and queries, but just
wondered if this was possible at all. I think it might be realistic using
asp.net, but I don't want to go down that route just yet, as this is the
prototype.

Many thanks for any suggestions, ideas...

Wendy

 

[Michel Walsh]

Hi,


I don't think we can do it at runtime with the Access supplied tab-control.
We can create extra tab, invisible, and make them visible at run-time, on
the other hand.


Hoping it ma help,
Vanderghast, Access MVP

 

[Wendy Parry]

Hi,


I don't think we can do it at runtime with the Access supplied tab-control.
We can create extra tab, invisible, and make them visible at run-time, on
the other hand.


Hoping it ma help,
Vanderghast, Access MVP

Hi,
Well I've code that can do it, but you have to switch the form to design
mode to add the pages.

I'm cool with that, but am having problems with the datasource that
should be placed on to the tab page once it's been created.

 

[Michel Walsh]

Hi,


yep, indeed, but opening a form in design mode is not really my definition
of "run-time", ... even if it is "border line" in this case.

The tab control is not really a container. The controls on specific tabs
still belong to the form, at 100%, and not to the tab control. A tab "page"
does not have a datasource, in itself. If you place a subform on a tab page,
then such subform can have a record source. You can create a single subform
outside the tab control and move it over the tab control, then, accordingly
to the active page, set the SourceObject of that subform (that will be
visible for all pages of the tab control).


Hoping it may help,
Vanderghast, Access MVP