By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,252 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,252 IT Pros & Developers. It's quick & easy.

Access2K vs Access2002 Sums

P: n/a
I am using a control MyTotal on a subform footer to get a sum of all
rows on the subform: =Sum([Amount])
On the main form I have a control whose controlsource is:
=Forms!FormName.Child.Form.MyTotal.
This displays the sum of the subform.
It works fine on Access 2000 but displays an error in Access 2002. I
can't figure this one out.
lq

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"laurenq uantrell" <la*************@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
I am using a control MyTotal on a subform footer to get a sum of all
rows on the subform: =Sum([Amount])
On the main form I have a control whose controlsource is:
=Forms!FormName.Child.Form.MyTotal.
This displays the sum of the subform.
It works fine on Access 2000 but displays an error in Access 2002. I
can't figure this one out.
lq


It should be = Me . [MySubForm] . Form ! [MyTotal]

Do you really use "Child" as the name for your subform?
May be "Child" is a reseved word for Access 2002.

Bruno

Nov 13 '05 #2

P: n/a
"Bruno Campanini" wrote
I am using a control MyTotal on a subform
footer to get a sum of all rows on the subform:
=Sum([Amount])
On the main form I have a control whose
controlsource is:
=Forms!FormName.Child.Form.MyTotal.
This displays the sum of the subform.
It works fine on Access 2000 but displays
an error in Access 2002. I
can't figure this one out.
lq


It should be = Me . [MySubForm] . Form ! [MyTotal]

Do you really use "Child" as the name for your subform?
May be "Child" is a reseved word for Access 2002.

Bruno


A form could have two SubForm controls at the same level -- which one would
be the "Child"? I don't have Access 2000 handy to try, but I would expect it
to give some kind of error. "Parent", on the other hand, is unambigous.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #3

P: n/a
Larry,
I renammed the subform "Child1" and still have the same problem.
I have always used the naming convention of naming a subform "Child"
and the second subform Child2, etc. It has been a big help in
simplifying code, such as allowing me to create generic code for
changing control attributes and the like.

I realized this problem went even deeper. In this user environment
there are two machines running Access2002 and this happens only on one
machine! Both are running Windows2000.

I am completely baffled.

When I go to the culprit machine, I installed this subform as a
continuous form (instead of a datasheet) which allowed me to see the
sum control ctlMySum in the subform's form footer containing the
controlsource "=Sum([Amount])"
On the offending machine, this control is blank! So the control on the
Parent form that has the controlsource
"=Forms!FormName.CHild.Form.ctlMySum" returns an error. However, on all
other machines it's fine.

lq

Larry Linson wrote:
"Bruno Campanini" wrote
> > I am using a control MyTotal on a subform
> > footer to get a sum of all rows on the subform:
> > =Sum([Amount])
> > On the main form I have a control whose
> > controlsource is:
> > =Forms!FormName.Child.Form.MyTotal.
> > This displays the sum of the subform.
> > It works fine on Access 2000 but displays
> > an error in Access 2002. I
> > can't figure this one out.
> > lq >
> It should be = Me . [MySubForm] . Form ! [MyTotal]
>
> Do you really use "Child" as the name for your subform?
> May be "Child" is a reseved word for Access 2002.
>
> Bruno


A form could have two SubForm controls at the same level -- which one

would be the "Child"? I don't have Access 2000 handy to try, but I would expect it to give some kind of error. "Parent", on the other hand, is unambigous.
Larry Linson
Microsoft Access MVP


Nov 13 '05 #4

P: n/a
laurenq uantrell wrote:

[snip]

What happened to your "q"? :-)

--
This sig left intentionally blank
Nov 13 '05 #5

P: n/a
I don't know what the problem is. Some things to check are:

(1) Was the install of Access successful on that machine? (If not,
uninstall and reinstall.)
(2) What are the differences in Operating System setup between the machine
where it works and the one where it doesn't work?
(3) Are there any differences in Access' Tools | Options between the
machine where it works and the one where it doesn't work?
(4) Are there _any_ differences in the front-end database (assuming you
are working with a front-end/back-end split database) on those machines?
(5) Are there any differences in the data being accessed on the two
machines?

Even with the answers to all these questions, it may not be obvious what the
problem is.

Larry Linson
Microsoft Access MVP
"laurenq uantrell" <la*************@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
Larry,
I renammed the subform "Child1" and still have the same problem.
I have always used the naming convention of naming a subform "Child"
and the second subform Child2, etc. It has been a big help in
simplifying code, such as allowing me to create generic code for
changing control attributes and the like.

I realized this problem went even deeper. In this user environment
there are two machines running Access2002 and this happens only on one
machine! Both are running Windows2000.

I am completely baffled.

When I go to the culprit machine, I installed this subform as a
continuous form (instead of a datasheet) which allowed me to see the
sum control ctlMySum in the subform's form footer containing the
controlsource "=Sum([Amount])"
On the offending machine, this control is blank! So the control on the
Parent form that has the controlsource
"=Forms!FormName.CHild.Form.ctlMySum" returns an error. However, on all
other machines it's fine.

lq

Larry Linson wrote:
"Bruno Campanini" wrote
> > I am using a control MyTotal on a subform
> > footer to get a sum of all rows on the subform:
> > =Sum([Amount])
> > On the main form I have a control whose
> > controlsource is:
> > =Forms!FormName.Child.Form.MyTotal.
> > This displays the sum of the subform.
> > It works fine on Access 2000 but displays
> > an error in Access 2002. I
> > can't figure this one out.
> > lq
>
> It should be = Me . [MySubForm] . Form ! [MyTotal]
>
> Do you really use "Child" as the name for your subform?
> May be "Child" is a reseved word for Access 2002.
>
> Bruno


A form could have two SubForm controls at the same level -- which one

would
be the "Child"? I don't have Access 2000 handy to try, but I would

expect it
to give some kind of error. "Parent", on the other hand, is

unambigous.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.