Printout looks bad, empty vertical spacing between records in report
Sun, 7 Dec 2008 23:28:06 -0800 (PST)
I have made a report consisting of 3 main bound textboxes, A, B and C.
I have grouped A and B and put them inside their own group sections
(group headers), C is left in the details' section.
The look of the report is very much a tightly populated list in 3
columns, with quite a lot of record rows per page.
...
|
Select from Drop down list
Sun, 7 Dec 2008 20:06:00 -0800
I have designed a report based on a Query. At the moment the user has to type
in the criteria required into a Parameter Section. What I would like is that
the user is presented with a drop down list of the areas to save having to
type in the respective area.
Thanks for any help ...
|
Setting a printer
Sun, 7 Dec 2008 21:21:52 +0300
Hi, I need to select a printer for reports when I start an Access 2000
application without changing Windows Default printer and print dialog box.
Actually, it's not a problem to select the printer. The problem is that in
contrast to later versions, Access 2000 has no application property
Application.Printer t ...
|
Conditional Color of Report Object
Sat, 6 Dec 2008 17:35:00 -0800
I want to set the background color of a report object based on a certian
condition.
If the object's value is > 0, I want to change the background color to yellow.
I assume that I need to use VBA in one of the report events, but I don't
know the code or event.
--
Ken Hudson ...
|
Count items in report without including 0 values
Sun, 7 Dec 2008 00:16:40 +0100
I think it is simple but I tried for two hours and I didn't manage this
formula
All I want to do is to count items on report without including records with
0 values. This report contains few Number rows an I can mange other
formulas, for this one I tried: CountIf ([items_billed], ">0"), however it
seem li ...
|
Need Help Creating a database
Sat, 6 Dec 2008 09:00:45 -0800 (PST)
Hello,
I am trying to create a database using access. I want to store the
current inventory of boxes and other moving supplies. When i sell an
item from this inventory to a customer, i want to store that
transaction and reduce that item in the inventory. How can i do this?
I am confused in setting up the rela ...
|
Iff statements
Sat, 6 Dec 2008 07:52:04 -0800
My report is driven by a query which has a field titled [Amount Paid] and a
check box field to mark if the amount has been paid. My report is seperated
into [Amount Paid] Yes and [Amount Paid] No. In my report I want a total for
the field [Sales] but only when the amount has been paid, meaning the [Amount
P ...
|
|
|
Export Access 2003 Report To Word Create Path and Open It
Sat, 6 Dec 2008 04:48:00 -0800
I am trying to run then export a report to Word so that it opens on a form
button click and is editable in word.
Using my limited knowledge I can create the report but then keep on getting
a msg box asking me where I want to save the file before I can view it. I
want to avoid this message box appearing and ...
|
Sort will only sort text from smallest to largest?
Fri, 5 Dec 2008 19:39:00 -0800
Hi,
Trying to sort a report by 3 fields. 1st by a text field that should sort A
to Z, then by a number field that should sort smallest to largest, then by a
3rd number field that should also sort smallest to largest. However the only
options offered are backwards. It is offering me a choice of smallest to ...
|
Default Value when input data
Fri, 5 Dec 2008 14:56:03 -0800
Hi Guys
I have a query with detail data, one of the fields contain the document's
date (DocDate), because there are some many reports derivate from this query
and I needs to type the date range every time I open a report, and more of
the time I analyze the different reports in the same date range, what I ne ...
|
