[AccessD] Jumping Screen

Jim Lawrence accessd at shaw.ca
Sat Apr 21 10:13:08 CDT 2012


Sorry about that...I told I hadn't done anything in Access for a while...now
if you help on a web page to do the same thing!? :-)

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, April 20, 2012 8:33 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Jumping Screen


Application.WindowState = wdWindowStateMaximize  won't compile - says
wdWindowStateMaximize is not defined.  When I replace wdWindowStateMaximize
with 2 then .WindowsState method or data member not found.

In ActiveWindow.View.FullScreen = True compiler says .View is an invalid
qualifier.

An alternative to DoCmd.Maximize has promise - maybe another method of
maximizing will stop those last two Resizes.  But I need some syntax that
the compiler likes.

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, April 20, 2012 10:15 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Jumping Screen

Have you tried the direct methods of(?):

Application.WindowState = wdWindowStateMaximize ...or...
ActiveWindow.View.FullScreen = True
...or
MySplashPage.Height = SysInfo1.WorkAreaHeight MySplashPage.Width =
SysInfo1.WorkAreaWidth MySplashPage.Top = SysInfo1.WorkAreaTop
MySplashPage.Left = SysInfo1.WorkAreaLeft ...and then center the your form

I have not tested this as it has been a while since I have done anything in
Access.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, April 20, 2012 7:49 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Jumping Screen

Dear List:
 
This is getting serious now.  I made some changes to my A2003 product to fix
the problem of some of the forms not opening centered and maximized when
running the A2003 mde in A2007 and A2010. That problem is solved.
 
But now the forms jump unacceptably when the form is opened in the mde
version.
 
I tried to track it down by seeing if there's an event that's causing it.
So I put message Boxes in all the likely suspect events in just one form -
the Main Menu (figure if I can solve for this one form, I can do all).
 
Now in this application, whenever I go to a new form I close the calling
form - stops the user from navigating the open windows instead of my
carefully crafted menus. :)c
 
The ADH code for  resizing and other housekeeping functions is in the Open
event (I tried moving this to the Load event - no difference).  None of the
other events mentioned here have code except for the MsgBox.  When I open
the Main Menu then, here's the sequence of events:
 
Open
Resize
Load
Resize
Activate
Got Focus
Resize (after this one, the form actually appears) Lost Focus Current (no
record source on this menu - just a menu - at this point, part of the screen
shifts) Resize (big screen shift upwards) Resize (big screen shift
downwards)
 
So it's those last two resize events that are causing the jumping problem.
In the mdb - not so much.  In the mde - unacceptable.
 
Biggest problem - I don't know how to stop this behavior.
 
Any ideas are welcome.
 
MTIA
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
<http://www.e-z-mrp.com/>
Skype: rocky.smolin
 

--
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



More information about the AccessD mailing list