Info on Report

[PeterM]

I have a report that is based on Table A. It's working great. However, I
need to place information from Table B in the header of the report. Table B
only contains one row with name, address, phone number, etc as the columns.
I setup a listbox for each column to retrieve with the required SQL as the
Row Source. It works great but it puts a border around each listbox when it
prints. I've tried changing the border to transparent and it does nothing.

Is there an easy way to remove the borders around the listbox, or another
way to get the info on the report header?

Thanks in advance for your help.

 

[Guest]

I have a report that is based on Table A. It's working great. However, I
need to place information from Table B in the header of the report. Table
B
only contains one row with name, address, phone number, etc as the
columns.
I setup a listbox for each column to retrieve with the required SQL as the
Row Source. It works great but it puts a border around each listbox when
it
prints. I've tried changing the border to transparent and it does
nothing.

Is there an easy way to remove the borders around the listbox, or another
way to get the info on the report header?

Thanks in advance for your help.

 

[Tom Wickerath]

You can specify expressions as text box control sources, using the Domain
Aggregrate function DLookup. Something like this:

=DLookup("[FieldName]", "[TableName]", "Criteria")

In this case, you would not need the optional criteria statement, since your
table has only one record.

Easier yet, why not use a query for your report's record source that
includes this one record table? Since this table consists of only one record,
a resulting cartesian product (assuming no suitable way of joining the
fields) would still return the same number of records, because any number
multiplied by one (1 record) is the same number. Thus, you could add this
table to the query, add the needed fields, and now presto, they're available
in the field list in the report. You would only experience a problem with
this setup if you later added one or more records to the single record table.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[John Spencer]

If you need to have this same information in multiple reports, you might
consider using a sub-report.

Create a simple report based on Table B that displays the information in the
format you want.

Now use that report as a sub-report in the header of your report(s). One
result is that changing the Table B based report automatically updates all the
reports it is used in.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County