| Thread | Last Post | Replies |
|
| How can I get rid of blank pages when generating a report? | 01 Jun 2007 00:26 GMT | 1 |
While generating a report there always seems to be a blank page after every page. I have checked my margins, as well as my page breaks and still I continue to get the blanks.
|
| Trouble with opening reports | 01 Jun 2007 00:26 GMT | 7 |
I have created a mdb on one machine in which I am able to open the reports. When I move the file over to another machine I am not able to open the reports. I am also not able to design the reports. Any thoughts on what is up?
|
| Address box with IIf Statement | 01 Jun 2007 00:26 GMT | 7 |
I'm looking for help with this statement. I have created an address text box with the following control. If any of the lines are null then the line will not display and go onto the next. It's working fine except the line with city, state and zip.
|
| reports to powerpoint | 31 May 2007 21:54 GMT | 3 |
I have developed, tested and used a MS Access 2003 database. Now I would like to display some of the reports as part of a PowerPoint presentation. My question is how do I get the report results from Access to the PowerPoint slides while maintaining the report format? Thanks for ...
|
| Nested IIf | 31 May 2007 21:52 GMT | 2 |
I have this expression which works well in generating Committee Member tenure/histories: =IIf([EXPR4]=2222,[Description] & ", " & [TITLE] & "," & Left([EXPR2],5) & " - " & "present", [Description] & ", " & [TITLE] & "," & Left([EXPR2],5) & "
|
| Counting Check Boxes | 31 May 2007 21:38 GMT | 4 |
In database #1 report I use the following expression to count checked check boxes and it works. =Sum([Attachment Pre-test Completed Child1]+[Attachment Pre-test Completed Child2]+[Attachment Pre-test Completed Child3]+[Attachment Pre-test Completed
|
| Display a calculated number as text or words? | 31 May 2007 21:35 GMT | 1 |
I have a query that calculates the number of days to complete a job. In other words it subtracts end date from start date. In a report I want to display the number of days in words. 1 = one, 2 = two, and so forth.
|
| input form field on a report - qoh | 31 May 2007 20:48 GMT | 5 |
I have 2 forms one for receiving items and the other for issuing items. I have calculated stock in qty and stock out qty and the QOH on the fly on the form. I want the QOH of each item in the end of the day as a report.
|
| Need help with If statement | 31 May 2007 20:37 GMT | 4 |
I added a text box, txtRetain, to a report. I also added the following code to the report's Open event: Private Sub Report_Open(Cancel As Integer) If Forms!frmMainScreen!frmProjectSubFormTab!chkRetain = True Then
|
| Hide data while grouping in a report | 31 May 2007 19:33 GMT | 3 |
I have Access 2003. I've written a report which groups the records by MATTERNO similar to the following: Group 1 Title P91506US01 Process for Alcohol
|
| Grand totals with limited group contribution to total | 31 May 2007 19:32 GMT | 2 |
I have a report that lists different companies with several records per company. I need a total of all records in the report, but each company can have only a maximum of two records count towards the grand total at the end. E.g.
|
| Page footer question | 31 May 2007 18:34 GMT | 3 |
I am wondering if it is possible to turn off the page footer on the last page of a report. The report in question is used as a packing slip/delivery ticket. On each page, in the report footer, I have a blank for the Receiver's initials. At
|
| Printing mailing labels with multiple recipient name records associated with a single address | 31 May 2007 15:14 GMT | 5 |
I have been browsing this, and other Access groups, as well as some of the Microsoft KB articles, and while I find posts decribing similar objectives to mine, can't seem to find anything that specifically shows me how to solve my problem. I posted this topic, by mistake
|
| Sub Report Totals | 31 May 2007 14:31 GMT | 5 |
I have a report that when added to the main report as a sub report, I get one extra count in my total. So the report totals correctly by itself but when used as a sub report I get one extra count.
|
| do not print zero records | 31 May 2007 09:48 GMT | 1 |
how can i create my report without displaying all the zero items in my inventory list
|