subreport data cut off
Fri, 5 Dec 2008 13:51:55 -0800
We have created a report with two subreports. When printed or in print
preview, if the subreport(s) has a large number of records, the last records
are cut off. Is there a way to set up the report so that any record overflow
prints on a second page? ...
|
Sum fields with condition
Fri, 5 Dec 2008 13:38:00 -0800
In my report, I have the field names: RSM, Sales Opportunity, and Sales
Converted. I need to be able to find the sum of the Sales Opportunity or
each RSM (I can use the same formula for the Sales Converted easily enough).
For example,
RSM Sales Opportunity
John 2000
Steve 5000
John ...
|
Need expression Help on displaying value
Fri, 5 Dec 2008 12:38:26 -0800
I have tried IIF and can't seem to get anything but ERROR. If [home phone]
is null, I need the value of [cell phone] displayed on the report. I cannot
find anything anywhere that helps. ...
|
How to print Name and Address on Envelope
Fri, 5 Dec 2008 12:23:01 -0800
How can I print Name and Address fields on Envelope for a single record.
And specify envelope size. I tried using the Label Wizard but I want only
the select record not all records. Any idea how to do this?
Thanks
--
FL ...
|
Highlight user input paramter in report
Fri, 5 Dec 2008 11:51:00 -0800
I have a text field in my database which can be quite lengthy named â??Main
Descriptionâ?. I run a report to search Main Description for a user input
parameter. Letâ??s say Iâ??m looking for the word â??Snowdenâ?. Right now the
report will print every record that contains the word â??Snowdenâ? in the Mai ...
|
Page Numbers for Report Groups
Fri, 5 Dec 2008 11:07:01 -0800
I recieved some help from someone on this issue last week... but it still
isn't solved. I want to print a report with page numbers for groups of
records not the overall pages of a report. I have an unbound text boxt in the
page footer named Me!ctlGrpPages. The page footer section has [Event
Procedure] in On ...
|
Can't move Text box in design view
Fri, 5 Dec 2008 10:37:01 -0800
We just upgraded to Microsoft 2007. I am designing a report and want to move
a text box to the right. For a while, it lets me move it, but then it stops
and locks up. I can't move it left or right, but can move it up or down.
What gives? ...
|
|
|
Shadebox to grow with memo textbox
Fri, 5 Dec 2008 09:45:01 -0800
Greetings all,
I have a report that the detail section is set to shade every other record
via conditional formatting using the expression: ([txtShadeBox] Mod 2) which
works fine. The shade box is positioned behind transparent text boxes.
The issue is that the shade box does not grow with a memo text box th ...
|
conditional formatting
Fri, 5 Dec 2008 08:56:34 -0800
I would like that the whole line be underlined ormiddlelined if a field
(yes/no) is yes.
Thank you in advance
Mansoor ...
|
Send reports by email in Access
Fri, 5 Dec 2008 08:28:02 -0800
How to create a command that users can use to send complete reports to
corresponding people by emails in Access ...
|
