I am trying to create a database whose record source is a SQL stored
procedure.  I have created a SQL Pass-Through query to retrieve the records:
EXEC CR_ORDERVIEW2
where CR_ORDERVIEW2 is the stored procedure.

this is the event procedure:
Private Sub Detail_Format (cancel as integer, formatcount as integer)
If qrythingsnotworking![brakes] = "no" then
                             rptthingsnotworking [brakes].visible = true

I have posted before but got no responses. This must be easily fixed and
have been experienced beofre. I have a hyperlink field in a form, and I have
built a report which when run extracts the data from the current form (and
subforms) and outputs to a

Firstly, thanks to Duane Hookom. I refered Duane Hookom's Crosstab.mdb and
created a dynamic crosstab report.
In the "Level Header" section of the main report, there is a column headings
which comes from a subreport. The subreport has a label whose control source

I have a form that will only hold 8 detail records per page to retain
formatting.  If there are more than 8 detail records, the formatting spans
pages which I do not want.  I need to know when I am at 8 records, print the
footer, page break and create a new header, and resume ...

I have a report in which I am attempting to calculate elapsed time. One being
the start of work on a job, the second being the completion of the job. The
start time and the end time are entered through a form which creates a record
for each event. In my report I group the two ...

I have a report on which I want to print only 8 detail records per page.
This is a form and currently, if there are more than 8 detail records, it
messes up the formatting moving it to a second page.

I'm working on a database, specifically on a special report that I want to
be a sample letter. This letter will be sent to  differenbt people and some
of the fields will change in order to meet each of its adressees details. My
question is, how do I make a formatted text and ...

The Ol'  Running sum per column thingy.......
.....I figured I'd let you know I got it working with this.....
.....if I go from page 1...then right to page 6...it'll give me the
totals right away.....

Hi, I am doing something wrong. I put in a text box to display a total, but
is is displaying the total of the first line of date.... So Jim had a service
on 10/01/04 and 10/04/04 for 1 hour each.  It shows one field that adds the
minutes and I want to take those minutes and ...

I'm trying to create a print button that will print a report based on which
check button field is true.

In a group footer section on a report, I have an ID that I need to create a
subreport for.  The subreport is based on a cross-tab query.  And since the
results of the query will change based on that ID I need to be able to create
a subreport on the fly.  The number of controls ...

I want to include a field that will retun an * next to a field if that field
is <,>,= X value. I don't know the proper expression, any thoughts? Thanks

I have used a macro to hide certain data rows in my report; however, this
leaves a blank line where that data would have been.  Is there a way to
collapse that portion of the report to eliminate the blank spaces?

I have a report that lists products with a report footer
at the bottom which sums product sales.  It is called sum
(sumofamount).  I then imbedded a subreport that contains
shipping.  I didn't link the two though but I have a