Checking for a sum totals row in a table

[blueboi]

Hello!

I have a very specific question that I can't seem to find an answer to anywhere. I am trying to find where in the visual basic watch window I can check for
what mode a totals row is in for a certain table. I know by going to Application.CurrentDB.TableDefs("TableName").Prope rties("TotalsRow").value, I can see if there is a totals row in the table "TableName", I just can't
see if its calculating the sum for a certain column. I cannot do this via any other means i.e. a Dsum query or anything like that, I have to be able to see if there is a totals row in the table and what its value is, or what mode it is using.


Any help is much appreciated!

-Cheers!

[ranman256]

use a report or form,
it will show you the total at the footer.
=Sum(field)

[blueboi]

That works! Much appreciated! If you could help out a bit more, is there a way to generate a report from a table using VBA?

[June7]

What do you mean by 'generate' - create a report from scratch with code? Code adds textboxes and sets properties? Why?

Or do you mean VBA just opens a report object?

[blueboi]

I mean VBA opens a report object populated with the contents of the table I was talking about earlier, similar to how in access you can produce a report from a table using the report button under the create tab.
To give you an idea of the whole scope here, this is for a project that "tests" people learning how to use Access, so a user would take a db, make changes to it, and I use snippets of vba to evaluate their changes and ensure they did things properly.

[June7]

Well, use DoCmd.OpenReport in some event, such as a button click.