If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
check report is open
Hi all
I want to check if a report is open before running a bit of code on another report, is there a command to easily check for this? Thanks, Sue |
#2
|
|||
|
|||
check report is open
Application.CurrentProject.AllReports("NameOfRepor t").IsLoaded
-- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Sue" wrote in message ... Hi all I want to check if a report is open before running a bit of code on another report, is there a command to easily check for this? Thanks, Sue |
#3
|
|||
|
|||
check report is open
Thanks, great as ever :-)
"Douglas J. Steele" wrote in message ... Application.CurrentProject.AllReports("NameOfRepor t").IsLoaded -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Sue" wrote in message ... Hi all I want to check if a report is open before running a bit of code on another report, is there a command to easily check for this? Thanks, Sue |
#4
|
|||
|
|||
check report is open
You could do something like:
If CurrentProject.AllReports("YourReportName").IsLoad ed = True Then 'If you are here, the report is currently open End If -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "Sue" wrote: Hi all I want to check if a report is open before running a bit of code on another report, is there a command to easily check for this? Thanks, Sue . |
Thread Tools | |
Display Modes | |
|
|