By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,617 Members | 1,792 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,617 IT Pros & Developers. It's quick & easy.

in which report object event does a certain activity occur?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.