Question Totals in a datasheet (1 Viewer)

[munhun]

Hello.
Help me.

Click the "Home" tab -> Record -> Total to get the sum in the datasheet.

I want to implement this menu button with vba.
What is VBA code?

ex) docmd.RunCommand ????

I would appreciate your reply by e-mail.
jeongmunhun
@ gmail . com

Thank you.

 

[theDBguy]

Try.

CommandBars.ExecuteMso "RecordsTotals"

 

[Pat Hartman]

If you are using a newer version of Access, you can embed totals in the datasheet itself. No code is required. Just use the Totals button and pick the type of aggregation by choosing from the dropdown under each column. What version of Access are you using?

 

[munhun]

CommandBars.ExecuteMso "RecordsTotals" ... Good code.

But....
One more question.

Do you know if "RecordsTotals" is displayed or not?
I want to show when a record is present and not when it is not.

It is causing problems when there are no records.

 

[Galaxiom]

In my experience, the display of Totals in datasheets can be a bit flaky especially when filtering.

If I use a datasheet I usually put the total expression as the ControlSource of a textbox in the header or footer. The header or footer won't display but it can be referred to from other objects.

Put the datasheet in a subform and refer to it from a control on the main form.

This technique works in all version of Access.

 

[munhun]

Even if it's not a good idea...

When there is no record "SourceObject = ''"

form_name.SourceObject = ""

Thank you...