| Thread | Last Post | Replies |
|
| 3071 error access reports | 13 Oct 2007 05:21 GMT | 1 |
How can I isolate the expression/calculation that is causing this error?
|
| Averaging last four records | 13 Oct 2007 05:13 GMT | 1 |
I am trying to set up a report which will only lookup the last four records and average the data from only the last four records. Records will be added to every day and the report will be run every day. As records are added the new records becomes one of the four records to ...
|
| printing group header on each page | 12 Oct 2007 23:14 GMT | 2 |
I have a report that is grouped and prints the group header on the first page of each group. There are multiple pages for each group. How can I get the group header to print on each page? Thanks,
|
| Sort order different between reports | 12 Oct 2007 22:31 GMT | 1 |
I think I've found a bug in MS Access reports from Oracle databases. I've searched the knowledge base and did not find any reports of this issue. I have two reports, one that lists without grouping, one with grouping. The sort orders in both reports are the same. When I run these ...
|
| Displaying the actual data that error message is referring to | 12 Oct 2007 20:51 GMT | 1 |
Is there a way to display the actual records that are being imported from excel to access if they continue giving you an error message?
|
| How2:Display data from multiple Records on one line seperated by Commas | 12 Oct 2007 20:41 GMT | 1 |
Here is My Data in [Products] Category Item ======== ========== Fruit Apples
|
| Report/Query not selecting specific records | 12 Oct 2007 19:25 GMT | 6 |
I have a database for tracking miles traveled and fuel purchased in each state. I have a report based on a query to total miles and gallons for each state in a quarter. Last quarter, the report worked perfectly. This quarter, for some reason, it's bringing in all records that ...
|
| Formatting fields on a report | 12 Oct 2007 17:35 GMT | 1 |
I have a report that I need to list totals by month by there account code & sub account. I have a query that generates all the necessary information but I am having a issue converting a field "Check Date" to be the month and then have the associated months listed at the top of the ...
|
| Report Question | 12 Oct 2007 15:28 GMT | 1 |
All, I have a report which is currently sorted by a numerical field, i.e. 1,2,3, & 4, as in a priority ranking. Is anyone aware of an option that will enable me to show only my priority 1,2, & 3s; essentially, excluding the 4s from the
|
| Columns in a main report and subreport | 12 Oct 2007 13:41 GMT | 5 |
I have a report which shows 2 columns in the main report. Then I have a subreport that I show in a grouping footer that is a 1 column subreport, but becuase it's in this main report, the preview shows the subreport as 2 columns. How can I change this when it gets to the ...
|
| Code help required | 12 Oct 2007 09:46 GMT | 5 |
I have been using the following code from Allen Browne to select a random percentage of records on the open event of an unbound report. Private Sub Report_Open(Cancel As Integer) Dim strSql As String
|
| Opening links to image files from inside a report printed to pdf | 12 Oct 2007 09:35 GMT | 1 |
I have printed an Access report to PDF. The report has hyperlinks to external JPG files. When I open the report in a PDF viewer, I can successfully go to the linked files if I use Firefox as my default browser, but not if I use IE as my
|
| Run Time Error 2501 "The report action was cancel" | 12 Oct 2007 07:16 GMT | 6 |
I have a access database with some reports. All reports are working fine except one. When I click Priview or Print window I get the error "Report Action was canceled" and the error number is 2501. I try to ignore the error but report does not open. Any help in this regard.
|
| Final totals include deleted info | 12 Oct 2007 06:28 GMT | 7 |
I've successfully configured my report so that it selectively (based on data content) deletes various sections by performing a Cancel = True in the OnFormat event for each section, as needed. In some cases, the detail section is deleted as well ... this is my intended result.
|
| Report Distribution | 12 Oct 2007 06:10 GMT | 1 |
I have a report sorted by physicians and it prints to 600 pages. I need to save the report pdf format individually for each physician so I can e-mail it to them. Is there a way of doing this automaticall without me having to run about 100 separate reports? Any help/suggestion ...
|