border fill up code in subreport does not work
Fri, 15 Aug 2008 23:29:01 -0700
hello,
im my report there is a subreport, my subreport shows records, for some
times that my records in subreport are less part of page will be white, i
want to fill up rest of subreport by border, i have used the code like below
but it does not work for subreport and just work for report.
thanks in advanced ...
|
Date Ranges
Fri, 15 Aug 2008 10:38:04 -0700
I would like to run a report where the operator selects a starting date and a
ending date, and then have the report only show that information. Can anyone
help with the process I would need to follow to make that happen? Do I need
a query first? If so, what would the criteria be, etc...or can I do it in a
...
|
Trouble switching syntax from IIf to Switch
Fri, 15 Aug 2008 10:25:03 -0700
I have a report prepared monthly that sums totals of the controls on the
form. (Underlying data type is number.)
I need to be able to calculate a percentage that is the current month's
total/20034. So the percentage changes each month as new totals are
calculated.
I started with an IIf statement, which w ...
|
Access 2003 Reports
Fri, 15 Aug 2008 07:55:01 -0700
I am looking for a way that, when I click on a report a pop up screen will
appear and ask me to enter a category, then OK this will then look through a
specific column in my table and produce a report of the category I requested?
Any advice would be much appreciated. ...
|
Access 2007 slow designing forms and reports
Fri, 15 Aug 2008 07:24:01 -0700
Access 2007 is painfully slow designing forms and reports. It takes to long
to view reports. Moving between fields in design mode takes several seconds. ...
|
Using Crystal Reports with Access
Fri, 15 Aug 2008 06:53:02 -0700
I need to create a multi-page output based on results stored in an Access DB.
The output consists of a cover page, a couple of pages of narrative and a
summary page - each with variables embedded in the text - and then columner
data. Somethink like Crystal Reports seems logical. Is it possible?
Reasonabl ...
|
Report to PDF in Adobe 8
Fri, 15 Aug 2008 09:11:37 -0400
I located some code online to save a report to a PDF file. Works fine,
except I am prompted for a location to save the file to. Is there any way
to disable this? I need to run hundreds of reports automatically without
user intervantion.
...
|
|
|
Default text in date field
Fri, 15 Aug 2008 05:01:04 -0700
Is it possible to display default text "DRAFT" in bold red in a date field
until such time the date is entered and displays in another color? I want to
be able to issue a draft report and looking for a simple way to do it. ...
|
Option to add in an extra page to a report.
Fri, 15 Aug 2008 03:49:00 -0700
I am using Access 2003 to create a project status reporting tool.
One of the reports in the tool is a page where a chart is inserted (and
linked) to a field which displays on a whole page.
The problem is that projects can require from 1 to 4 of these charts in
their report.
I am trying to find an opti ...
|
Group Totalling
Fri, 15 Aug 2008 11:44:56 +0100
Access 2007
I have 3 levels of grouping
PageNo (userdefined from 3rd party docs) - total in footer
SectionHdr - total in footer
SubSectionHdr - total in footer
The footer for PageNo has a break after the section so that the user defined
page no starts on a new page for each.
Problem:
When the SectionH ...
|