A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Maximized and Docked forms in Access?



 
 
Thread Tools Display Modes
  #1  
Old May 2nd, 2008, 11:56 PM posted to microsoft.public.access.forms
Max Moor
external usenet poster
 
Posts: 148
Default Maximized and Docked forms in Access?

Hi All,

I'm building a new Access 2002 runtime app, and I want a different look
and feel than I've had in the past.

When the program opens, I want a navigation pane to open on the left
side that is essentially docked there. It's not closeable and not moveable
or resizeable.

When the various forms and reports open, I want them to do so always
maximized in the remaining space, preferably with just a close button. I
don't want the forms to be minimizeable, moveable, or sizeable, just
closeable.

Is there an easy way to make a form do either of these things?

Regards,
Max
  #2  
Old May 3rd, 2008, 01:11 AM posted to microsoft.public.access.forms
Damon Heron[_2_]
external usenet poster
 
Posts: 237
Default Maximized and Docked forms in Access?

Yes, it can be done. Too much to explain here, but this will get you
started:
Your first form should have border style set to none. On load event, enter:

Me.Form.Move Left:=0, top:=0, Width:=15260, Height:=10160

play with the last two numbers. This essentially creates a full screen form
that you can refine with your command buttons on the left side, perhaps with
a box section. Then your forms that open from the command buttons can be
moved, movesized, set insideheight and insidewidth, etc. See help for these
properties.

HTH

Damon

"Max Moor" wrote in message
6...
Hi All,

I'm building a new Access 2002 runtime app, and I want a different look
and feel than I've had in the past.

When the program opens, I want a navigation pane to open on the left
side that is essentially docked there. It's not closeable and not
moveable
or resizeable.

When the various forms and reports open, I want them to do so always
maximized in the remaining space, preferably with just a close button. I
don't want the forms to be minimizeable, moveable, or sizeable, just
closeable.

Is there an easy way to make a form do either of these things?

Regards,
Max



  #3  
Old May 3rd, 2008, 07:49 AM posted to microsoft.public.access.forms
Max Moor
external usenet poster
 
Posts: 148
Default Maximized and Docked forms in Access?

"Damon Heron" wrote in
:

Yes, it can be done. Too much to explain here, but this will get you
started:
Your first form should have border style set to none. On load event,
enter:

Me.Form.Move Left:=0, top:=0, Width:=15260, Height:=10160

play with the last two numbers. This essentially creates a full screen
form that you can refine with your command buttons on the left side,
perhaps with a box section. Then your forms that open from the command
buttons can be moved, movesized, set insideheight and insidewidth, etc.
See help for these properties.

HTH

Damon


Hi Damon,

Thanks for the response. I started doing just as you suggested.
During a coffee break, I went looking some more, and found a reference to
some code in the Access Developer's Handbook.

I bought the set a few years ago, and have used it to death, but never
thought about looking there for this. It turns out that Chapter 8 is all
about form manipulation, and includes a FormInfo class module that does all
the tricks I wanted.

Those books were a well spent $80. I wish I'd remember to check them
out more.

Regards,
Max
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.