Solved

Minimized Database Container Window

Posted on 2012-03-22
9
531 Views
Last Modified: 2012-03-23
I have a form that when maximized, it take up the entire screen and the users and I like it that way. However, when the form is minimized, the database container window shows. I would like to know of a way when the form is minimized, the database container window is also minimized or hidden. I’ve tried to hide the database window, but the container windows still shows. I’ve saw this link Find out if the database container window is currently visible but it only tell me if the container window is showing and I already know it is.
0
Comment
Question by:stevensont
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37755477
which window do you want to hide..
the database objects window or the Access Window?

to hide the Access window
http://access.mvps.org/access/api/api0069.htm

to hide the database object window
http://access.mvps.org/access/general/gen0031.htm


    To show the database window, run
        Docmd.SelectObject acTable, , True

    To Hide the database window, run
        Docmd.SelectObject acTable, , True
        Docmd.RunCommand acCmdWindowHide
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 475 total points
ID: 37755731
To Hide the application window, see here:
http://access.mvps.org/access/api/api0019.htm

Just note that it works, but these techniques were always "Workarounds" at best.

Then contain lots of ways that the user can accidentally  "freeze" the screen, ..etc
Then what?

You can also "Dim" the application window:
http://blogs.office.com/b/microsoft-access/archive/2008/04/28/modal-dialogs-with-transparent-backgrounds.aspx


But as Expert LSM consulting always says:
   "If you really want the application window hidden, develop the app in a standalone programming environment (vb6, .net, ...etc)
0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 25 total points
ID: 37756539
Should this form be maximized whenever the users are viewing it?

If so, can you simply disable the Max/Min buttons in the form's property sheet so that the user is has to use the max/min buttons in the main database window?  With that setup, the form and the database window would automatically maximize/minimize/restore together.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:stevensont
ID: 37756558
boag2000: from what I've read, it seems like  Manipulate Access Window will work. Now I'm wondering what event to use to trap the form's minimize/maximaze event to place the code behind it. Any ideas?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 475 total points
ID: 37757212
Again, I have never bothered with this because of all the "caveats"

It is just one of those things that seems like it would be cool, but when your users start seeing odd things happen with the screen, .... Then what?
will you download more complex API code to fix it...?

...Or it does not work with Win 7, ...or it does not work with 64 bit OS, ...or it only works if you do X, then Y, then add in a vba reference to Z... Or does not work for Dual monitors, or wont work with the new "widescreen" resolutions, ...or MS deprecates this ability...
Besides, hiding the Application window make users thing that closing the current Form will close the app...
...and on and on...

Like the LSMConsulting quote, ...if i really "Need" this, then I wouldn't develop it in access...

Just was never worth it to me.
There is a lot of things to consider and go through, for a feature that only seemed "cool"...
...and had no real benefit, ...in fact caused more issues...

I just tun off all the Ribbons and toolbars in my app and provide forms for everything, so having the access window is no big deal.

This is a decision you will have to make as the developer.

Perhaps capricorn1 has had a better experience with this than me...
He can probably go into more detail than I can...

JeffCoachman
0
 

Author Closing Comment

by:stevensont
ID: 37757750
Jeff, you’re absolutely right. I’ve tried several different functions in Access and they’ve turned out to be more problems than they’re worth. I think my best bet would be to make the form fit inside the Access container window and use Access’ minimize/maximize buttons instead. Although the form looks cool the entire screen size, I never had one extend beyond the Access container window before. I don’t have time to play with all the other stuff. Thanks for getting me back on track. I think this entire application should be redeveloped in something different. Thank!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37758124
Yeah,

As I stated, it does work...

I think I would rather go with the "Dimmed" look though...
0
 

Author Comment

by:stevensont
ID: 37758656
Just to let you know for future reference, I turned off popup, hide both the ribbon and  database object window on the form and now when I minimize the form the entire database also minimizes. I still have the wonder look of the form taking up the entire screen...wonderful...who would have known it was so simple. I'm going to use the dimmer in another application that I think it would be great. Thanks a lot and peace be with you.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37758722
<I still have the wonder look of the form taking up the entire screen>

yes, that is what I was referring to...

Enjoy the weekend
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question