| Thread | Last Post | Replies |
|
| New Row | 15 Oct 2004 15:22 GMT | 4 |
I have a report with 20 text boxes in a column. txb_name1, txb_name2..etc. There is code that loops thru a recordset and populates the text boxes. What I would like to know is: Can I use just 1 textbox on the report and add in a new row after the code
|
| How to add the value of a textbox into a Title of report | 15 Oct 2004 12:54 GMT | 1 |
I have a form ("myform") with a textbox ("txtTitle") and command button ("cmdOK"). Let's say that in the text box is written "Hello world!". When I click on "OK" I get a report (rptCalculations). I want at the top of the report to have a label (lblTitle) or textbox (txtitle) for ...
|
| Photo shows as icon in report | 15 Oct 2004 10:33 GMT | 3 |
The linked photos.jpg were displaying in my report pages with no problem in Access for Win95, v7.00. However since converting the *.mdb files to Access 2002 only a icon of the linked file displays in the report page. As a side note when viewing (but can't edit) the Win95/v7.00 files ...
|
| Using the DateDiff function | 15 Oct 2004 04:55 GMT | 1 |
I am calculating time duration. I used the DateDiff function to get the amount of time but I am having trouble adding or summing the result. What canI do?
|
| Print from custom toolbar | 15 Oct 2004 03:53 GMT | 1 |
I've created a custom toolbar that opens with my reports (Access 97). The only print button available sends the report to the printer without prompting for any user input eg: Number of copies, which printer etc... Can anyone suggest a way to have this toolbar show a button that ...
|
| Need variable-sized box at end of page before page footer | 15 Oct 2004 01:23 GMT | 5 |
I've got an Access report that prints one, two, or three groups on a page (using keep together). When the page breaks, there is usually some blank space at the bottom of the page before the page footer. I would like to draw a box to fill that space. Is there a way to do
|
| Subreport causes Main Report to Repeat | 15 Oct 2004 01:11 GMT | 1 |
I have a main report with several subreports in it. One of the subreports may return several entries. When it does, the report comes out fine. However, if there are 4 returns, for instance, it causes the entire report to be 4 times the length... that is, the entire report repeats ...
|
| Totals on Report | 15 Oct 2004 01:09 GMT | 1 |
I have a report grouped like this: Level 1: Agent Level 2: Location Then I have data by date for 3 locations:
|
| How can I bind textbox to query field regardless of its name? | 15 Oct 2004 00:36 GMT | 2 |
I have a report I want to use for various queries. (the OpenQuery "report" just doesn't cut it). I'm having trouble binding the vaious text boxes to the vaious fields of the underlying query. I tried to set the ControlSource of the text boxes in VB, but... I
|
| Altering Bold within a text string | 15 Oct 2004 00:32 GMT | 2 |
Is it possible to alter one word within a text box on a report to be bold? For example, I'd like a string to appear as: See Joe Run Thanks in advance
|
| Skipping a field when Enter is pressed | 15 Oct 2004 00:28 GMT | 1 |
I've got a form that I enter two values into. If I press Enter after the second value It goes to a read only field. What I would like to do is have it skip this field and go directly to the subform. Any suggestons?
|
| If logic | 14 Oct 2004 22:56 GMT | 2 |
i have a field on a report that in most cases that data is 0 (this is a numeric field) i dont want to see 0 on my report, i only want to see the number if it is greater than 0 is there some if logic i can use in the report?
|
| Calculate percentages for groups and subgroups | 14 Oct 2004 22:48 GMT | 1 |
I am using Access 2002. I have a report that contains two groupings and I am having the report sum the number of items in the both the major group and the subgroups within the major group. I would like the report to calculate and show for each subgroup the percentage that is ...
|
| Subreport Causes Main Report to Repeat | 14 Oct 2004 22:41 GMT | 1 |
I have a main report with several reports in it. One of the subreports may have several returns. The report looks fine, but if there are 4 returns on the subreport (for instance), the main report repeats 4 times. And the total page numbers are 4 times the real amount. The other ...
|
| Report header on multiple page report | 14 Oct 2004 22:38 GMT | 2 |
I have a fairly simple report that is multiple pages long. I would like the report header to print at the top of each of the pages and can't seem to find out to do that. Any assistance is appreciated.
|