[AccessD] How to Show a Specific Report atInitiationTime(Whenthere is also a default form)

Rusty Hammond rusty.hammond at cpiqpc.com
Tue Apr 17 13:11:45 CDT 2012


In the docmd.OpenReport try adding acDialog for the WindowMode parameter

DoCmd.OpenReport "YourReportName", acViewPreview, , , acDialog

Rusty 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, April 17, 2012 10:56 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How to Show a Specific Report
atInitiationTime(Whenthere is also a default form)

Interesting problem. How about Docmd.Close acForm,"MyForm" after the
DoCmd.OpenReport and then in the close event of the report
DoCmd.OpenForm to open whatever form should be shown?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Tuesday, April 17, 2012 8:35 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Show a Specific Report at
InitiationTime(Whenthere is also a default form)

Rocky,

Thanks for the help.

The catch is that when I put the DoCmd.OpenReport in the open event of
the startup form, the report is indeed opened, but it is not visible as
it sit "behind" the form.

The Report Tab is visible, the user request is to have the actual report
fully visible on the screen (they don't want to push the TAB).

Is there some way to shift things so that the Report is shown and the
Form sits behind it?


Brad 




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, April 17, 2012 10:31 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How to Show a Specific Report at Initiation
Time(Whenthere is also a default form)

You have an startup form, yes?  So can you put DoCmd.OpenReport in the
_open event of that form?

Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com
www.e-z-mrp.com
Skype: rocky.smolin
 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Tuesday, April 17, 2012 4:59 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to Show a Specific Report at Initiation Time
(Whenthere is also a default form)

All,

We have an Access 2007 application that is used  by a number of people.

The form that is automatically opened for this ap is a type of report
menu.

Recently a key player has asked that when the application is opened, he
would like to see one report automatically shown on the screen (without
needing to push any button or select any tab).

Is there a way to have a default form, and yet open a report and give it
the focus.

I know how to discern the user-id, that it not a problem.

The problem is that if I open up the report on the Form Load Event, the
report is opened, but only a tab is shown for the report, and the report
itself is not visible as it is covered by the default form.

I thought that this would be easy to do .  I must be missing something.

Thanks,
Brad

     



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************



More information about the AccessD mailing list