This database has worked fine for a few years.  Now on one machine
only, DoCmd.OpenReport gives an "action failed" message about the
macro that called the VBA function.  There's an error handler in the
function that does not get hit.  If I replace the DoCmd.OpenReport

I have the below code on one of my reports. The first "IF" statement fails to
work if my me.Brand = Amerec. However if it's any of my other If ...me.Brands
below the IF..Me.QuoteExp will work fine.
Can anyone explain why?

Sorry to ask what is probably a simple things, but being a newbie with this
I have no idea if it can be done.
I know how to output the report to Word rft format, but I like to know if I
can do it to Word .doc instead.

I am trying to group by a field called comments.  It shows up on the FIELD
list for the report but when I am in the sorting and grouping
window(dropdown) the comments field is not showing up - I am sure it is
probably something easy but I can't figure it out.

I need to reformat a purchase order report to print a new "signature" page
footer after the Detail section on every odd page number and to print a full
page of terms & conditions without a page footer on every even page number.
When the report is printed to a duplex printer, the ...

I have the following problem, I have created an report on base of the
ordertotal report from the northwind database. A User can select two date's
and all the order information between those two dates will be shown.
In the report I show for each record the orderid, article, prijs ...

I have a report that gets its data from an open Form. One of the items is a
set of Check Boxes - what I am trying to figure out is I don't want the Check
Boxes to appear on the report if they are UnChecked on the form. Here is the
control source path that I use to link it to the ...

Through a Microsoft rss feed, I learned how to take a simple database report
and shorten the number of pages by using the option for multiple columns when
you print or print preview.  It is a list of my music song titles which is
lengthy.  It worked great except for one thing: ...

I set up the following code in the Control Source of a field on a report:
=IIf([Category]="LH" Or [Category]="PH" Or
[Category]="TH",Format([P1],"Fixed"),IIf([Category]="RT",Format([P1],"0.0"),Format([P1],"Percent")))
It worked properly, changing the format for the field depending ...

I am working on a project that has a report with a subreport. However
both of these run off of a query that has a criteria for date range
for the data. When I run the report I have to enter the beginning and
ending date twice. Is it possible for me to set this up where I only

Please advise me a link of any sample mdb where the logo are shown in
watermark format, so that I can understand and can use the same method to get
my job done.
regards.

I have the following expression in a text box on a report:
=IIF([type]="USE", FormatPercent([Rate]), FormatCurrency([OtherRate]),2)
The problem I'm having is that Rate might be .05, which I would like to show
as 5% or .03225, which I would like to show as 3.225%.  I want it to show ...

I have a table with personal information and a flight code. I have another
table with the flight codes matched to flight numbers, airlines, and
departure times. I would like to print a report sorted by flight code but
show the flight number as the group header. I tried setting it ...

I have a combo box named Combo73. It displays the 2nd column of a query named
IssueCodesQuery. The actual data entered for example is 17.3000 or 01.1000. I
want my report to display 17.3 or 01.1. I have tried using the following in
the control source  for the Combo73 with no ...

If I were to use the Lebans ReportToPDF software to create a PDF, what set
of Access 2003 protocols would I then use to send that PDF as an email
attachment?  I poked around at the help screens, but I can't figure out how
to send an attachment that's a file.