Is it possible to have a report pull from multiple sources without being
bound.  I guess the correct way to pose the question would be can I have
bound text boxes in an unbound report.
Can I do this without having subreports.

I have a report from a query that has two tables with a one to many
relationship because one field has many records relating to the other table.  
When I make a report from this query I get a page for every record in my
second table.  How can I limit the report to only show the ...

Via an IIF statement only a textfield is printed when the related field has
data in it.
The "can shrink" property is set to yes...
This all works just fine but I don't gain the space in my report when the

I believe I've read that when automating Access reports from VB it is
recommended that developers put as much of the code as possible in Access
for performance reasons.  Assuming this is true, are there any issues when
distributing the VB app to end users that we should be concerned ...

I wonder if there is any possibility to generate reports in form such a
pivot tables and make them available on the web, would be great if users
would be able to work on it as on pivot table in excel, is it possible  ?
What would I need ?

I have a report based on a query ( 2 tables: one is tblEmployee the other is
tblCars)
The query lists an employee with 1 to 6 cars (1 to Many relationship).
I have precut 3x5 card stock from Rolodex and have setup the report page

For years using Access 97 a DLookup control source for a report has worked
perfectly.
However, in Access 2003/2000, it fails, returning a blank or #Error.
It is:   =DLookUp("[Company Name]","[tblShippers]","[Shipper ID]=[Ship

Can I export a Access 2002 report directly to a word format?

I am creating a report on which I want the user to be able to enter any date
that he sees fit as the report opens.  Is there a way for me to set the
proper properties so I can have this happen?

I have some reports that are set up vertically and for years I have been
printing them successfully on a number of HP Color LaserJet 4500 printers.
The 4500 are being replaced by 46xx [we got a 4600 a year or so ago and a
4650 today.] The 4600's don't rotate the font 90 degrees ...

If the record count for my report is a certain value, I want to supress the
report header and display only the detail section.
What object and property do I need to set to supress the report header?

On 19-12-2004 in an aswer to my same topic Mr. Ken Snell - MVP wrote the
following code for selecting a printer :
Set Application.Printer = Application.Printers("DeviceName")
Based on that I made a command Button and wrote the following code to select

==>Left([Measurements],InStr([Measurements],"X")-2) & "mm X " & Mid
     ([Measurements],InStr([Measurements],"X")+2) & "mm")
The above expression is used to add "mm" when user type a measurement from a
form and is preview in report

i have a report based on addresses of the people so it shows:
Name
Address
Zip Code code + city

Using Access 2002, my database is for single users, on their desktop
and is split (FE/BE).  I allow users to add fields to tblCustom via a
form and VBA.  It works great.  I use a query to combine the data from
tblCustom to related data in other tables.  To display the query in a