468,244 Members | 1,875 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,244 developers. It's quick & easy.

in which report object event does a certain activity occur?

Apologies in advance...I'm sure this is a trivial question...

Access 97.

Situation is this:
1. VBA code sets the recordsource property of a report object; the
recordsource is a querydef which is an SQL Server stored procedure
2. VBA code does DoCmd.OpenReport specifying the report whose
recordsource property was set as described in #1
3. report opens/displays as expected

My questions are:
1) at what point in the process does the stored procedure get
invoked?
2) does the stored proc get invoked as soon as the report object's
recordsource property get set? (based on what I observed when stepping
through in debu, I'm guessing it does NOT get invoked when the
recordsource property gets set)
3) does the stored proc get invoked in one of the report object's
events that fire when the DoCmd.OpenReport statement gets executed?
If so, which event: Open, Load, Activate, Current?

Thank you.

Feb 22 '08 #1
1 1624
On Fri, 22 Feb 2008 09:42:34 -0800 (PST), mi************@yahoo.com
wrote:

1: I'm pretty sure it's when you open the report, after the Open event
and before the Load event. Step through your code in the debugger, and
have SQL Server Profiler running at the same time.
Then report back to us so we can all learn.

Thanks,

-Tom.
>Apologies in advance...I'm sure this is a trivial question...

Access 97.

Situation is this:
1. VBA code sets the recordsource property of a report object; the
recordsource is a querydef which is an SQL Server stored procedure
2. VBA code does DoCmd.OpenReport specifying the report whose
recordsource property was set as described in #1
3. report opens/displays as expected

My questions are:
1) at what point in the process does the stored procedure get
invoked?
2) does the stored proc get invoked as soon as the report object's
recordsource property get set? (based on what I observed when stepping
through in debu, I'm guessing it does NOT get invoked when the
recordsource property gets set)
3) does the stored proc get invoked in one of the report object's
events that fire when the DoCmd.OpenReport statement gets executed?
If so, which event: Open, Load, Activate, Current?

Thank you.
Feb 23 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Charles A. Lackman | last post: by
5 posts views Thread by Tom Louchbaum | last post: by
1 post views Thread by Nathan Bloomfield | last post: by
3 posts views Thread by deejayquai | last post: by
2 posts views Thread by Nelson | last post: by
12 posts views Thread by Andrew Poulos | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.