Declarations in Modules

[chrisse_2]

Hey,

Can somebody help me, I've been trying to locate a reports
'recordsource'. The reports 'On Open' event writes Me.RecordSource =
ReportFixtureSpecControlSource.

I went searching for this and found it in one of the Modules in access.
It says 'Public ReportFixtureSpecControlSource'

The problem is i need to know what the recordsource for the report is
so i can add to it.

Thanks for your help.

Christina

[w_a_n_n_a_l_l_ -]

If there are no parameters called for in the definition line (Public
ReportFixtureSpecControlSource) you can go to any module, type control-G to
go the immediate window and type this:

?ReportFixtureSpecControlSource

and press return.

Presumably the function returns a string that can be used as the
recordsource for a report.

[chrisse_2]

Hey,

Thanks for the reply. I did what you said and nothing happened. Any
other suggestions?

[pietlinden]

ch*******@hotmail.com wrote:

Hey,

Thanks for the reply. I did what you said and nothing happened. Any
other suggestions?

Well, that's your problem. Your report has no recordsource, because
the function isn't returning a value. How about posting the code for
this function.

(Hey Randy, your psychic abilities working? Mine aren't...)

[chrisse_2]

pi********@hotmail.com wrote:

ch*******@hotmail.com wrote:

Hey,

Thanks for the reply. I did what you said and nothing happened. Any
other suggestions?

Well, that's your problem. Your report has no recordsource, because
the function isn't returning a value. How about posting the code for
this function.

(Hey Randy, your psychic abilities working? Mine aren't...)

Hey,

The problem is that i can't find that function anywhere else. I didn't
make this database but i have to add linked images to the report. I
can't get the image control to work properly without adding code to the
recordsource.

Also, i know this maybe a really silly question but i can't work it out
at the moment, all this code is starting to get to me! When you add an
image control to a report you write code into the forms on current
event. As a report has no on current event, where would you place the
code?

Thanks, sorry for the vagueness the code in this database is really
messy!

Cheers

[Terry Kreft]

This is a classic tracing operation.

I'll start from the beginning.

On the line
Me.RecordSource = ReportFixtureSpecControlSource.

Click on the word ReportFixtureSpecControlSource and press Shift-F2 on the
keyboard.
The focus will jump to the declaration of ReportFixtureSpecControlSource.

The declaration will either be a function, a const (unlikely in this case)
or a variable.

If it is a const then your search is finished as the value is declared.

If it is a function then you just need to read and understand the function
in order to determine the value.

If it is a variable then you can then do a search on the phrase
"ReportFixtureSpecControlSource =" (note the space between the variable and
the = sign), this will then show you all the places where the variable has
been set to a value.

--

Terry Kreft
<ch*******@hotmail.com> wrote in message
news:11**********************@y41g2000cwy.googlegr oups.com...

Hey,

Can somebody help me, I've been trying to locate a reports
'recordsource'. The reports 'On Open' event writes Me.RecordSource =
ReportFixtureSpecControlSource.

I went searching for this and found it in one of the Modules in access.
It says 'Public ReportFixtureSpecControlSource'

The problem is i need to know what the recordsource for the report is
so i can add to it.

Thanks for your help.

Christina

[Rick Wannall]

In your code, click on the name of the function. Then press shift-F2. You
should land in the function. Copy the code and paste it here.

[Larry Linson]

<ch*******@hotmail.com> wrote

Also, i know this maybe a really silly
question but i can't work it out at the
moment, all this code is starting to get
to me! When you add an image control
to a report you write code into the forms
on current event. As a report has no on
current event, where would you place the
code?
In a Report, you place in the Report's OnPrint event similar code to what
you'd place in the Form's OnCurrent.

To verify that the Report does or does not have a defined RecordSource (in
addition to whatever is being set from code), open the Report in Design
View, click the upper-leftmost little square, choose Properties, click the
Data tab in the Property dialog, and the first item is the pre-defined
Record Source of the Report (if any).
The reports 'On Open' event writes
Me.RecordSource =
ReportFixtureSpecControlSource. I went searching for this and found it in
one of the Modules in access. It says
'Public ReportFixtureSpecControlSource'
I'd wager there is more to that declaration... like an "As String" clause?
This is the variable in which a string is created that will be set into the
Report's RecordSource by the first code you cited.
The problem is i need to know what the
recordsource for the report is so i can
add to it.

Now you need to search for "ReportFixtureSpecControlSource" to see what is
set into that variable to be later moved into the RecordSource of the
Report. It might be done in a Standard Module, or might be done in a Form's
Module.

Larry Linson
Microsoft Access MVP
Larry Linson
Microsoft Access MVP

[chrisse_2]

Thanks for all your help. I found the recordsource for the report in
another form. By the way when i pressed Shift-F2 nothing happened. The
report works perfectly now, i am greatly appreciative.

Christina

[Terry Kreft]

You did it wrong then.

--

Terry Kreft
<ch*******@hotmail.com> wrote in message
news:11*********************@h76g2000cwa.googlegro ups.com...

<SNIP> By the way when i pressed Shift-F2 nothing happened. <SNIP>

Christina