I have a form that prompts user for selection of user ID and Name that will
then search database for records that contain the users initials.  The form
requires user to select the user information from drop-down Combo list (Field
name Combo29).  Combo29 field has two parts, ...

I've set up a report to produce mailing labels in Access 2003. I used the
label wizard. The mailing labels are to be printed using an SLP-220 Printer.
The printer uses a roll of labels where the labels are one to a row and
turned sideways. (Imagine a normal address label, now ...

When executing a report If the underlying query for a report has no records,
how can i display a message box with a critical error statement, rather than
try to open a  dud report

I am using Access 2000. I have a  form and a correponding report...both have
a richtext activeX (Lebans FMC V1.8). When I run my report, the first page is
always blank. I am using the code that came with the control example, which
does the same thing:

Background: I currently have a simple sales report which displays a bar chart
based on a parameter query(The Chart uses the parameter query, the report has
no queries at all).  When you open the report it prompts you to enter in the
Sales person's name.  When I enter the name(we ...

Stuart's question is mine exactly. If one deliberately canceled the report,
one does not wish to be notified of the fact.
Thank you, in anticipation.

I have a Global Variable, "MyFilterCriteria"
We have a report, 'Certificate of Calibration' that is opened with the
LinkCriteria of 'Test Number'
This Report has a Subreport, 'Test Weights'

I am using the correlation coefficient formula in one of my reports.
I can not figure how to get the square root of the division part of the
equation.
Could some one please help me on this.

The margins for reports I've created keep reseting themselves to the default
setting. It doesn't happen all the time. There seems to be no rhyme or reason
for when it "decides" to reset. Any suggestions?

In Access 2002, I have set up a report with several text boxes. Now, I would
like to assign a specific format (bold, background colour) to one of the
textboxes (named 'BE') depending on its content, and this I want to realize
by a macro.

I have a report in which several sets of records are grouped together in
cases.  These cases are interspersed throughout the set of records on the
report, as the majority of records do not belong to a case (and are therefore
not grouped together).

I'm new to using A-2000 but have picked up quite a lot from playing around
and reading these forums.
I have put together a fairly nifty database for a newbie, and have designed
the report output I need to see, however, some records are started on one

Can I add the information from a subdata sheet into a report?

  I am using access as a project list program. I run a report to
display the contents of a table. Sometimes a "project" will extend past
the length of one 8.5x11 page, and access lets it flow(wrap) correctly
to the next page. However, if an entry ends leaving for example half

I've a report which needs to calculate a period to date figure depending on
the period number which appears on it.
I've tried using an iif expression, but it's far too long and cannot display.
Can anyone help?