How to get “total row” of a access form (datasheet) using interop C#

Question

1.00/5 (1 vote)

See more:

How to get "Footer row"(Sum or Count) of a Access Form (DataSheet)
I search the Total rows in Form Controls but I am not getting anything for it.

What I have tried:

C#

ACCESS.DoCmd.OpenForm("FormName");
ACCESS.Controls cntrls = (ACCESS.Controls)app.Forms["FormName"].Controls;

Posted 30-Aug-16 4:34am

IamWsk

Updated 22-Aug-19 4:51am

v9

Add a Solution

Comments

IamWsk 30-Aug-16 10:41am

Any Idea @Richard MacCuthan?

Maciej Los 30-Aug-16 10:44am

What are you talking about?
All you need to do is to get the count of records of bounded datasource for that form.

IamWsk 30-Aug-16 10:47am

There is a option in Access Forms to add Sum or count for Datasheet form I need that property by using interop

IamWsk 30-Aug-16 10:48am

I want to validate that property whether user added sum or not

Maciej Los 30-Aug-16 12:47pm

Well, i'm afraid, you cannot access to closed form. You need to open it, then you'll be able to access to its controls.

Maciej Los 30-Aug-16 12:58pm

Well, i'm afraid, you cannot access to closed form. You need to open it, then you'll be able to access its controls.

IamWsk 8-Sep-16 3:53am

I opened the that form but I am getting only 8 controls, 4 for label control which is header label and rest are textbox where all data gets populate.
where I can find footer row?

IamWsk 22-Aug-19 10:51am

Any clue for "Total Row"?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2016-08-30T06:52:00

Solution 1

Please, read my comment to the question. As i mentioned there: You need to open it (form) to be able to access to its controls.

See: How to automate Microsoft Access by using Visual C# [^] - Show And Edit an Access Form part.

Posted 30-Aug-16 6:52am

Maciej Los

Updated 30-Aug-16 6:53am

v2

Comments

IamWsk 8-Sep-16 4:06am

I open the form then only I am using my above code.
But the total rows where all the columns sum or totals appears where can i find that.

IamWsk 22-Aug-19 10:52am

Any clue?

Maciej Los 22-Aug-19 11:34am

Check this: Summing in reports - Access[^]