unexpected page breaks
Thu, 20 Nov 2008 20:24:00 -0800
I continue to have unexpected page breaks in a long report that is made up of
nearly 30 subreports and several interspersed text fields. The report has
report and page headers, report and page footers, and a single detail
section. The report and detail sections are set with KeepTogether=No. The
report hea ...
|
Can't Find Object
Thu, 20 Nov 2008 20:56:23 -0500
A97
One of the outputs of a club database is a pdf report using the CutePDF Writer.
After the report is saved to the hard drive I use a macro to change the report
name - or at least I used to. I haven't used the database for over a year.
Today I opened the database and ran the report. The report printed the p ...
|
Count Unique Records
Thu, 20 Nov 2008 17:04:41 -0600
I've read several of Allen Browne's solutions to count unique records in a
report by creating text boxes and placing in group footers with control
source =1 and running sum over group. I've made this work for a total of
invoices in my report, but I need to have the invoices grouped by three
month segments ( ...
|
Count Total Records on Access report
Thu, 20 Nov 2008 23:00:14 GMT
I am running an Access database, with a table name Products which contain
Items name, Item descriptions, Item sold, Sold price.
I've create a report to run on a query to base on the Item Sold status ( yes
or No) to narrow down the report and I wanted to indicate the total item sold
or unsold on the report, th ...
|
Subform in Report is blank
Thu, 20 Nov 2008 13:28:04 -0800
Access 2003
I created a form(A) which is used as a barchart. I have placed this form(A)
as a subform in a report, but it only displays a blank page. There is
nothing in this report except for this subform in the Detail section.
The form(A) is fed date information by another form(B) which currently only
...
|
Force page breaks
Thu, 20 Nov 2008 16:06:33 -0500
I have a database that lists documents. Each document is associated with a
customer. The originals of the documents, with actual ink signatures, need
to be stored in binders. That's not my preference, but it's the way it is,
and it won't change.
The binders will be titled something such as A-C, D-E, F-J, ...
|
Add FY to Report header
Thu, 20 Nov 2008 08:15:01 -0800
I have posted before but was unable to access link.
I have a report using a crosstab. How do I post the FY in the report header.
TRANSFORM Count(DRIVELOG.[Driving Observation]) AS [CountOfDriving
Observation1]
SELECT Employees.SSI, [Last Name] & ", " & [first name] AS Expr2,
DRIVELOG.[Driving Observation], E ...
|
|
|
How to view even columns in Report Print Preview view
Thu, 20 Nov 2008 07:59:01 -0800
I have a report that updates a telephone call roster. I am attempting to have
two columns of the information. However, each column has 3 columns to go with
it (Initials, Name, and Phone Number). I want the 2 larger columns to run
evenly. I can get the columns to run evenly if I switch the Columns Layout to
' ...
|
"Add" Can I display numeric zero values in crosstab query reports?
Thu, 20 Nov 2008 07:32:00 -0800
I an using this SQL but I am not getting "0's" in month headers.RANSFORM
(NZ(Count(licensetcount.AcctionId),0)) AS CountOfAcctionId
SELECT licensetcount.PosDlicense, Count(licensetcount.AcctionId) AS [Total
Of AcctionId]
FROM licensetcount RIGHT JOIN Employees ON licensetcount.SSI = Employees.SSI
WHERE (((lic ...
|
Printing reports from a button on a form
Thu, 20 Nov 2008 15:19:29 GMT
Can I print 1 or more reports from a single button on a form without
previewing the reports first?
--
Message posted via http://www.accessmonster.com
...
|
