Conditional Formatting
Wed, 19 Nov 2008 10:09:01 -0800
I've built a report for employees that must have certain certifications.
These certifications have expirations dates. I would like to highlight dates
in red that have expired. When I've tried less than (12/1/2008) and between
dates (1/1/2007 thru 12/1/2008) it will highlight dates into 2009 and 2010
and no ...
|
Erratic print of header different from print preview
Wed, 19 Nov 2008 09:20:01 -0800
I am trying to use the .visible property to print some heading information on
the first 20 pages of a report and not print a portion of the header after
that. I have lines such as this 'If (pagenumber% > 22) Then Label150.Visible
= False Else Label150.Visible = True' in the 'Private Sub
PageHeader0_Format(C ...
|
Conditional letters
Wed, 19 Nov 2008 08:58:10 -0800
Hello, I am working on building a letter templates database because there are
so many templates we use daily. I have recently learned how to generate
letters incoporating fields to personalize address, etc. Now my problem is
that I have many conditional pragapraghs. A letter is to include a certain
paragrpa ...
|
Changing parameters... Is this possible?
Wed, 19 Nov 2008 08:38:12 -0800 (PST)
Hello-
I have a query which will indicate any employee on an active write up
in the last six months. What I need to do, based on the example
below,
is to use each employees WU date as the "start date" for their
individual record in a report. The number that is represented in
the LateStarts is the number sinc ...
|
Splitting Sub Report
Wed, 19 Nov 2008 08:14:15 -0800
I had three separate reports but I want to combine them into one through the
use of subreports. I added the second report as a sub-report in the first
report, I put it in the report footer section so that it would only show up
once after original report. There is a page break before the report to force
it ...
|
Trouble getting xy chart to change with record
Wed, 19 Nov 2008 06:55:01 -0800
I have xy data I need to show in a chart that changes with categories. My
data looks like this:
PrimaryCategory: values=A,B
SecondaryCategory: values=S,M,L
XData: 0, 500, 1000, 2000 (for each Primary-Secondary combo)
YData: values paired with XData
The report needs to show an xy chart for each Primary-Se ...
|
Carriage Return
Wed, 19 Nov 2008 04:53:02 -0800
I've used Chr(13) & Chr(10) for envelopes to combine two lines of an address
(checking to see if there is a send line first).
I have a number of fields and the information varies greatly. I thought I
could just combine the following for a neater report. This does work, but I
would like a double space betwee ...
|
|
|
Positioning Group Footer at then end of the Detail section
Wed, 19 Nov 2008 04:34:02 -0800
I ma struggling to have the only group footer I have display at the end of my
Detail Section. My Detail Section mostly occupies one page only but
occasionally there are be more pages (3 max but most 1 or 2), but there is
sufficient room left for the group footer however it is always forced on to
the beginni ...
|
speadsheet like report
Wed, 19 Nov 2008 03:50:19 -0800 (PST)
Is it possible to create a spreadsheet like reports?
I can have more than one report on many tabs?
Your information is great appreciated, ...
|
Display related fields in a report
Tue, 18 Nov 2008 20:27:01 -0800
I have a "View Details" button on a form which upon clicked, displays details
of one or more employees in a report format.
The form (child table) has textboxes that displays the EmployeeID which is a
PK for the Employee Table (Parent table).
I'm not sure if this is feasible but have written some code below ...
|
