check report is open
in [General]
|
Prev: Access 2007 with Vista
Next: Douglas Steele, Arvin Meyer, Tony Toews, John Spencer, DuaneHookum, Allen Browne, etc
From: Sue on 26 May 2010 11:05 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
From: Douglas J. Steele on 26 May 2010 11:32 Application.CurrentProject.AllReports("NameOfReport").IsLoaded -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Sue" <sportybabesue(a)hotmail.co.uk> wrote in message news:%23JRCfTO$KHA.5292(a)TK2MSFTNGP06.phx.gbl... > 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 >
From: Sue on 26 May 2010 11:47 Thanks, great as ever :-) "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message news:udPb2iO$KHA.5464(a)TK2MSFTNGP05.phx.gbl... > Application.CurrentProject.AllReports("NameOfReport").IsLoaded > > -- > Doug Steele, Microsoft Access MVP > http://www.AccessMVP.com/DJSteele > (no e-mails, please!) > > "Sue" wrote in message news:%23JRCfTO$KHA.5292(a)TK2MSFTNGP06.phx.gbl... >> 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 >> > >
From: Daniel Pineault on 27 May 2010 17:23 You could do something like: If CurrentProject.AllReports("YourReportName").IsLoaded = 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 > > > . >
From: �ο� on 31 May 2010 02:10
���� "Sue" <sportybabesue(a)hotmail.co.uk> д����Ϣ����:%23JRCfTO$KHA.5292(a)TK2MSFTNGP06.phx.gbl... > 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 > |