Search results

  1. S

    copy current database

    I need to make a copy of my current database to a certain location that can be changed. For this I use a piece of code that works very well in full access but gives a fatal error when running in runtime. After investigating the case, I came to the conclusion that the error occurs when the...
  2. S

    weird behaviour of calculated fields

    I have created a report that displays with some delay the results of it's calculated fields. It's about 15-20 seconds delay that I assumed was due to too much computing effort. I thought it was normal because, during this time, simple arithmetic operations were performed with about 20,000...
  3. S

    access report on matrix printer

    I am trying to print a short access report on Epson LX-300+II and I have two problems: 1)the report begins to print with 15 seconds delay 2)I can't choose the font I need, respectively Draft Condensed, because it don't show up in my Text Box Property Sheet After some investigation, I have come...
  4. S

    numbering report rows over nested groups

    Hi all, I have a report, grouped by day then by some ID. If I use a textbox with ControlSource=1 and RunningSum OverGroup/OverAll I have the results shown below, different from what I need (restart after each day). Any suggestions ? ex...
  5. S

    I need to know at list if this is possible

    I need to view a report between two dates and using parameters in my query does not work because I have a running sum. Ex.: start value=100; total for day1 =30; end of day1 =100+30; total for day2 = 17; end of day2 =130+17; total for day3=2; end of day3=147+2 etc. Obviously, end of day3 is...
  6. S

    How to "jump" (select/setfocus) to a specific record in a long report

    I have a report which contains all data within a month, grouped by days. The report is embedded in a form which contain a textbox. I need to be able "scroll" the report to a specific date, which I select/enter in the textbox. I have tried different methods like GoToRecord, FindRecord, SetFilter...
  7. S

    problem with columns and subreport

    I have set a report to print across then down some columns whose content come from a subreport. When the number of rows in subreport is under 30 (which is the maximum allowed by the size of the paper), the columns are printing as expected but, when is upper, the column "jump" to the next page...
  8. S

    need text in footer stay in place when detail section height is variable

    Hello (again), As shown in title, I have a report with some text in footer, which is moved down when I add rows in detail section. I need help to hold in place the footer text. I don't know, maybe some vba code to compensate the rows in detail section? (I don't think is relevant but I add that...
  9. S

    modify report layout runtime version

    Hello, Is it possible to move (slightly) some textboxes on a report, to match a preprinted document, if my database run in runtime version? I need to do that from time to time, when the preprinted document is not "perfect". I know that runtime version doesn't have any design capability, so users...
Top Bottom