ACCESS FEED: Re: [MS_AccessPros] Check if report is open

Selasa, 29 November 2011

Re: [MS_AccessPros] Check if report is open

Thanks! Connie

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Connie-
>
> This is simple off the top of my head:
>
> Public Function ReportIsOpen(strReportName As String) As Integer
> Dim strReportName As String
> On Error Resume Next
> strReportName = Reports(strReporName).Name
> If Err <> 0 Then
> ReportIsOpen = False
> Else
> RepotIsOpen = True
> End If
> End Function
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> Sent: Tuesday, November 29, 2011 6:25 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Check if report is open
>
> How would I create a module to check if a report is open?
>
> Thanks!
> Connie
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>