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: *

  • Users: GavinP
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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