OK, I feel stupid.
I writing code to conditionally change the back color of a field on a report
detail line.  When I attempt to write something like this -
Me.txtBox.BackColor = 302, I type me. and I get a drop down of my text boxes

Has anyone written a general query and reporting mechanism in Access?
By this I mean a system where the user chooses a table or tables and the
columns of interest, specifies control breaks and the Access program itself
writes and runs the report dynamically.

Here's my question.  I am using reports for form letters and so far they have
been working great.  I am using unbound text boxes for the body of the letter
and using things such as & [Agent Name] & "is scheduled to " etc....  Where
[Agent Name] is a field in a table and ...

  I have a report where a price prints ($1.99). There are some prices
where the dollar amount is 2 digits ($19.99). I need the dollar sign to
print to the left of the fist dollar number. My problem is that I
can't find any way to tell a report to push the dollar symbol to the

I'm a beginner.  So, please be 'gentle'...
I have a report that lists all of the records I need.  It also includes a
counter to the left of the records.  At the bottom of a report I need to
display the Record Count x Price = Total.

I made a data list, and some data may miss 1 or 2 sections. I code it to
change its visible in the report. The item is insivible in the report page.
However, when I sum its value. The sum function still add the insivible
value. How do I avoid this?

Hi fellas!
I have a report with no datasources (because of some subreports that are in
it).
I'm trying to insert a text box with the following statement:

I have a complicated report which has a grouping option where a heading,
subheading and text item will print together.  If they can't fit at the
bottom of the page, the whole group is printed on the following page.  
Problem is, sometimes the text item is really long and it could ...

I have a form on a report and when I try to link the master/child fields I am
getting the following error:
can't build a link between unbound forms
The report is based on a query that has 2 tables linked together by ID#.  

I´m looking for a labelprinter; I want to print single labels including
barcode (Code39).
*** The label printer must work with Access 2003 on a Terminalserver 2003(!!!)
.***

How can I make my report header to print on all my pages? Currently, it will
only show on the first page. I'd like to see it in all the other pages.
Any ideas?
Thanks,

Good Day
In Access 2003 is there a preferred image format for reports. I inserted a
.gif logo that has a size of 51KB and my database blew up by 3MB's! I have
tried different graphic formats with similar or worse results.

What is the best way to create a report that is based upon a recordset in
another database that has security implemented?
Arlene

My database creates snapshot files and saves them to a folder.  For some
reason I'm now unable to view the .snp files.  I've done a repair and then a
reinstall of Office XP and still the files wont open.  Immediately after the
reinstall I got it to open a particular file once ...

I have a report derived from a single record consisting of  a page header
plus a detail section consisting of 40 to 50 textboxes whose pupose is to
produce a formated print for posting to the customer. The contents of the
textboxes are derived from memo fields or VBA functions which ...