|
Access Report but now show only random records
I inhereted an MsAccess Report. It shows data by group. The user now wants
(for auditing purposes) a random sampling (20% of records) from each group.
So, if group 1 had 10 rows on the original Access report, he wants to see the
same report but only showing 2 of those records, selected at random. I
should do this for all groups on the original report.
Any ideas on how to proceed with s...
|
15 |
12/4/2008 4:01:31 PM |
|
|
subtotal of a calculated field
I have setup a sum calculation for the number of students that use a study
room in the footer for each group. (grouped by room)
Next I would like to have a grand total of student for all rooms at the end
of the report. Is there a way to subtotal the calculated text fields I setup
for each room?
Thanks
--
Jacqueline...
|
6 |
12/4/2008 4:00:01 PM |
|
|
Need to skip open OnNoData
Hi everyone! Using A02 on XP. I have a print form that opens a number of
reports (letters, forms, etc.). Sometimes I only have data that opens the
forms and not the letter. I've used the OnNoData event to display a message
"There is no data for the letter" and there is also the fun little "Open
Report Action Cancelled" dialog box that also appears when you click OK on
the OnNoData mes...
|
2 |
12/4/2008 2:19:41 PM |
|
|
Calculation in SubForm
I am trying to sum up a series of control boxes in a subform and place the
sum in the footer.
In the subform, I have two separate fields: Units and UnitPrice. These are
also the same fields in the table tblQuoteDetails. I am trying to multiply
Units by UnitPrice and then sum them within the footer. To do this, I have
created a new control within the subform (not in the form footer) e...
|
2 |
12/4/2008 5:55:01 AM |
|
|
Access 2003 Label Report - Text Position On Label Question
Hi
I am using an A4 page of 8 labels, measuring 99.1mm x 67.7mm.
I created a label report using the label report wizard.
When I view the label report the label text is left justified and positioned
top left of the label. (In the corner)
Question
How can I position the label text left justified and centrally on the label?...
|
13 |
12/4/2008 3:18:25 AM |
|
|
Landscape Rollup Report
I am trying to replicate a dashboard report in landscape format within
Access. The detailed measures (1.a.1...1.a.2...etc.) including some details
(incl. YTD sum of results) are on the left. Measures roll up to CMCAs
(1.a...1.b... etc.) which come next when moving right. CMCAs need to sum
particular values from the underlying measures. Finally, there are DOFPs (no
number scheme) whic...
|
1 |
12/4/2008 12:12:01 AM |
|
|
Font Size Smaller Than 8.
Hi,
I have an ms access report with graph that use font Arial size 6 and 7. The
report looks ok on screen however, when print number 1 always too close to
the right (kerning problem). I have been searching for a new font with size 6
and 7 with no luck. When I use other fonts the graph will just default back
to Arial if is less than 8.
I also would like to convert this document to pdf...
|
1 |
12/4/2008 12:10:01 AM |
|
|
Graphics
I am trying to use the export feature in Access to send a quote as
attachment. The attachment needs to be RTF. So how can I get my logo in the
Quote as RTF doesnt support graphics? There must be a workaround on this...or
at least I hope....
|
2 |
12/3/2008 9:48:16 PM |
|
|
Remove extra space in a Report
After I set the Hide Duplicates property to yes for text boxes in the Detail
section there is a lot of space between records. How do I eliminate the space?...
|
1 |
12/3/2008 7:44:47 PM |
|
|
Averaging in a Report
I have a report created that lists one agent's data per page. Each agent
sees their data (calls, time, etc.) plus they also see their team's average.
If an agent has all 0's in their data fields (they were on vacation during
the timeframe of the report) is there a way for Access to not include those
zeros in the average?
--
Message posted via AccessMonster.com
http://www.accessmonster.c...
|
3 |
12/3/2008 3:14:15 PM |
|
|
Displaying Database change date in report heading
Hi,
How do I capture and display the change date of the mdb file in the heading
of a report.
I'm using Access 2003.
Thanks,
Marv
...
|
10 |
12/3/2008 3:11:04 PM |
|
|
Count a specific value.
Hi all,
I’m trying to make a text box return a “count†from another field that
contains a specific value. I want the text box to give me a count of all the
records that contain “2320†but it gives me the count for all the values
instead.
My Expression builder code is =Count([DepPlusSize]="2320")
Can anyone tell me what is wrong with my code?
Thanks,
Cage...
|
8 |
12/3/2008 2:47:41 PM |
|
|
Subreport page header
I created a subreport within a report. I need a page header within the
subreport since the data does not fit on one page. Although I set up the
page header, it does not print on the report....
|
2 |
12/3/2008 2:41:59 PM |
|
|
Highlighting rows in a report based off of information from two ta
Hello,
I am trying to get rows in a report to highlight based off of two different
tables. What I need is:
If ((Table A) and (Column/Category A)) are equal to ((Table B) and
(Column/Category B)) Then (the row in the report) Highlighted = True
I have tried to do conditional formatting, but when I do that I get a box
pop-up asking me for the (Column/Category B) information; yet, even ...
|
11 |
12/3/2008 1:04:03 PM |
|
|
ForeColor Question For Report
Hello,
I have a report that i need to be able to print blank. I have used the
following to open the report to preview and this works, it has all the fields
white so there is no data showing..the only problem is I have some check
boxes that the controls are based on IIF statements. This causes them to
show Err in all the boxes. Is there a way to keep this from happening??
Private Sub...
|
2 |
12/3/2008 8:07:02 AM |
|
|
Report grouped totals not resetting.
Hi,
I have an access report based on a query that produces three items of data:
Airframe - either "Powered Aircraft" or "Rotary"
Aircraft = the tpye of aircraft in text format
CountOfID = numerical value
I have grouped the report as follows:
Airframe - with header / footer
Aircraft - no header/footer
I placed the following code into the Airframe footer with running sum over
gro...
|
3 |
12/3/2008 4:48:05 AM |
|
|
Manual report detail usage?
In Access 2003, I need to manually spin through a table and populate
individual detail lines of a report using VBA. This is in lieu of writing a
query to make this happen (long story). So if I have 5 qualifying records in
a table, I generate 5 detail lines in the report.
Can someone please point me in the right direction for this?
Any insight would be most appreciated....
|
2 |
12/3/2008 3:11:23 AM |
|
|
Modifying text boxes in a report?
Hello,
I'm editing a report that was created by someone else. The report has about
100 different text boxes. An example of the code in a text box is:
=DCount("[ms_id]","Patient_Status","[gender]=1 and [site]=1 and [refuse]=2")
So there are a bunch of columns (i.e. when site = 2, 3, 4, or 5) and 16 rows
(when gender = 2, or refuse = 1, age = <65, etc.)
I need to add another var...
|
2 |
12/3/2008 12:15:00 AM |
|
|
distortion chart when print
I have a report with charts.
It happens the charts distortion sometimes.
The charts are OK on the screen.
The distortion charts happens once a month.
Are there any issue possible that I can look in to for the distortion
charts on printer?
Your information is great appreciated,...
|
1 |
12/2/2008 5:34:16 PM |
|
|
Lebans RTF2 report print - error message "property is read-only"
Hi, I am coming back to the "old good" problem with RTF2 control on ms
access report. I use A2k3 on Vista Ultimate. In my report I have an
unbound RTF2 control and I use Detail_Format event handler to fill the
control with a rtf text. Texts are stored in an array in memory. The
handler is called many times depending on number of texts stored in
the array. Texts correspond to underlying record...
|
1 |
12/2/2008 4:11:40 PM |
|
|
Problem with Excel charts in Access 2007 report
Hi there,
I have an Access database developed in Access 2002 (XP).
The db has reports which contain links to charts in Excel spreadsheets
(unbound objects, linked so updates when Excel changes).
When running Access 2002 this all worked fine.
I've since got a new laptop with Access 2007, and now the report only
displays a small part of the linked chart from the Excel sheet - just th...
|
2 |
12/2/2008 9:47:01 AM |
|
|
Rounding in Access
I have a report created that gives an individual their stats for the week
(calls, times, etc.) The individual sees their stats, along with their
team's average.
On this average, I do not want any decimal places, but if the average comes
to 94.5%, it lists 94%. I also thought .5 was the cutoff to round up and it
should list 95%. This apparently is not the case.
Any help would be apprec...
|
4 |
12/3/2008 5:59:19 PM |
|
|
Unwanted page break
I have a report that is an index of documents, grouped by customer. The
actual documents are contained in physical binders. A new binder is started
when the previous one is full. The index needs to correspond to the
binder's contents. For instance:
Alpha Corp.
Doc1
Doc2
Bravo Corp.
Doc1
Doc2
...
Doc20
Charlie Corp.
Doc1
Doc2
...
...
|
6 |
12/4/2008 12:08:15 PM |
|
|
Detail Section background colour
I would like to use alternating section background (see more at
http://msdn.microsoft.com/en-us/library/bb243860.aspx,
http://msdn.microsoft.com/en-us/library/bb225493.aspx) but different
sections that share a specific control value (i.e. if the company name
is the same on several consecutive rows) should have the same
background colour. Thus I want to "cancel" some of the alternating
backgr...
|
5 |
12/4/2008 12:16:23 PM |
|
|
metconv.log
When I open a report in my Access-application, I get the message:'An error
has occured in MetConv.txt file! Please view the MetConv.log file for more
information.' The second, third,... time I open this report, there are no
more messages like before. What is the meaning of this Error-message? Wat is
the solution?...
|
4 |
12/4/2008 3:18:53 PM |