Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / December 2007

Tip: Looking for answers? Try searching our database.

Maximized Window Look Problems

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
E.Q. - 27 Dec 2007 00:54 GMT
Greetings,
I'm trying to polish up a database and thought I'd try to do some cosmetic
things. First, I have a start form (frmStart) that looks good as designed;but
when called from a form or report on a maximized window it would also show up
maximized.  I found the "Popup" property and set that to yes but now whenever
I call up a report or form from frmStart, frmStart remains on top, blocking
the object I was trying to open. Am I missing a property somewhere or will I
need to put a bit of code in to make sure frmStart gets out of the way when
another object is called up.
Another question regarding Maximized window: the Help screen directed me to
the DoCmd.Maximize command and I inserted that so reports open on a more
readable screen.  I'd like to orient the sheet so the user sees the form at
the upper left.
As I reread this I realize the connection between the two issues may seem a
bit tenuous, please forgive the "two-for-one" shot, but I have a hunch that
both issues will be quite simple for an experienced developer to solve.
Peace
EQC
boblarson - 27 Dec 2007 05:39 GMT
This is what I do, I put this in each report's On Open event:

DoCmd.Maximize

And then in the On Close event of each report:

DoCmd.Restore

So, you can then leave your forms sized as is and then when they close the
reports it resets things back to their pre-maximized size.
Signature

Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

> Greetings,
> I'm trying to polish up a database and thought I'd try to do some cosmetic
[quoted text clipped - 14 lines]
> Peace
> EQC
E.Q. - 27 Dec 2007 22:31 GMT
Thank you...
I had a hunch it wouldn't be the most complicated of problems to solve, Mr.
Larson.  Your solution is simple and thus elegant.
Regards,
EQC
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.