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

Second Request - Can I return a value from an ACCESS report to VB?

P: n/a
I am running an Access report from VB via ADO.

The report has a field that shows the time it was run.

Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?

Thank you.

Greg Teets
Cincinnati OH USA
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Mon, 05 Sep 2005 04:17:42 GMT, Greg Teets <gt******@yahoo.com>
wrote:

Or use VB's Now() function:
RunAccessReport()
Msgbox "Report time: " & Now()

-Tom.

I am running an Access report from VB via ADO.

The report has a field that shows the time it was run.

Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?

Thank you.

Greg Teets
Cincinnati OH USA


Nov 13 '05 #2

P: n/a
On Sun, 04 Sep 2005 22:14:32 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Mon, 05 Sep 2005 04:17:42 GMT, Greg Teets <gt******@yahoo.com>
wrote:

Or use VB's Now() function:
RunAccessReport()
Msgbox "Report time: " & Now()

-Tom.

I am running an Access report from VB via ADO.

The report has a field that shows the time it was run.

Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?

Thank you.

Greg Teets
Cincinnati OH USA


How can I verify that the report actually ran before posting the time?

Maybe I have to do this in the Access side, but I would like VB to
verify that the report ran and then display the time. Can I return a
"completion" code to VB?

Thanks.
Greg
Nov 13 '05 #3

P: n/a
On Mon, 05 Sep 2005 19:35:56 GMT, Greg <gt******@yahoo.com> wrote:

Well, DoCmd.OpenReport WILL open the report, so in a sense it ran.
Perhaps you have some code in the Report_Open event to cancel the
report if the user has insufficient rights to see the report. You
could use a global variable to signal that back to the calling
function.
Perhaps you have some code in the Report_NoData event. The same
applies.

Otherwise I don't know what you mean, and you may need to elaborate.

-Tom.
On Sun, 04 Sep 2005 22:14:32 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Mon, 05 Sep 2005 04:17:42 GMT, Greg Teets <gt******@yahoo.com>
wrote:

Or use VB's Now() function:
RunAccessReport()
Msgbox "Report time: " & Now()

-Tom.

I am running an Access report from VB via ADO.

The report has a field that shows the time it was run.

Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?

Thank you.

Greg Teets
Cincinnati OH USA


How can I verify that the report actually ran before posting the time?

Maybe I have to do this in the Access side, but I would like VB to
verify that the report ran and then display the time. Can I return a
"completion" code to VB?

Thanks.
Greg


Nov 13 '05 #4

P: n/a
Great ideas.

Thank you.
On Tue, 06 Sep 2005 18:18:12 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Mon, 05 Sep 2005 19:35:56 GMT, Greg <gt******@yahoo.com> wrote:

Well, DoCmd.OpenReport WILL open the report, so in a sense it ran.
Perhaps you have some code in the Report_Open event to cancel the
report if the user has insufficient rights to see the report. You
could use a global variable to signal that back to the calling
function.
Perhaps you have some code in the Report_NoData event. The same
applies.

Otherwise I don't know what you mean, and you may need to elaborate.

-Tom.
On Sun, 04 Sep 2005 22:14:32 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Mon, 05 Sep 2005 04:17:42 GMT, Greg Teets <gt******@yahoo.com>
wrote:

Or use VB's Now() function:
RunAccessReport()
Msgbox "Report time: " & Now()

-Tom.
I am running an Access report from VB via ADO.

The report has a field that shows the time it was run.

Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?

Thank you.

Greg Teets
Cincinnati OH USA


How can I verify that the report actually ran before posting the time?

Maybe I have to do this in the Access side, but I would like VB to
verify that the report ran and then display the time. Can I return a
"completion" code to VB?

Thanks.
Greg


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.