Total problem in subform

[ken]

I have a formA and subformB
subformB is a continous form
with a txtTotal in form footer
=Sum([Total])
This works fine as long as there are
records in form
but if form is null I get Error
I would like to get arround this as I
Have a label to be Visible only
if txtTotal>= 45000
The way it is now label shows up visible
on form when it has no records
thank you for any suggestions

[steve.minnaar]

I mailed a working example to <ke******@yahoo .com>

Please have a look at it.
*** Sent via Developersdex http://www.developersdex.com ***

[Wayne Gillespie]

On Fri, 10 Feb 2006 17:46:18 GMT, steve.minnaar <st*****@concis e.com> wrote:

I mailed a working example to <ke******@yahoo .com>

Please have a look at it.

How?

Wayne Gillespie
Gosford NSW Australia

[steve.minnaar]

I saw:

From: Wayne Gillespie
Date Posted: 2/9/2006 6:27:00 PM

On 1 Feb 2006 16:58:34 -0800, "ken" <ke******@yahoo .com> wrote:

I have a formA and subformB
subformB is a continous form
with a txtTotal in form footer
=Sum([Total])

..
..
..
So I mailed the solution to the address above.

If that will not work then give me an address like:
"ken at mydomain dot extension" and I'll mail it.

My email address is "steve at concisedata dot co dot za"

*** Sent via Developersdex http://www.developersdex.com ***

[Wayne Gillespie]

On Sat, 11 Feb 2006 00:42:15 GMT, steve.minnaar <st*****@concis e.com> wrote:

I saw:

From: Wayne Gillespie
Date Posted: 2/9/2006 6:27:00 PM

On 1 Feb 2006 16:58:34 -0800, "ken" <ke******@yahoo .com> wrote:

I have a formA and subformB
subformB is a continous form
with a txtTotal in form footer
=Sum([Total])

.
.
.
So I mailed the solution to the address above.

If that will not work then give me an address like:
"ken at mydomain dot extension" and I'll mail it.

My email address is "steve at concisedata dot co dot za"

You have emailed the db to the OP. (which is where it should go)
Wayne Gillespie
Gosford NSW Australia

[steve.minnaar]

Plea in General: I am new to news groups and am not familiar with the
techniques and terms used here. I've looked at various guidelines but am
still not much wiser.

This I do know:
There is a user out there called Ken with a problem.
I have solved the problem but need to send a complete mdb to demonstrate
this.
I may not post attachments to the group (even though I don't know how
to)
I do want him to get the solution.

This need to know about groups:
What OP stands for.
Who can see the mail sent to OP.
How I can ensure that Ken received the solution.
How I can make the solution available to any other interested user?
If an email client is used to communicate with the group how do I do it?

Is there a plain document out there which explains all of this?

From: Wayne Gillespie

On Sat, 11 Feb 2006 00:42:15 GMT, steve.minnaar <st*****@concis e.com>
wrote:

I saw:

From: Wayne Gillespie
Date Posted: 2/9/2006 6:27:00 PM

On 1 Feb 2006 16:58:34 -0800, "ken" <ke******@yahoo .com> wrote:

I have a formA and subformB
subformB is a continous form
with a txtTotal in form footer
=Sum([Total])

.
.
.
So I mailed the solution to the address above.

If that will not work then give me an address like:
"ken at mydomain dot extension" and I'll mail it.

My email address is "steve at concisedata dot co dot za"

You have emailed the db to the OP. (which is where it should go)
Wayne Gillespie
Gosford NSW Australia

*** Sent via Developersdex http://www.developersdex.com ***

[Wayne Gillespie]

On Sat, 11 Feb 2006 02:08:12 GMT, steve.minnaar <st*****@concis e.com> wrote:

Plea in General: I am new to news groups and am not familiar with the
techniques and terms used here. I've looked at various guidelines but am
still not much wiser.

This I do know:
There is a user out there called Ken with a problem.
I have solved the problem but need to send a complete mdb to demonstrate
this.
I may not post attachments to the group (even though I don't know how
to)
I do want him to get the solution.

This need to know about groups:
What OP stands for.
Who can see the mail sent to OP.
How I can ensure that Ken received the solution.
How I can make the solution available to any other interested user?
If an email client is used to communicate with the group how do I do it?

Is there a plain document out there which explains all of this?

No problems.
You did send the db to Ken's email address, but you replied to my post asking me
to look at the database you emailed to Ken. Hence my "How?"

OP stands for Original Poster.
Wayne Gillespie
Gosford NSW Australia

[ken]

Thanks Steve and Wayne
Really appreciate your help
Ken
steve.minnaar wrote:

I saw:

From: Wayne Gillespie
Date Posted: 2/9/2006 6:27:00 PM

On 1 Feb 2006 16:58:34 -0800, "ken" <ke******@yahoo .com> wrote:

I have a formA and subformB
subformB is a continous form
with a txtTotal in form footer
=Sum([Total])

.
.
.
So I mailed the solution to the address above.

If that will not work then give me an address like:
"ken at mydomain dot extension" and I'll mail it.

My email address is "steve at concisedata dot co dot za"

*** Sent via Developersdex http://www.developersdex.com ***