Is there a way to call out all of the controls on a report in the OnPrint
function?  I have a report where I want to add circles to several of the text
boxes on the screen.  I hard coded all of them with the necessary info to get
the circle, but it seems like there should be an ...

Hi I have a report that is 1 page and this is how it displays in print
preview, however when I print I get a get the report and a blank page!  Any
suggestions on why this is.  (I have not set the database up so it is
possible that it may be set like this - if so how do I undo this).

Let me see if I can explain what I need.
I have a table with three fields: Item, Color, and Count.  The same Item can
have many entries based on Color.  Say I have an item Beads and there are 10
bead records for 10 different colors of beads.  I want a “single” line report

For some reason, whenever I try toprint a report to PDF, it creates a notpad
error file instead.  This does not happen while in Forms, nor with any of my
other separate data systems.

Is there a way to keep a long entry in a field on the right side of the page
from defining the space on the left?

I have 40 or so columns in a table using the yes/no data type. Each
record in the table represents an audit of a paper form. Those items
filled incorrectly or incompletely on the paper form receive a check
on an access form during the audit process.

I'm trying to create a report that shows the customer's mailing address on
the first page, page numbers are "1 of X", account activity is sorted by
[start date] to [end date].  I can do this easily for a single customer.  But
when I run a range of account numbers I run into ...

I have a currently-existing report, tied to a query. My goal is to allow
users to preview a report, filtered on criteria from a combo box.
The field I want to specify is, itself, a combo box. The data would exist in
multiple records, but be a finite list of information.

I have a report called “rptActivityReport”. This report is made up of many
queries. How can I add a date range to the report?
For example, the user will enter a date range [1/7/06] and [8/19/07] and the
report will auto populate all the textboxes with the query results form all

I have a form that has information for different Products as they relate to
certain properties. In the end I would like to compare 3 of the products in a
report. Currently I have the divided the report into three columns; however,
all of the properities repeat. I would Like to have ...

I have a report in which the end user selects a single person or multiple
people from a form and then I store their selection(s) in a temp table
(ttmp_Prn_Isu).  I have a report that uses this temp table as its datasource
so that I can sort and group it properly.  All the fields ...

I have a subreport that lists peoples names. However the standard format is
like this;
Name1
Name2

I have a main report which has 1 column but I want my subreport to have 2
columns? Is this possible? When I change the page setup in the subreport it
aooears to alter the main report as well.
Thanks

I am working on a database to hold schedules for a public transit
agency.  I have one table called "Trips" with fields such as "Route#,"
"Trip#," "Stop01Time," "Stop02Time," etc.  Another table
("StopsPerRoute") has the stop names for each route.

How can I set the enabled property of a command button to false if the form
is opened in add mode?