|
Unbound textbox populated via IF
I have an unbound text box ("tbxRating") within the detail section of a
report. I want the value in this text box to change based on a calculation
of other text boxes within the same detail section. The report includes
multiple measures (each has its own details section with "tbxRating") as
designed, but the result within this text box is only accurate for the first
measure. All other...
|
3 |
10/11/2008 4:10:35 PM |
|
|
Help with counting items by report section?
Help with counting items by report section?
Current Situation
Here's the report hierarchy I group by Region and Vehicle:
Region header and footer(can have many trucks)
Vehicle ID header and footer
Detail (this reports the date in, date out, job#, days utilized,
and percent utilization.
I need to the utilization rate by region and don't understand what I
can and cannot do...
|
3 |
10/11/2008 3:53:23 PM |
|
|
group suppression
how to do group suppression on a report ala:
99999 XXXXXXXXXX 999 999 999
999 999 999
99999 XXXXXXXXXX 999 999 999
99999 XXXXXXXXXX 999 999 999
999 999 999
999 999 999
...
|
4 |
10/11/2008 3:22:37 PM |
|
|
Applying Discounts in Reports
I have a Revenue Forecast Report that I have created in Access. Each Detail
is split by Client with a subtotal in my Report Footer. I want to apply
discounts to only eligible Clients - showing the running sum of all applied
discounts on one line - then showing a grand total with subtotal - discounts.
How to I pull totals of only eligible Clients - apply the varying discounts
and showi...
|
2 |
10/11/2008 10:49:29 AM |
|
|
IIF in a report Footer
=Count(IIf([Gender]="M",0)) in a report footer will total all the Males in
the query the report is based on.
=Count(IIf([Gender]="F",0)) will likewise give me all the females.
But can I add an additional criteria to the IIF statenent. If my query
tracks M and F - -- - and also HS or College,
Can I add aadd additional criteria to the IIF. I want 4 entries in my footer:
Male Co...
|
4 |
10/10/2008 11:56:01 PM |
|
|
auto resize a text in a text box
Hi, is there a way to auto resize a text to fill the text box. I want to use
this for a name tag to fill up the text box according to name's length. Thank
you in advance....
|
2 |
10/10/2008 11:53:05 PM |
|
|
Best approach to report results by quarter
I am looking to build a performance measures database. Measures are input
monthly with narrative. Reports are generated quarterly and should show
summed results for each quarter as well as ALL the monthly narratives. The
ultimate report format should look something like:
Q1 Q2 Q3 Q4
YTD
t_measures numerator desc ...
|
5 |
10/10/2008 9:07:01 PM |
|
|
SubReport on a New Page
I Currently have 2 main reports, I would like to put the second one into the
first one as a sub-report, is there any way to make the sub-report show up on
a separate page as the main report?...
|
2 |
10/10/2008 7:21:30 PM |
|
|
Reading order
Is there a way to have the first page's reading order to be right-to-left and
the second page to be left-to-right?...
|
2 |
10/10/2008 6:56:01 PM |
|
|
Multiple Pivot tables and Charts in Report
I want to create a report that will show multiple pivot tables and charts.
Each one is based on the same query with a parameter asking for the [starting
date] and [ending date]. Each table or chart has the data organized
differently.
Right now I have three loaded in the report; two table and one chart. When
I run the report, it asks me for the starting date and ending date three
ti...
|
1 |
10/10/2008 4:06:00 PM |
|
|
Duplication of reports
I have a report which has a subreport in it. When I try to print it, it
prints the information once (i.e. headers and footers) and then another page
which properly includes the subreport. How do I get rid of this first page?
I could print it and throw away every other page, but that seems like a
waste of paper. Not sure what's going on. Any help appreciated....
|
2 |
10/10/2008 12:41:01 PM |
|
|
Report Data Not Printing
Hello,
I have a report which contains 3 sub reports. In the parent report I have
information that is displayed in the detail section that does not show in
print preview or print out period.
The same is occuring in the sub reports. However, in the subreports,
information located in the details section is the only data that is being
printed. I have data that I would like to have print...
|
5 |
10/10/2008 10:25:01 AM |
|
|
Creating a report from a query
I am having problems pulling in the information I want from my query to my
report due to table relationships.
I have created a report from a query that shows the number of animals sold,
died or transferred for the month. This query comes from a disposition
table, every animal that is sold, died or transferred has an individual
disposition number and is entered into the disposition tabl...
|
6 |
10/10/2008 2:41:01 AM |
|
|
Short cut for a Access Report
I generally create a Swithboard using Excel to hyperlink to working documents
in Word and Excel as well as hyperlinks to open an Access Database among
other files and this works really well for me and my department. Everything
in one place, well organized and fully descriptive. All of the features just
a click away.
Recently, I have a need to provide easy access to specific MS Access ...
|
1 |
10/10/2008 2:19:13 AM |
|
|
Linking dates In reports
My brain has stopped working. I have a Monthly Report of Expenses and a
separate Monthly Report Of Income. Both derive their totals from separate
Tables & Queries. The final report is a joining of the 2 in order to produce
a basic P&L.
By combining bothe report queries into one I get (as they say) unexpected
results. I have fiddled around with the joining of the date fields and tested...
|
5 |
10/9/2008 9:55:01 PM |
|
|
Cancel Button Problems
I have created a form to filter my report. The report is based on a query and
the form is an unbound form with combo boxes and text fields to allow data to
be selected. I have been trying to set up the cancel but to cancel the report
and close the form. However, it is not working and when the cancel button is
selected it runs the report with all data.
Private Sub btncancel_Click()
...
|
3 |
10/9/2008 9:21:02 PM |
|
|
Lebans Rotator
I downloaded this rotator from Lebans site:
http://lebans.com/xrotatetext.htm
I'm using this feature on a report for attendees at a conference. The report
is 8.5 x 11 and formatted to print landscape. One the bottom part of the
report I have text (example: Joe Smith) that's large font (approximately 40)
and centered. On the top part of the report I have the same text (same size)
rota...
|
1 |
10/9/2008 7:50:19 PM |
|
|
Grid Line for First Field in detail
I can get grid lines around each field except the first field.
How do I get a grid line on the left side of the first field:
Here is my code:
For Each CtlDetail In Me.Section(acDetail).Controls
With CtlDetail
Me.Line ((.Left + .Width + intLineMargin), 0)-(.Left + .Width + _
intLineMargin, Me.Height)
End With
Next
Thanks,
nancye...
|
5 |
10/9/2008 7:19:02 PM |
|
|
"This expression is typed incorrectly, or it is too...
Can someone tell me what is wrong with my query
SELECT MTCQ.MONTH, MTCQ.YEAR, MTCQ.DISTRIBUTOR, MTCQ.UPC, MTCQ.[ITEM
DESCRIPTION], MTCQ.SIZE, MTCQ.[CASE PACK], MTCQ.[DIRECT IMPORT], MTCQ.[BDM
STATUS], Sum(MTCQ.tncp) AS SumOftncp, Sum([Tbl_Cumm Actual Results].[BILL
UNITS]) AS [SumOfBILL UNITS], Sum(([BILL UNITS]/[CASE PACK])) AS [BILL CASES],
Sum([Tbl_Cumm Actual Results].[SALES UNITS]) AS ...
|
3 |
10/9/2008 7:01:06 PM |
|
|
Drop Down Box
I created a report that displays a specified health record, the user types in
the health record number and then the report comes up with all the
information. I would like to create a drop down box on the report which
would allow the user to select the manager/technician that filed created the
report to be submitted.
Is it possible to do this?
Thanks....
|
3 |
10/9/2008 6:34:02 PM |
|
|
grid lines in group header
I am trying to add grid lines to a group heade 0 in a report.
I can get the grid in the detail section, but how do I get the same in a
group header0
Here is my code for detail section
Detail:
For Each CtlDetail In Me.Section(acDetail).Controls
With CtlDetail
Me.Line ((.Left + .Width + intLineMargin), 0)-(.Left + .Width + _
intLineMargin, Me.Height)
End With
Next
Thanks,
nancye...
|
3 |
10/9/2008 6:12:03 PM |
|
|
How can I disable the "Printing" Message
I have VBA code that loops through a recordset and creates 1 pdf report per
person. Each report pops up a MSGBOX that says "Now outputting to ......."
shows the page number being created. I would like to disable this message.
Can anyone tell me how? ...
|
1 |
10/9/2008 5:59:03 PM |
|
|
Bordering for Report
I have designed a report which is a certificate for candidates atteneding a 1
day course. It has page header, details and page footer. I am using the page
header and footer for logos and page details for candidate details.
I need to draw a page border continuously across the page header, details
and page footer. Basically, the page border should border all the information
in the page.
...
|
6 |
10/10/2008 1:59:00 PM |
|
|
Attaching snap sop reports to an email using Lotus Notes
I need help on this,
I need to automaticaly email a report in snap shop format using Lotus notes,
I have a send report button in a data entry form after enter the data I
pressed this button and the report prints and open the email page so the user
have to click send but what i need is that the same button print and send the
report without user intervention,
any suggestion will be appreci...
|
2 |
10/11/2008 1:11:15 AM |
|
|
how to change font size when field is too long
While printing name tags from names in a database, a name is occasionally
too long to fit the text box using the prefered font size. How can I sense
overflow and reduce the font size for this particular name tag?
Sam
...
|
9 |
10/11/2008 12:47:09 PM |