Search results for query: *

Unfortunately, i've tried that, and it doesn't work. Well, the running sum bit works fine, but you can't get the value from that footer into the other one. Damned annoying.

yes. That works. However, I need the value in the depot footer. AAARGGGH. I'll go back to the data source, and perform a calculation there. I can't see a way of getting the value into the right footer otherwise. Thanks for your help.

OK, LAMEID. - The running sum works. If I have it visible, it works perfectly if it is in the header. If the fields are moved to the detail, then the rest of the fields from the query are fine, but the running sum does not work correctly. either way, it is impossible to sum the running sum...

OK, I don't have the grouping wrong, i've just checked. Worth a try though. I'll try again, as people don't seem to understand what I am getting at. I have a field, which has an if statement in it which simply sets to either 1 or 0. (call it what you will). This field is in a header. There are...

Thanks for the reply Duane but it doesn't answer my question. The field text91 will be called something meaningful, once i get it to work. I tend not to name anything unless it works, as it gets tedious naming fields, then deleting them! Regardless of whatever i call the field, or if I do it...

Hi, I'm tearing my hair out with this problem, yet i know its solvable, because I've done similar things before but regardless of what i try it doesn't work. I've a report based on a table. The report has two headers, Depot then rank. There are two footers, rank, then depot. In the rank...

This is what i've done in the past. Dim rpt As AccessObject Dim ctlNewLine As Control Dim obj As Control For Each rpt In CurrentProject.AllReports Set obj = CreateReportControl(rpt.Name, actextbox, [section], , "", [left],[top], [width],[height]) obj.controlsource=[name] DoCmd.Close...

Is it possible to get the groupheader page from the format sub of the pageheader. I have a report, with several subreports, one of which contains several pages of data. On the main page, I've put into the pageheader the column headers of the sub report, which shouldn't be shown on the first...

Nope, that goes into FC. [sad] However, it works fine with 5 instead of 10. Don't ask me why, but it does. Cheers, if it wasn't for you pointing me in that direction, i would have never spotted it.

Hi. I've got a need to add via vba a line the width of each report in my db. I know the groupfooter I want to put it in, and have been using the following command to insert the line. Set ctlNewLine = CreateReportControl(rpt.Name, acLine, acGroupLevel1Footer, "", "", 0, 0, 9000) The only...

Hi. Having just had the same problem, i believe i have resolved it. Finally I can give someone else an answer! You need to move the graph from the detail into your group header. Once there, the duplicate graphs should disappear, at least they did for me. Gavin

Hi all, i'm sure there is a simple explanation for this, but i can't find it. I have a line graph on a report, which is working fine, but i want to format the data so that it has no decimal places and , separator. In excel that's easy, but in access it doesn't seem to want to know. I've changed...

lupins. Thanks. I hadn't thought of that as a solution. Only problem is that I get a blank page with all my labels on, but no data. Is there a way around that as well? Many thanks. Gavin

I have a report which contains all the branches within the company. However, when printing them, we filter for the individual branch. Most of the branch reports are two pages long, but some of the newer branches only generate data for one page. I need to know how many pages are being printed to...

Thanks both. I've sorted the problem similarly to dhookums suggestion, by changing the query that the report is based on, and using mth1, mth2 etc. Cheers, Gavin

Thanks, but I am getting an invalid use of Me message. The function is as below: Function ReportsFields(month As Integer) As String Dim strComplete As String Dim strField As String Dim intfigure As Integer If month < 0 Then intfigure = month + 12 strField = "LY " & MonthName(intfigure, True)...

Hi all, urgent problem. I've got a report which shows the last 12 months sales figures, which I'm now automating so that manual update of the field names isn't needed. My problem is that I have a function which will return a string with the formula I want as the text box source, but when you...