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

Selasa, 29 November 2011

RE: [MS_AccessPros] Check if report is open

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