Custom Label Report
Tue, 9 Dec 2008 00:42:01 -0800
I am looking for a code example to print a label report where each label
would show the first and last values in the account number field from the
source table for a specified interval.
If the specified interval were 20 records, the first label would show the
first and the 20th account numbers, the second ...
|
Rich Text in textbox
Mon, 8 Dec 2008 19:14:57 -0500
I have a textbox with Rich Text enabled. The <b> bold tag works fine. The
<span> tag with style disables the price field. How do I specify a separate
color for that field?
=IIf([Price]>0,"<b>Price: <span style='color:#BA1419'" &
FormatCurrency([Price]) & "</span></b>")
thanks
...
|
preview is different then printout
Mon, 08 Dec 2008 23:52:30 +0100
Hi,
When I write:
DoCmd.OpenReport "Voorbereidend_document_beeldvorming_GASV",acViewPreview
I get a perfect report with 2 header lines
Then I click the print button and everything is nicely printed.
When I write
DoCmd.OpenReport "Voorbereidend_document_beeldvorming_GASV"
I get a printout without the 2 ...
|
Thanks to Dale Fye and QuimaxW
Mon, 8 Dec 2008 14:25:57 -0800
...
|
Dynamic weekday total for any given month
Mon, 8 Dec 2008 13:39:00 -0800
I have a report grouped by months, and in the date group header, I want to
reflect the total number of available weekdays in that month. I can't use a
parameter query because there are multiple months in my report. It needs to
be something like if month is September, then available weekdays = 21.
Anyone kno ...
|
Summing Expressions Containing Aggregate Functions
Mon, 8 Dec 2008 13:06:03 -0800
In my report I am trying to sum how many franchised hotels we have in our
pipeline in North America. How do I tell the report to sum my field called
pipeline hotels if the owner type field equals franchised and the project
type field equals new build? ...
|
Office 2007 Reports Parameter Promt calculating?
Mon, 8 Dec 2008 12:11:36 -0800 (PST)
I have a database that we created in office 2003 that is (basically) a
database of labels. It contains LOTS of reports all based off the same
set of 4-5 queries.
Most of these reports contain a text box similar to ="Model: " &
[Enter Model]" or =Trim("Model: " & [Enter Model]) Because this field
isn't defined ...
|
|
|
How do I get a "Year to date field" in a report
Mon, 8 Dec 2008 09:48:53 -0800
I have a linked (with tblDonors) table (tblCheckData) with :ID1,
txtCheckNumber, txtCheckAmount, txtCheckDate, TxtDateReceived fields. I
can't figure out how to get a "year" total for each person who donates in a
report. I use a "parameter query" to get a partial year total but must also
report a year (or ...
|
how to get few records from the total records
Mon, 8 Dec 2008 07:10:16 -0800 (PST)
hi
i'm trying to operate a report when only few records should appear]
for example
if i have 10-15 records from same event
i would like to get only 3
of course if there is only 2,so only the 2 records will appear
is it posible? ...
|
Syntax Error (missing operator) in Query Expresison
Mon, 8 Dec 2008 07:09:01 -0800
I am receiving an error message: Syntax Error (missing operator) in Query
Expresison. Once again, I am able to print all reports from my database, but
I am trying to design a print button that will allow the user to print
selected report(s). Below is the code that I have for this print button:
Private Fun ...
|
