| Thread | Last Post | Replies |
|
| How do I get rid of empty space on my report? | 31 May 2006 21:36 GMT | 7 |
This is just a simple report.....use a query to list customer information. Each customer has 3 or 4 lines. There's a title in the page hdr area. There's 4 lines of customer info in the detail area with a straight line under it so the customers will be separated. The line is ...
|
| I can't print access report, but can preview it | 31 May 2006 19:58 GMT | 2 |
I created a report using the report wizard in MS Access 2000. I can preview the report. When i try to print it, it just prints out blank pages. The last page, gives an error message, "PCL XL error Warning: IllegalMediaSource". I was able to pirnt out the query results, ...
|
| ACCESS | 31 May 2006 19:07 GMT | 1 |
I have created a report to show my purchase orders by supplier by delivery date (oldest date first), is it possible for Access to "draw a line" under dates that are older than todays date, but still show the rest of the future orders that are due.
|
| Subject: Report - If null set the text boxes visible to false | 31 May 2006 19:04 GMT | 2 |
I have a report which displays the hours worked on a project or category. It gets the information from a time card table which has the field names Category Name Text Project Name Text
|
| Any way to control the size by which a text field on a report grows/shrinks? | 31 May 2006 19:02 GMT | 1 |
I have an MS access report with multiple fields that grow and shrink. The report has a backgroun with which I would like to the keep the text formatted. Is there a way to control the size by which a text field can grow/shrink?
|
| Count value in combo box if = to ... | 31 May 2006 16:33 GMT | 2 |
I have a report I am trying to run for a pet shelter. I have a combo box for type of pet (i.e. cat, dog, reptile) in the report I need to be able to count how many cats, how many dogs, and how many reptiles. However I have not found a way to do this. I tried =countif("Cat") ...
|
| Subreport filter - The setting you entered isn't valid for this pr | 31 May 2006 16:27 GMT | 4 |
I have a Report in Access 2003 which has a subreport. In the report I want to dynamically determine a filter for the subreport. When setting the filter and the FilterOn properties, I get the error above. Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
|
| Report design | 31 May 2006 15:58 GMT | 1 |
I have a number of reports which have been set to landscape but lately for some unknown reason, whenever I preview them they come up in potrait and subsequently print as such. What I have been doing is to page setup after previewing the reports and
|
| Can't Enter Special Characters | 31 May 2006 15:49 GMT | 5 |
I am trying to send "<esc>p" as part of a report to open a Cash Drawer attached to a POS Docket Printer. I know I should be able to enter the <esc> character by holding down the <Alt> Key and typing "027", but whenever I try this within the VBA editor so that I can assign it as ...
|
| sum a field with multiple criteria | 31 May 2006 15:44 GMT | 5 |
Obviously I am trying to do this in a report. I am trying to get a total # of times where the following occurance happens. [pres] = 'inc' Or 'com' Or 'int' I tried the following and it worked:
|
| User wants KB Shortcut to change page | 31 May 2006 12:22 GMT | 7 |
One of my users would like to know whether there is a keyboard shortcut to go to the next page (or first or last page) when viewing a report in Print Preview. Seems like a reasonable request, as I prefer to not use the mouse myself, but I couldn't turn anything up in menus or ...
|
| Portrait and Landscape on 1 Report | 31 May 2006 06:09 GMT | 1 |
I have a report that uses a bunch of subreports to compile. I need to find a way to print the report as Portrait, and then print off 1 subreport as landscape. How can I do this? I have found other posts that mention the Orientation and PrtDevMode properties, but am unsure how ...
|
| Multicolumn report with vertical labels | 31 May 2006 05:22 GMT | 1 |
I've got a 4-column report that must have vertical labels on the left side of the report in between the header and footer of the report on each page. I've got group labels for labels of the text boxes which display the data from my query. It looks something like this:
|
| Multi-column subreports - down then across | 31 May 2006 00:29 GMT | 1 |
I'm trying to create a subreport that lists the entries down and then across for a few reasons. The primary reason is I want the items to be listed alphabetically going down and then across (to match a previously made paper form). Also, the space is limited vertically that the ...
|
| - and + values are incorrect | 30 May 2006 21:33 GMT | 5 |
The following function: =Abs(Sum(([pres]="scr")*[gain])) Produces a positive result all the time, even if the answer should be negative.
|