Subform Datasheet Total Row

[HeatherG]

Hi
Is it possible in either Access 2007 or Access 2010 to create a toggle
button on a form to show or hide the total row in a datasheet? I have
a subform that displays data in a datasheet, but would like to provide
the option to show or hide totals, without the user having to click on
the Totals button in the ribbon, and then choose the calculation.
Thanks
Heather

 

[Neil]

Why not just give the user a form in continuous form mode where you control
what goes in the footer, and you can show/hide the totals, change them to
whatever you want, using your own custom buttons or whatever other method
you choose to modify them?

 

[HeatherG]

Why not just give the user a form in continuous form mode where you control
what goes in the footer, and you can show/hide the totals, change them to
whatever you want, using your own custom buttons or whatever other method
you choose to modify them?






- Show quoted text -

Neil,
Thanks for your response. I gather that from extensive searching in
the various forums etc that there is no way to programmatically access
the Total row feature as this seems to be the standard answer to
anyone referring to the Total row option. Thanks for taking the
trouble to provide this alternative.
Heathr

 

[Neil]

Why not just give the user a form in continuous form mode where you
control
what goes in the footer, and you can show/hide the totals, change them to
whatever you want, using your own custom buttons or whatever other method
you choose to modify them?






- Show quoted text -

Neil,
Thanks for your response. I gather that from extensive searching in
the various forums etc that there is no way to programmatically access
the Total row feature as this seems to be the standard answer to
anyone referring to the Total row option. Thanks for taking the
trouble to provide this alternative.
Heathr

========================================

Well, if you think about it, Datasheet View is really just a quick way for a
user to see things in a grid. If a programmer wants to have programmatic
control, then Continuous Form view can accomplish the same thing as
Datasheet View (except for user-adjustable column widths), but with
programmatic capabilities.

Thus, I don't think Datasheet View is intended for programmatic purposes,
except very basic ones. As a programmer, I never use it to design a form
when I need a grid. I always use Continuous Form view. And if I need it to
look like Datasheet View, I can do that.

I think Datasheet View is really just intended as an end-user convenience
more than as a programmable tool.

Neil