[AccessD] Report not on top

Rocky Smolin rockysmolin at bchacc.com
Fri Dec 21 11:52:29 CST 2012


Fixed.  The condition was - before running the report the program checked a
condition and if it was true did some stuff and then called the Save Record
subroutine.  SO I just changed the call to the Save routing to
DoCmd.RunCommand acCmdSaveRecord and it works.  The stuff that's being
checked in the save record routine is not necessary at this point.

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Friday, December 21, 2012 9:28 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Report not on top

Make sure the calling form doesn't have its Border Style set to Dialog.


On Thu, Dec 20, 2012 at 5:56 PM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:
> Dear List:
>
> I have a report that is run in Preview mode from a calling form.  
> Under certain conditions, which I can replicate, the report opens in 
> preview but the calling form is on top of the report - that is, Window 
> 1 - db container, Window 2 - Main Menu, Window 3 - calling form, 
> Window  4 - report in Preview.
>
> If I run the report in preview the report seems not to run but if I 
> pull down the Window menu I see the report there as Window 4 and can 
> click on it and see it.
>
> Problem is 1) I don't know why that is happening, and 2) if I knew how 
> to force Window 4 to the top I'd just do that, but I don't.
>
> Is there some way to select the window you want on top?  It may not 
> always be window 4 depending on how they get to the calling for.  I'd 
> like to specify it by the report name if possible.
>
> MTIA
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list