| Thread | Last Post | Replies |
|
| Printing current form data | 10 Dec 2007 11:30 GMT | 1 |
I want to output the current form data to a report and print out that page only. However, I couldn't achieve it with macro as all the records are outputted. How am I able to print out just the current record ?
|
| Using results of DLookup in report | 10 Dec 2007 10:04 GMT | 6 |
I have a very simple report where I use DLookup to find the value of a field (tax rate) and then I want to use this field to 'create' another field - =Sum([Donation]*(1+[CurrTaxRate])) wher CurrTaxRate is the DLookup field. However, it does not look like Access allows this. ...
|
| Showing ID number not required text | 10 Dec 2007 05:13 GMT | 1 |
I have created a report with data grouped by employee. When I look at the report it has the ID number of the employee instead of the name. How do I get it to show the name like it does on the form? Nikki
|
| Totals of a field after it is sorted | 09 Dec 2007 20:31 GMT | 1 |
Hii Guys I have tried to see if there is already this situation but i have gave up . here is the prob i have . I have a table with a lot of data, i would like to issue a report that will
|
| report totals | 09 Dec 2007 17:14 GMT | 4 |
In a Report Footer, I would like to sum the totals from two fields. The fields are check boxes. I have added a Text Box to the Report. In Properties for the field, I would like to be able to go to Control Source and put in an expression that would work. To get the sum of one ...
|
| How do I force a new page? | 09 Dec 2007 10:03 GMT | 1 |
I have a report that has a large number of controls for each record. Because the amount of data for each record can vary in quantity the report can have part of a record on one page and the rest on another. How do I force a new page for each record?
|
| Pie Charts-Labels | 08 Dec 2007 20:12 GMT | 1 |
I hav a problem with labels on pie charts. It seems that every time I have more than 3 or 4 slices in a pie chart, the slice labels run together or are on top of eachother. Also, they squish together unecessarrily to create very tall (appearing to be 4 or 5 lines tall) labels ...
|
| Using parameters in reports. | 08 Dec 2007 19:49 GMT | 4 |
I have a report that opens three "Enter Parameter Value" windows. The first window prompts the user for the "Area" and the second and third window prompts the user for the "Beginning and End Dates." All of this is working fine, however, if the user leaves the first "Enter ...
|
| textbox content not visible... | 08 Dec 2007 18:36 GMT | 8 |
I use "Createreportcontrol " to set the number of text boxes i need in report template I've created earlier. Then, in preview mode I populate the newly created textboxes by setting the .value property for each of them.
|
| Page breaks across subreports | 08 Dec 2007 17:51 GMT | 1 |
I have a unbound report that contains 7 subreports. Each subreport prints on a new page with the use of page breaks in the main report (between subreports). At times one or more of the subreports may have no data, I can supress printing of the subreport in that case. I have ...
|
| Deleted label freezes application | 08 Dec 2007 17:39 GMT | 2 |
Hello - I'm modifying reports in a stockholder database I built using Access 2003 on an Exchange 2007 network at the bank where I work. Recently (last couple of months) when I add a field from the field list to an existing or new report, I often need to delete the associated ...
|
| Access2007 reports - section-format-events are ignored in preview | 08 Dec 2007 15:40 GMT | 2 |
I want to convert access2000/access2003-databases into Access2007. In the reports I am using the sections_onformat_events. These events are ignored in the reports-preview in Access2007. How can I execute the events?
|
| Text Box formatting Access 2003 | 08 Dec 2007 08:01 GMT | 2 |
I have the following text box in a report. I have it formatted for standard 2 decimal places, but I'm getting many more decimal places displayed. ="Rent Due on " & GetOpeningDate() & ": " & [Rent] How can I format the field [Rent]?
|
| MS Access 2003 Printing Problem | 08 Dec 2007 03:53 GMT | 1 |
Greetings All; I have a chart report that is printing one chart per record. All the charts are the same. The query I use to extract the records is producing 50 records to a pie type chart and when I print I get 50 charts printed.
|
| Using VBA to manipulate Reporting | 07 Dec 2007 23:27 GMT | 5 |
I have a handful of reports that I am trying to manipulate using VBA. Depending on whatever they choose in a "currency" dropdown will determine what data the report will be showing. This is my question. Is there a way through VBA, depending on the value chosen in the pull down ...
|