473,320 Members | 1,982 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

About rept footer


Say, I have a report called saleRpt in Access 97, naturally it has a
header and body (some query), then, it has a footer like
Sum(saleTotal) -- saleTotal has been referenced in the body query.
Now, how do I get the content of the rept footer for this rept
programmatically? I understand the Reports collection has a property
called PageFooter, but that's not what I'm after. Shed some light,
Access guru?

TIA.

Nov 13 '05 #1
4 1276
NickName wrote:
Say, I have a report called saleRpt in Access 97, naturally it has a
header and body (some query), then, it has a footer like
Sum(saleTotal) -- saleTotal has been referenced in the body query.
Now, how do I get the content of the rept footer for this rept
programmatically? I understand the Reports collection has a property
called PageFooter, but that's not what I'm after. Shed some light,
Access guru?


The textbox containing the total value has a unique name within the
report regardless of it's placement, just reference it ny name.
Nov 13 '05 #2
Well, I guess we miscommunicated. I'm trying to figure out a way to
get the sql statement for report footer if any for a given rept. The
reason is, we're moving away from Access and I need to migrate all the
reports to a new platform, going to report design view to capture it
one by one would be most undesirable. Thanks though.

Nov 13 '05 #3
NickName wrote:
Well, I guess we miscommunicated. I'm trying to figure out a way to
get the sql statement for report footer if any for a given rept. The
reason is, we're moving away from Access and I need to migrate all the
reports to a new platform, going to report design view to capture it
one by one would be most undesirable. Thanks though.


Report footers don't have a SQL statement of their own. You could try to
determine the SQL being generated from a textbox with a sum() in it, if
the report's recordsource is a table or query it would be:

"Select " & Mid(Textbox,2) & " from " & rpt.Recordsource

However, it gets more complicated when you apply filters to the report
or if the report is based on a SQL statement.
Nov 13 '05 #4
Good point. It seems that my attempt or other similar attempt may not
be very productive overall. Thanks.

Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Darin | last post by:
I have a report that sub-totals on a group, then grand-totals at the report footer. If there's only one group, the sub-total and grand total are redundant, so I only want to show one of them. I...
6
by: tshad | last post by:
I need to get to a status label I have on my footer section of my datalist. There is no event happening that would go to the footer. I am just doing some processing and want to update the label...
2
by: LilBuh | last post by:
hi there :) i ve been looking for some time a way to print an html file from vb.net i came up with this code for printing and removing the header and footer from IE then once the printing is done...
0
by: LilBuh | last post by:
Hello :) this is a repost... i ve been looking for a way since last week ... i have a template html file that i modify from my code... i need to print this file without IE's Header and Footer or...
5
by: Stan R. | last post by:
Greetings. I have a couple of questions concerning CSS layouts, as apposed to the old <tablemethod for creating layouts . Even after spending the last few days searching all over Google Groups, I...
7
by: Big Moxy | last post by:
site - http://projects.zanalysts.com/hearingaids1000/default.aspx css - http://projects.zanalysts.com/hearingaids1000/css/styles.css js -...
2
by: dmorand | last post by:
I'm trying to figure out how to use coldfusion templates. I thought I could setup a template and define all the variables I need and the template page would inherit the values from the declaration. ...
11
by: Michael7 | last post by:
Hi everyone, Me again, been a while since I've been here, but I'm back again needing help with a simple thing. I've searched for help on creating a footer, but all the help I've found, was...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.