How do I make several form windows come up tiled?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several form windows that I want to show on the screen all at once,
without overlapping. I can move them around, but when I close and re-open
Access, they revert to coming up overlapping. How do I make a form (or query
or report) remember its location and size?
 
Research DoCmd.MoveSize in Access help, you can use it to set the location
and size of form windows.

Andrew Wrigley
 
Hi.

Each form and report has AutoResize and AutoCenter Properties. Set these to
No in the Properties dialog window. Move and resize the windows exactly
where you want them to be the next time you open them. Then select each
window in turn (so that it is currently the "active window") and select the
"Save" button in the toolbar, until you have saved the position and size of
all of these particular form, report, and query windows. Close the windows,
then open them. They'll remember where they were.

Alternatively, you could "tile" these windows, either horizontally or
vertically. For example, you could create a button on any (or all) of these
particular forms with the following code:

Private Sub TileWindowsBtn_Click()

On Error GoTo ErrHandler

RunCommand acCmdTileHorizontally

Exit Sub

ErrHandler:

MsgBox "Error in TileWindowsBtn_Click( ) in" & vbCrLf & _
Me.Name & _
" form." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & Err.Description
Err.Clear

End Sub

.. . . where every currently open window will be tiled horizontally, allowing
no overlaps. If you wanted to tile them vertically, then the RunCommand code
would be:

RunCommand acCmdTileVertically

If you want to tile them in "blocks," then the RunCommand code would be:

RunCommand acCmdTileHorizontally
RunCommand acCmdTileVertically

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top