| re: Second Request - Can I return a value from an ACCESS report to VB?
Great ideas.
Thank you.
On Tue, 06 Sep 2005 18:18:12 -0700, Tom van Stiphout
<no.spam.tom7744@cox.net> wrote:
[color=blue]
>On Mon, 05 Sep 2005 19:35:56 GMT, Greg <gteets99@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.
>
>
>[color=green]
>>On Sun, 04 Sep 2005 22:14:32 -0700, Tom van Stiphout
>><no.spam.tom7744@cox.net> wrote:
>>[color=darkred]
>>>On Mon, 05 Sep 2005 04:17:42 GMT, Greg Teets <gteets99@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[/color]
>>
>>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[/color][/color]
| 
