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 / Reports / Printing / October 2005

Tip: Looking for answers? Try searching our database.

Maximize?????????

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Derek Brown - 29 Oct 2005 01:05 GMT
Hi All

I have a pop up that when closes leaves the main form not maximized. Why the
main form does not stay maximised I do not know. This sometimed happens when
the report which gets parameters from the  pop upform is minimized. This
effects the state of the main form (Why???) I have searched help and the
best I got was:

Private Sub Form_Close()
   DoCmd.SelectObject acForm, "FormName", True
   DoCmd.Restore
End Sub

Or:

Private Sub Form_Close()
   DoCmd.SelectObject acForm, "FormName", True
   DoCmd.Maximize
End Sub

But all that happens is the Database window maximizes and leaves the Main
Form (FormName) not maximized..

Help

P.S. is there a proper word for "Not Maximised"? (as if it's a life
threatening problem).
Marshall Barton - 29 Oct 2005 05:28 GMT
>I have a pop up that when closes leaves the main form not maximized. Why the
>main form does not stay maximised I do not know. This sometimed happens when
[quoted text clipped - 19 lines]
>P.S. is there a proper word for "Not Maximised"? (as if it's a life
>threatening problem).

I don't know if this accounts for all the problems, but the
last argument of True means you are working in the database
window.  If you want to operate on an open form, it should
be False.

The word for not maximized and not minimized is restored, as
in:
    DoCmd.Restore

Signature

Marsh
MVP [MS Access]

Derek Brown - 31 Oct 2005 17:19 GMT
Hi Marshall

Well you got me there. Why it should be DoCmd.SelectForm = "False" and not
"True" is beyond me but you are right it works.

Thank you

>>I have a pop up that when closes leaves the main form not maximized. Why
>>the
[quoted text clipped - 30 lines]
> in:
> DoCmd.Restore
 
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.