Moving controls inside a Tab Control
Thu, 30 Oct 2008 12:42:01 -0700
On a report detail section, I have a Tab Control. Whenever I change the Top
property of one of the controls on one of it's pages, Detail.Height gets very
large, taking up 3 pages. I am doing this using VBA code in the Report's
Open event. I am opening the report in the Preview View from a form. If I
open ...
|
Color Code Madness
Thu, 30 Oct 2008 11:36:00 -0700
I have a report where the 4th and 5th Column number should always match.
example column 4 is 10 count column 5 should be 10 count. I want to do this.
If column 4 is less than or greater than but not equal to column 5, then
color code column 5 red. Oh and this would be per row not per column. Is
this possi ...
|
subreport charts issue
Thu, 30 Oct 2008 11:34:35 -0700 (PDT)
I have a report which has several subreports.
The subreport visible property need be set depends on the user
selection.
I have an issue is when the subreport has charts on it. The subreport
overlap each other, because the charts change sizes.
It works if the subreports without charts and work well with ...
|
Using a Sub to make Items Invisible
Thu, 30 Oct 2008 11:20:01 -0700
Is it possible using an 'on format' procedure to change the visible property
to false for a report? I have tried "Me.Line31.Visible = False" and "Set
Me.Line31.Visible = False" statements in the sub and neither works. I have
also tried '!' instead of the '.' for separators but that makes no
difference. I ...
|
Web service's XML result as a Data Source for a report ?
Thu, 30 Oct 2008 11:17:02 -0700
I have a webservice that returns XML which can pretty much be translated into
a two column table. This is because direct access to that SQL Server Database
is not permitted and web service is the only way to retrieve data.
My question is, how do we bind the XML returned by this web service as the
data sour ...
|
Charts in Reports
Thu, 30 Oct 2008 09:04:12 -0700
I have put a pie chart into the Report Footer of a Sales Report so that it
only displays at the bottom of the last page. I am using Access 2003.
In Excel, I can display Values or % that each slice of the pie represents.
I cant seem to find the appropriate command to do the same in Access.
Please help
Tha ...
|
filtering out fields using code in an address block in a report
Thu, 30 Oct 2008 06:38:03 -0700
How do you filter out fields that in some cases may be null (but not in other
cases) for any given address in a label or on a report? Example:
Address number one:
Joe Schmoe, Ph.D.
123 Main Street
City, State Zip
Address number two:
Joe M. Schmoe
456 Main Street
City, State Zip
How do you code it ...
|
|
|
To Rob Parker - RE:Reset Page of Pages in Multipage reports
Wed, 29 Oct 2008 22:22:00 -0700
Rob I am still having problems please see my post to your reply
--
Glen
Simple Scientist aka Microbiologist
Brisbane
Australia ...
|
Reset Page of Pages in Multipage reports
Wed, 29 Oct 2008 18:48:01 -0700
When we produce laboratory reports there can be 100+ pages that is the
[Pages] value is preset.
Of these reports some are multiple page reports whereas most are 1 page
only. I need each report to say in footer Page X of Page N
Where for one page report this is Page 1 of 1
And for multipage reports -> Pa ...
|
Mailing List Report
Wed, 29 Oct 2008 14:45:01 -0700
I am new to Access and was trying to bnuild a simple database to track
members of my state's dental assisting members. I was able to use a database
already created that I found under Microsoft Office Online. I need to be
able to sort by zip codes and produce a mailing list. Can this be done and
if so, how ...
|
