okacs
asked on
Ms Access Database windows opens off screen
I've used MS Access for years, but never figured this one out:
Sometimes (though rarely) when I am in an MS Access database with a form open, and I press F11 to open the Database window, it appears to do nothing. Upon closed inspection, the horizontal & vertical scroll bars have appeared and jumped in size like 100x. So I scroll all the way to the right & down (or left and up) and eventually find the database window.
Why does this happen?
Is there a way to prevent this?
Once it has occurred, is there a fast way to move it to the same screen area as my form so that the scroll bars disappear?
(because dragging it to the edge 100x to move it really sux)
Thanks..
Sometimes (though rarely) when I am in an MS Access database with a form open, and I press F11 to open the Database window, it appears to do nothing. Upon closed inspection, the horizontal & vertical scroll bars have appeared and jumped in size like 100x. So I scroll all the way to the right & down (or left and up) and eventually find the database window.
Why does this happen?
Is there a way to prevent this?
Once it has occurred, is there a fast way to move it to the same screen area as my form so that the scroll bars disappear?
(because dragging it to the edge 100x to move it really sux)
Thanks..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry I was leaving this ticket open in the hopes that someone could tell me the exact registry setting. But yes, the Windows/Casdcade works fine - I just didnt want to have to do that every time...
I will split the points myself... Thanks!
I will split the points myself... Thanks!
For what it's worth there is also another method but it's not nearly as good. A user can Select the Window menu and select objects within the Window. They can then subsequently hide them. Unfortunately this will not exactly solve the problem and worse give the illusion that it has. For example, where the DBC (Database Window) concerned the user could drive them nuts showing then hiding the window. Since neither repossitions the Window their only options are to Select Window > Cascade OR Window > Tile. Personally I prefer the Window Cascade option. In the case of Forms and Reports they can be more illusive. If set to display in the center when opened all may appear fine until the user opens them to or changes the view to Design View. In this case the old position will be remembered and the same problem again manifests itself. The same is true for Reports although Reports can be opened a little differently than forms the same issues apply.
At the end of the day there are three choices...
1) Select Window > Cascade
2) Select Window > Tile
3) Increase the resolution to the size used to create the problem then shrink each window within a space viewable at the lower resolution before reducing things down to that resolution (which will not be easy if you're not good with screen resolutions).
My personal favorite... Option 1. As I said, Sahmeepee had it right from the start, I simply offered the answer as to why... Why Does it work, Why is it need, What alternatives are there and What can be done to avoid the issue entirely which could be very important if one absolutely hand an .mdb off to a client or user of lesser experience who will not know either of the first two tricks previously mentioned.
Rick