| Thread | Last Post | Replies |
|
| Keep together all of sub report | 22 Jan 2005 07:47 GMT | 1 |
For reporting grades and comments about students, I use one subreport per subject. This includes a number of text boxes, some containing numerical data, but one containing a textual report. Depending on how much is written, sometime there are three on a page, sometimes two etc. ...
|
| Totals in a subreport | 22 Jan 2005 07:40 GMT | 1 |
I have a Sales Order report showing total sales by product group within customer I have included a subreport in the report footer section in which I show the overall total for each product group as well as a total for the report.
|
| Filling a Text Box on a Report | 21 Jan 2005 23:54 GMT | 3 |
I have a text box on a report that I have to fill with a specific row in a table. I tried making this control source statement: = [TempAverage]![Average] where [TempAverage]![Month] = 10 And
|
| Combox ID In Report - need value instead of ID | 21 Jan 2005 23:41 GMT | 4 |
I have a Requirements Table [tblRequirements] which lists the many requirements needed to qualify a potential insurance purchaser. Such things has he had his exam, did he have an EKG, etc. I set up a table to be used as a lookup that lists the potential status in meeting each ...
|
| How do I get the lines in an Access report to copy over when I me. | 21 Jan 2005 23:34 GMT | 1 |
How do I get the lines in an Access report to copy over to the Word file when I do a merge with Word?
|
| Blank lines in report | 21 Jan 2005 23:33 GMT | 2 |
I have the following expression in a memo field. The problem is, when some of the fields are null, the form prints with blank lines between each expression. I've tried using the can shrink property, but it's not working. What am I doing wrong?
|
| Date Groupings | 21 Jan 2005 22:23 GMT | 3 |
I'm trying to prepare an annual activity report for each of our partner's capital accounts. The field names are [partner name],[activity date], [units] and [$ investment]. I have a query that pulls the partner name & address info from one table and the activity info from another ...
|
| Value from compbo box on report | 21 Jan 2005 21:33 GMT | 3 |
I have a report that pulls most of it's data from forms. I have 3 combo boxes on a form where users select an item. When I go to create the report, the report pulls the ID number from each combo box instead of the text value the user selected. How can I change it so the report ...
|
| Blank Page Prints Before Group | 21 Jan 2005 20:37 GMT | 4 |
I have a report where I want to keep each group together on a page where possible. If I set the group's Keep Together property to Whole Group (which is how I want it), I get a blank page before each group that extends more than one page by itself. If I set the Keep Together ...
|
| Subreport Based on a Query returns duplicate data | 21 Jan 2005 19:27 GMT | 3 |
Hello, and Thank You in advance for your help. I have a report that is to be used as a packing slip for producted we ship out. The report is made up of a main report that displays order information (Ship To Address, Customers PO Number, Pick Tick Number
|
| Copy Report not printing as PDF correctly (Access 2000) | 21 Jan 2005 19:05 GMT | 3 |
I have a report that I copy (CopyObject acReport) during Runtime so that I can rename it and print/save as PDF (via Distiller). The report has references to sub-reports - and works fine when opening normally. However, when I try to send the 'copy' to print as PDF the fields that ...
|
| Summing unbound controls at several group levels, and grand total | 21 Jan 2005 18:23 GMT | 2 |
I have seen several posts very near to my problem, which is that I am calculating a value in a group footer, that is based on the sum of records for a case#. Once this calculation is performed, I would like to summarize this at the next group level up (Office) but, not based on ...
|
| No data event | 21 Jan 2005 18:15 GMT | 3 |
How do I suppress the 'OpenReport action was canceled' message when I set the cancel = true in the NoData event.
|
| Global find & replace in formulas? | 21 Jan 2005 17:23 GMT | 1 |
I have a report with a number of calculated controls with a DLookUp statement in them. I need to change the name of the table where the DLookUp is doing it "D-Looking Up." Is it possible to do a "find and replace" rather than to manual open each control and manually make the ...
|
| Report Sorting | 21 Jan 2005 17:18 GMT | 2 |
I've read through several threads but still can't figure out my report's sorting delimna. I'm trying to sort first by ascending Date, then by ascending Time. The Date field is sorted nicely, but the Time field seems random. I've set the sort order in the underlying query and ...
|