| Thread | Last Post | Replies |
|
| Conditional Field Display | 17 Oct 2004 21:41 GMT | 2 |
I have a report that is opened from a form. The form passes a value to the report that specifies whether a certain field should or should not be displayed in the reoprt. If the user selects "full" on the form, the value 1 (true) is passed and the field should be
|
| Calucating Rpt/SubRpt | 17 Oct 2004 16:17 GMT | 2 |
I have a report and an subrpt and would like to calculate a total on the report using a field from the report and a field from the subreport. Below is the calculation and whenever I try to run the report, I get a "Enter Parameter Value". I've tried also pulling the "idamt" from ...
|
| Filename & Path in Footer? | 17 Oct 2004 16:00 GMT | 4 |
Hi, Is there a way to put the Filename & Path in the footer of a report? I know how to do this in Excel using =CELL("filename") , but obviously it does not work in Access, is there such a thing in Access? TIA, CD.
|
| hiding blank field in report | 17 Oct 2004 11:16 GMT | 3 |
I have a table with 12 fields.Half of these fields are filled only in due course of time. Then I wanted a report so I created a querry with all the fields from the table. Then I created a report linked with querry. Now, the report both filled and the unfilled fields. I wanted a ...
|
| Labels disappearing | 17 Oct 2004 00:09 GMT | 5 |
I have a report with labels down the left hand side of the first page. The rest of the report is a subreport which the labels line up to, simple enough. However when I go to the second page all the labels have disappeared, dont know why, any help is appreciated
|
| Is there any way to send a report via e-mail using a PDF format | 16 Oct 2004 22:07 GMT | 3 |
I created a database that produces a report that needs to be emailed. I currently have it set up to send an email attachment in a snapshot format. However, many of the recipients don't have snapshot viewer and don't want to
|
| Null values | 16 Oct 2004 17:29 GMT | 3 |
I'm having trouble summing and formatting fields that contain Null values and then formatting those controls on the report. I'm using currency formatting on the underlying table. I created a field in the report query using an NZ function i.e. Budget Revised: NZ([curBudgetRevised]) ...
|
| ACC: Cannot Use SQL Pass-Through Command for Subreport | 16 Oct 2004 01:30 GMT | 1 |
I cannot place a subreport in a report when the subreport is based on a SQL server pass-through query. This is not a crosstab query, but a pass-through.
|
| printing dates on a timesheet | 16 Oct 2004 01:09 GMT | 2 |
We are attempting to integrate our company's timesheets into Access 2002, where we have a worker table with the names, emp numbers etc. The goal is to be able to click a button, and the timesheets will print out with the name, id number, department, pay period dates already on ...
|
| Printing a range of dates on a timesheet | 16 Oct 2004 00:57 GMT | 2 |
We are attempting to integrate our company's timesheets into Access 2002, where we have a worker table with the names, emp numbers etc. The goal is to be able to click a button, and the timesheets will print out with the name, id number, department, pay period dates already on ...
|
| Do not print Page header with a section header | 15 Oct 2004 23:04 GMT | 1 |
I have a report with a group header which is set to force a new page before the section. I need to have the Page Header not print on pages in which the group header is printed. Is there a way to do this? Thanks
|
| Transferring sum from subreport to main report | 15 Oct 2004 17:17 GMT | 2 |
My report includes a subreport named "LabSectionSubreport" with a control named "PTWageSum" that totals a wage value with the following control source: =Sum(Nz([PTWage],0)) I've added a control to the main report to capture the "PTWageSum" value
|
| rtf in reports | 15 Oct 2004 16:56 GMT | 3 |
I am trying to use an RTF control in a report so I can display a memo field that contains RTF encoded text. I can't get it to work. I keep getting error 2763, "Property cannot be set". Why is this a problem, and is there a workaround?
|
| Registry settings for Snapshot reports in runtime | 15 Oct 2004 16:25 GMT | 1 |
In version 97 of Access there were settings that could be made in the registry under the runtime profile which looked like the following: [HKEY_LOCAL_MACHINE\SOFTWARE\Company Name\SampleLog\1.2\Profiles\SampleLog\Report Formats]
|
| Resize Textbox Controls At Runtime! | 15 Oct 2004 15:39 GMT | 2 |
I have three textbox controls in the detail section of my report. They are fed data through a query that changes the data displayed depending on criteria I have set. I want to make the height of the text boxes the same so that the formatting of the report is kept nice and tidy. ...
|