Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GavinP

    Running sum not coming through into footer

    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.
  2. GavinP

    Running sum not coming through into footer

    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.
  3. GavinP

    Running sum not coming through into footer

    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...
  4. GavinP

    Running sum not coming through into footer

    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...
  5. GavinP

    Running sum not coming through into footer

    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...
  6. GavinP

    Running sum not coming through into footer

    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...
  7. GavinP

    Loop though reports and insert a new object to it

    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...
  8. GavinP

    groupheader.page from pageheader_format

    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...
  9. GavinP

    CreateReportControl Confusion

    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.
  10. GavinP

    CreateReportControl Confusion

    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...
  11. GavinP

    Report is printing multiple pages

    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
  12. GavinP

    Format Graph Data

    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...
  13. GavinP

    Determine number of pages

    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
  14. GavinP

    Determine number of pages

    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...
  15. GavinP

    return function into text box

    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
  16. GavinP

    return function into text box

    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)...
  17. GavinP

    return function into text box

    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...

Part and Inventory Search

Back
Top