A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report



 
 
Thread Tools Display Modes
  #1  
Old May 22nd, 2010, 04:32 PM posted to microsoft.public.access.queries
turks67 via AccessMonster.com
external usenet poster
 
Posts: 34
Default Report

I'm trying to open Two reports with one command button. But everytime I click
the command button it
goes to the report2. How can I open report1 click until I get to the last
page on report1 then open report2. Is this possible.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1

  #2  
Old May 25th, 2010, 01:14 PM posted to microsoft.public.access.queries
vanderghast
external usenet poster
 
Posts: 593
Default Report

Maybe the easiest solution would be to open Report3 having Report1 and
Report2 as sub-report, if it is applicable in your scenario.

In the button click procedure, you can check to see if there is actually a
given report open, or not, using, among other possibilities:

if Application.SysCmd(acSysCmdGetObjectState, acReport, "myReportName") 0
then
DoCmd.OpenReport "myReportname", acViewPreview
else
DoCmd.OpenReport "otherReportName", acViewPreview
end if


(note that technically, you could also check to see if the second report is
already open).



Vanderghast, Access MVP


"turks67 via AccessMonster.com" u48755@uwe wrote in message
news:a863e41a87def@uwe...
I'm trying to open Two reports with one command button. But everytime I
click
the command button it
goes to the report2. How can I open report1 click until I get to the last
page on report1 then open report2. Is this possible.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.