Hi All!

Is it possible to export an Access Report? Not the report that is produced
when the report is run, but the actual framework, or source, of the report.
I'm trying to debug a report I didn't create, and in one field in the
GroupFooter, the Control Source property references another field, but I
cannot find the field referenced in the GroupFooter section, nor is it part
of the underlying query of the report, nor is there any VBA code associated
with the report that caould generate the field. I'd like to get the report
into some kind of text form, so that I could search. If there's another way
to solve this problem, I'd be happy to hear it.

Thanks in Advance,

Cheers,
Matt.

On Mon, 6 Oct 2003 14:35:30 -0400, "Matt."
<matt_benvenuti_remove@hotmail.com> wrote:
[color=blue]
>Hi All!
>
>Is it possible to export an Access Report? Not the report that is produced
>when the report is run, but the actual framework, or source, of the report.
>I'm trying to debug a report I didn't create, and in one field in the
>GroupFooter, the Control Source property references another field, but I
>cannot find the field referenced in the GroupFooter section, nor is it part
>of the underlying query of the report, nor is there any VBA code associated
>with the report that caould generate the field. I'd like to get the report
>into some kind of text form, so that I could search. If there's another way
>to solve this problem, I'd be happy to hear it.
>
>Thanks in Advance,
>
>Cheers,
>Matt.
>[/color]

The missing field/Control Source could be a textbox etc. from a form
that is open to run the report, like a combobox for customer name, or
a start date and end date froming criteria for the underlying query ?
Check the rest of the forms for fieldnames.. just a suggestion

f

Thanks Feck,

Unfortunately, the report is run directly from the Reports menu. It is not
called from a form, and no dialogue boxes are raised except for the one's
generated by the Report's Source (which do not affect the Footer).

I appreciate the quick reply though.

cheers,
Matt.

"feck" <nepaslespamdonkshop@hotmail.com> wrote in message
news:2gg3ov40p2i5aah3s0sc9i1k414n3argiv@4ax.com...[color=blue]
> On Mon, 6 Oct 2003 14:35:30 -0400, "Matt."
> <matt_benvenuti_remove@hotmail.com> wrote:
>[color=green]
> >Hi All!
> >
> >Is it possible to export an Access Report? Not the report that is[/color][/color]
produced[color=blue][color=green]
> >when the report is run, but the actual framework, or source, of the[/color][/color]
report.[color=blue][color=green]
> >I'm trying to debug a report I didn't create, and in one field in the
> >GroupFooter, the Control Source property references another field, but I
> >cannot find the field referenced in the GroupFooter section, nor is it[/color][/color]
part[color=blue][color=green]
> >of the underlying query of the report, nor is there any VBA code[/color][/color]
associated[color=blue][color=green]
> >with the report that caould generate the field. I'd like to get the[/color][/color]
report[color=blue][color=green]
> >into some kind of text form, so that I could search. If there's another[/color][/color]
way[color=blue][color=green]
> >to solve this problem, I'd be happy to hear it.
> >
> >Thanks in Advance,
> >
> >Cheers,
> >Matt.
> >[/color]
>
> The missing field/Control Source could be a textbox etc. from a form
> that is open to run the report, like a combobox for customer name, or
> a start date and end date froming criteria for the underlying query ?
> Check the rest of the forms for fieldnames.. just a suggestion
>
> f[/color]