How many subforms can I have in Access 97?

[musicloverlch]

I have a form with a subform that has a subform that has a subform that
has a subform. The 5th embedded subform never opens in Access 97 and I
get a message that 'a form has caused 1 error.' When I open the form in
Access 2k, it's fine. The users are using Access 97. What do I have
to do to get it to cooperate??

Thanks in advance,
Laura

[Jeff Smith]

"musicloverlch" <lh****@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I have a form with a subform that has a subform that has a subform that
has a subform. The 5th embedded subform never opens in Access 97 and I
get a message that 'a form has caused 1 error.' When I open the form in
Access 2k, it's fine. The users are using Access 97. What do I have
to do to get it to cooperate??

Thanks in advance,
Laura

From the Access 97 Help File

Attribute Maximum
Number of characters in a label 2,048
Number of characters in a text box 65,535
Form or report width 22 in. (55.87 cm)
Section height 22 in. (55.87 cm)
Height of all sections plus section headers (in Design view) 200 in. (508
cm)
Number of levels of nested forms or reports 3
Number of fields or expressions you can sort or group on in a report 10
Number of headers and footers in a report 1 report header/footer; 1 page
header/footer; 10 group headers/footers
Number of printed pages in a report 65,536
Number of controls and sections you can add over the lifetime of the form or
report 754

[Justin Hoffman]

"musicloverlch" <lh****@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I have a form with a subform that has a subform that has a subform that
has a subform. The 5th embedded subform never opens in Access 97 and I
get a message that 'a form has caused 1 error.' When I open the form in
Access 2k, it's fine. The users are using Access 97. What do I have
to do to get it to cooperate??

Thanks in advance,
Laura

As far as I know, the most complex Access will let you have is: Form with a
subform which itself has a subform. I have never found a situation where I
needed anything more complex than this - and I'm sure anything more complex
would be pretty ugly for the user.
We don't really know what you're doing but perhaps you need something more
like a treeview control where you can show a heirarchical structure - but a
subform of a subform of a subform of a subform? And you have this working
in A2K?

[musicloverlch]

Well, crap.

My company is going to Office 2K3 in Sept, but right now they are on
Access 97.

Yes, it works great in Access 2k.

Thanks for quick responses. I really, really appreciate it!
:-)

[Justin Hoffman]

"musicloverlch" <lh****@gmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

Well, crap.

My company is going to Office 2K3 in Sept, but right now they are on
Access 97.

Yes, it works great in Access 2k.

Thanks for quick responses. I really, really appreciate it!
:-)

Does that mean you do not require further help?
If you do, perhaps you could share some further details of this setup? For
example, Main form shows an order, subform shows order items and final level
is in datasheet mode showing several part deliveries on each order item.

[musicloverlch]

No, I don't need anything else. I'll just build a workaround until we
get Access 2k3.

Thanks

[lylefair]

An Access subform is an Access form positioned within a control on
another form. The parent form's events are programmed by Access to
modify the child form.
There is nothing magical about this. A Developer can do what Access
does.
Duplicating this "sub-form" capability in code requires only a few
lines in the main form. These lines open the sub-form, change its data
onCurrent, and set its default values.
One can create as many of these roll-your-own sub forms as one wants.
They retain all the power of a full Access form; for instance they can
be moved or sized. They are just as fast as a subform.

It's been quite a long time since I have bothered with an Access
subform.

[polite person]

On 28 Jul 2005 02:14:24 -0700, "lylefair" <ly******@yahoo.ca> wrote:

......

It's been quite a long time since I have bothered with an Access
subform.

interesting, as it is the one thing which is far easier to do in Access than in anything
else. .
(I did say "far")

[polite person]

On 28 Jul 2005 04:42:03 -0500, sitting@ease (polite person) wrote:

On 28 Jul 2005 02:14:24 -0700, "lylefair" <ly******@yahoo.ca> wrote:

.....

It's been quite a long time since I have bothered with an Access
subform.

interesting, as it is the one thing which is far easier to do in Access than in anything
else. .
(I did say "far")

though maybe you mean that you still use subforms, but roll-your-own ones rather
than Access ones.

[lylefair]

Yes.

[David W. Fenton]

"lylefair" <ly******@yahoo.ca> wrote in
news:11*********************@g47g2000cwa.googlegro ups.com:

An Access subform is an Access form positioned within a control on
another form. The parent form's events are programmed by Access to
modify the child form.
There is nothing magical about this. A Developer can do what
Access does.
Duplicating this "sub-form" capability in code requires only a few
lines in the main form. These lines open the sub-form, change its
data onCurrent, and set its default values.
One can create as many of these roll-your-own sub forms as one
wants. They retain all the power of a full Access form; for
instance they can be moved or sized. They are just as fast as a
subform.

It's been quite a long time since I have bothered with an Access
subform.

Are you completely insane, Lyle?

Or do you just like the challenge of re-inventing the wheel?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Larry Linson]

"David W. Fenton" wrote

Are you completely insane . . .

I thought that was a necessary condition for participating in this
newsgroup, David. :-) On the other hand, perhaps one doesn't have to be
_completely_ insane, just _insane enough_.