Prev: Is it worth it for me to learn Access?
Next: Help with Function: Between Time
From: nickname on 26 May 2010 12:01
I am relatively new to access. I am using access 2007 to create a
report that contains subtotals. When the report is displayed on the
screen the subtotals are blank. When the user clicks on the subtotal
text box then the value appears. The user has to click on each
subtotal in order to make the value appear.

Has anyone experience this problem? Is there a workaround or
solution?

Thanks
From: KenSheridan via AccessMonster.com on 27 May 2010 12:30
Normally a sub-total in a report is achieved by means of an unbound text box
in a group footer with a ControlSource property which is an expression
summing a set of values from the detail section, e.g.

=Sum([SaleAmount])

The sub-totals should then show automatically when the report is opened in
print preview or sent to a printer. Is yours set up in this way? Also is
there any code in the text box's Click event procedure; or any other of its
procedures for that matter?

Ken Sheridan
Stafford, England

nickname wrote:
>I am relatively new to access. I am using access 2007 to create a
>report that contains subtotals. When the report is displayed on the
>screen the subtotals are blank. When the user clicks on the subtotal
>text box then the value appears. The user has to click on each
>subtotal in order to make the value appear.
>
>Has anyone experience this problem? Is there a workaround or
>solution?
>
>Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201005/1

From: nickname on 28 May 2010 09:28
On May 27, 12:30 pm, "KenSheridan via AccessMonster.com" <u51882(a)uwe>
wrote:
> Normally a sub-total in a report is achieved by means of an unbound text box
> in a group footer with a ControlSource property which is an expression
> summing a set of values from the detail section, e.g.
>
> =Sum([SaleAmount])
>
> The sub-totals should then show automatically when the report is opened in
> print preview or sent to a printer.  Is yours set up  in this way?  Also is
> there any code in the text box's Click event procedure; or any other of its
> procedures for that matter?
>
> Ken Sheridan
> Stafford, England
>
> nickname wrote:
> >I am relatively new to access.  I am using access 2007 to create a
> >report that contains subtotals.  When the report is displayed on the
> >screen the subtotals are blank.  When the user clicks on the subtotal
> >text box then the value appears.  The user has to click on each
> >subtotal in order to make the value appear.
>
> >Has anyone experience this problem?  Is there a workaround or
> >solution?
>
> >Thanks
>
> --
> Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20...

Ken, thanks for the reply. It is set up as you describe: an unbound
textbox placed in the "group on" section of the report
=Sum([AmountToBill]) and there is no code in any of the text box
events.

It is interesting to note that the printed and print preview versions
of the report are fine. However, when I open the report (double click
on the report name in the left pane) it does not display the totals
(just blank space). The totals only appear if I click on the location
(textbox) where they should normally appear.

Thanks
From: KenSheridan via AccessMonster.com on 28 May 2010 11:48
Double clicking in the report object in Access 2007 opens it in 'Report View',
which is just a continuous layout of the report. I tried opening one of my
own reports, which includes a summary total in a group footer, in this way
but couldn't reproduce the behaviour you are experiencing; the summary total
showed immediately. I'm therefore at something of a loss to explain the
behaviour or a remedy, I'm afraid.

Ken Sheridan
Stafford, England

nickname wrote:
>On May 27, 12:30 pm, "KenSheridan via AccessMonster.com" <u51882(a)uwe>
>wrote:
>> Normally a sub-total in a report is achieved by means of an unbound text box
>> in a group footer with a ControlSource property which is an expression
>[quoted text clipped - 23 lines]
>> --
>> Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20...
>
>Ken, thanks for the reply. It is set up as you describe: an unbound
>textbox placed in the "group on" section of the report
>=Sum([AmountToBill]) and there is no code in any of the text box
>events.
>
>It is interesting to note that the printed and print preview versions
>of the report are fine. However, when I open the report (double click
>on the report name in the left pane) it does not display the totals
>(just blank space). The totals only appear if I click on the location
>(textbox) where they should normally appear.
>
>Thanks

--
Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: Is it worth it for me to learn Access?
Next: Help with Function: Between Time