I have three databases a front end app database, a backend tables
database and a reports database.  I have sucessfully opened my reports
in the external database, however the report refrences a date range on
an open form within my front end app. When the report is opened in the

Ok, Thanks to the Ken and Steve who answered Dumb Blonde's question about iif
in control source on 12/8 you helped me eliminate #Error in the field.
I'm using Access 2000 SP3 on Windows 2000 and the table is on DB2.
Now how do I get the text box to show nothing when the value is ...

In an Access report how do I determine in a report's Vb Code whether the
report view is Preview?

I want to add a field that will count each record in a report.  I want this
field to display the number pertaining to each record.  For example, record
one will display "1" and record two will display "2".  I DO NOT want a
summary or total count.

How do I refer to a txtbox on a report, dynamically, regardless of which
report the user chooses?
I have already read the thread here "assigning value to text box", but one
suggestion to doing this, returned an error, the SetFocus line, at

Hi!   I have a report that takes part of the heading data from a value on a
form.  It looks OK on the print preview but actually prints only #Name? as
the heading.  Why can't it find the data?  I am using Access 2002 SP3.
Thanks, Chris.

Creating a report of employee salary, its consists of 6 pages. I can easily
picked the SUM of all emp's salary. But, now i have to change it a little
bit. At the end of page, Just like to print sum of salary of Emp listed at
each page.

I have a report that generates multiple pages.  In the Page Header, I have
the column names. Because of this, the column names repeat at the top of each
page.
In the Report Footer, I have numberous calculation totals. (Which shows as

Help when I enter my number it keeps rounding - won't show my 2 decimal
places.

I have a report with two subreports that works quite well in that it prints
all the information that I'd like it to.  The only down side is that in some
cases there's a lot of empty space between the two subreports.  If the first
subreport consists of two lines, the second ...

Hi again,
another query.
How can i format the field layout while displaying to the report.
what i have to do is.. just change 23423423423423 to 2342342-34-23423 and

I have a report which is grouped by we'll say 'department'. There is a lot
of detail in each group and i want to force a new page once the group changes
to the next department. How do i do this? I know how to do it when there's
Summary Options used but can't seem to get it ...

Is it possible to get the results of 2 different queries onto one
report-page?
Thanks
JP

I have a report which lists items and one of the fields called Description
could be very long or short depending on the item. I have to provide 200
characters for this field but in the the report, it gets truncated. How do I
configure such fields to be "auto-sizing" meaning, if ...

I have an Access 2000 program that reads the date in d/m/yy instead of m/d/yy
on one customer's pc.
The program is running Access 2000 runtime on a WinXP Prof. OS with Office
2000 Small Business installed. The appl first opens to a window that contains