changing displayed data on the fly in the detail section
Tue, 25 Nov 2008 08:25:32 +0000
I have a report with many columns based on a large crosstab that returns
in its cells either single letters or the strings "Dist", Merit" or
"Pass".
The textboxes in the detail are called text1, text2 etc and I
dynamically position, hide and format them in the Onformat event.
As the columns are small I w ...
|
Set paper size to 220x110
Tue, 25 Nov 2008 19:53:11 +1300
How do I set the paper custom size to 220x110. I want to use DL but the size
is wrong (110x220). I can do this easily in Word but not access.
Thanks,
J.
...
|
Question about wording and position overall total not correct
Mon, 24 Nov 2008 19:26:10 -0800
Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.
I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, e ...
|
top border of a text box
Mon, 24 Nov 2008 16:32:49 -0800 (PST)
How do I set the top border of a text box? ...
|
Totals in report based on query with subquery (as tought by A.Brow
Mon, 24 Nov 2008 13:25:12 -0800
I'm new to Access, so maybe my "solutions" are barbarian, but this is what
I've got.
I've found that Access has no straightforward way of dealing with relative
calculations between different records (values) of the same field. In my case
I needed to query PortfolioValue of Period(n) and compare it to
Portfo ...
|
Grouping w/ Graphs in Rpts
Mon, 24 Nov 2008 13:10:11 -0800
Iâ??ll explain the problem as best as I can.
I have a report based on a query. The query contains the following data:
Company_Name (Demo, Inc.)
MonthDate (01/2008)
ItemDescr (Copy and Printing)
Expected (125,000)
Actual (120,000)
The report is grouped by Company_Name, then ItemDescr, then sorted by ...
|
Graphing an "Other" section in a Pie Graph
Mon, 24 Nov 2008 20:54:19 GMT
I created a pie graph that contains information from a query in Access 2003.
The graph shows the percentage of the occurrences of items in the query.
The problem Iâ??m having is the graph becomes extremely cluttered when there
are many items in the graph. I would like to streamline my graph to only
include it ...
|
|
|
Export Chart from Report
Mon, 24 Nov 2008 15:40:58 -0500
I have read on a few web pages on how to export a PivotChart to Excel and
even save it as a file. However, I can't get it to work. I have this code
below that supposedly works.
Private Sub Form_Activate()
Dim frm As Access.Form 'your form
Dim FileName As String 'a local variable to contain the use ...
|
How to email only one page of a multi-page report
Mon, 24 Nov 2008 20:00:37 GMT
I am trying to email only one page of a report. I know the code to open a
report to a specific record.
Private Sub cmdPreviewReport_Click()
On Error GoTo Err_cmdPreviewReport_Click
Dim stDocName As String
Dim lngRecNum As Long
lngRecNum = Me![ID]
stDocName = "rptStreetClosure" ...
|
Counting only records that have values > 1
Mon, 24 Nov 2008 10:01:01 -0800
I am trying to count records from two fields that only have a value greater
than 0. Only one of these fields is used per day so when it is not used, the
value is defaulted to 0. I need to show what days were in use in regards to
entering a begin date and end date. Can someone help me please. I don't work
wit ...
|
