| Thread | Last Post | Replies |
|
| MOD Function or how to convert total minutes to hours and minutes | 22 Dec 2004 08:08 GMT | 1 |
simple question.. maybe i have a total number of minutes and i want to convert to hours and minutes.. example 125 total minutes i want it to be 2 hours and 5 minutes so i figured out how to change
|
| Setting filter prop. of subreport in detail | 22 Dec 2004 08:07 GMT | 4 |
I have a report with a subreport in its detail section. I pass the strings for the filter for the main report and the subreport to the Open event code of the main report. I wanted to set the filter of the subreport from there with code like:
|
| Print Access 97 Mailing Labels in the "middle" of a sheet of label | 22 Dec 2004 04:03 GMT | 7 |
How do I start printing mailing labels in the "middle" of a sheet of Avery labels for an Ink Jet printer?
|
| Code in Detail_Format of report causes Access 2002 to crash | 22 Dec 2004 04:03 GMT | 4 |
I have a simple 'if' statement in the Detail_Format subroutine of an Access 2002 report: If Me.EXPIRED_DT < Date Then With Me.Check14
|
| Don't Understand "Public" Variables | 22 Dec 2004 03:04 GMT | 1 |
I am confused about the meaning of "Public" variable. My main report declares "Public strStaffGrp As String" at the top of the module. My subreport needs to compare strStaffGrp to a Detail field during formatting, but I can't see strStaffGrp at that point. But the footer of ...
|
| #Error in a report | 22 Dec 2004 00:39 GMT | 1 |
I have used the following statements in a report: =IIf("#Error",0,[Field 1]) =IIf([Field 1]="#Error",0,[Field 1]) =nz([field 1], 0)
|
| Duplicate Pages in Summary Report | 22 Dec 2004 00:13 GMT | 2 |
I seem to be having a similar problem that others are experiencing but the responses on Duplicate Pages in reports are not correcting my problem. In my report, all of the text boxes summarize (either by count or sum) fields in the underlying query. Everything fits on one page ...
|
| cut chart | 21 Dec 2004 21:31 GMT | 1 |
After installing Windows XP instead of 2000, I've got a cut chart in a report. The chart is based on days per months. Now, it shows only 26 or 27 days instead of 30 or 31. (All forms are bigger now and don't match with a screen).
|
| Passing values to a query | 21 Dec 2004 20:35 GMT | 2 |
I'm trying to pass a value from the field of a form to a popup window for a query when running a report. The way I have it set up now is the user goes into a form and selects from a set of combo boxes that keep narrowing their possibilities. Once the users get to where they ...
|
| how to calculate a total | 21 Dec 2004 20:33 GMT | 1 |
in the footer of my report i made a calculated textbox =IIf([tipotarea]="1",Sum([points])) this works but shows the total of all points. What I want is only the total of point where tipotarea is 1 e.g.
|
| Event Programming - on print | 21 Dec 2004 19:25 GMT | 4 |
I have a complex report which contains a number of calculations. Many of which are calculated in vba then displayed in an unbound text box. The results are totaled from group footer and displayed in the report footer. I have the problem that the results are shown correctly on ...
|
| Summing an unbound Textbox | 21 Dec 2004 19:14 GMT | 1 |
I have unbound textboxes in the detail section of my report that hold values related to checkboxes for each record. In my report footer I want to do a grand total for the unbound textboxes. I have tried putting =sum([textboxName]) in the control source proptery for the textbox ...
|
| Can I print a list of all reports in a database? If so, how? | 21 Dec 2004 17:23 GMT | 1 |
Can I print a complete listing of all the reports in a database? If so, how do I do it? I tried documenter but I just want a list of all the reports and nothing else. Please advise. Thank You.
|
| Report Header Sum | 21 Dec 2004 17:07 GMT | 3 |
I would like to cum the total of the 1D1's, It has about 6 like this 1D1D, 1D1G Etc. I'm using the following: =Abs(Sum([rctg_stn_id]="1D1*")) and it is not working.
|
| Add a particular record from a table to a report text box | 21 Dec 2004 16:25 GMT | 2 |
I have a report that is generated from a query. The record that I would like to add does not come from the same table and query that generates this report, but from another, seperate table. I ultimately will use this value as a constant in a calculation on the report. I ...
|