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  

Forms DoCmd.Maximize | DoCmd.Restore



 
 
Thread Tools Display Modes
  #1  
Old July 26th, 2004, 08:55 PM
Tom
external usenet poster
 
Posts: n/a
Default Forms DoCmd.Maximize | DoCmd.Restore

I have a main form that (when opened) is maximized (using the DoCmd.Maximize
OnOpen event).

On this form, I have a CommandButton that calls another form when being
clicked. Currently, this form is also maximized once being called via
clicking on the Command button. However, I don't really care about
automatically maximizing this form.

Now, when I close the subform (which has been called via command button) the
main form is (I guess) "RestoreForm" mode (not maximized nor mimized).
This is not what I want though. I want the view mode of the main form
unchanged.

So, my question is... how can I close the subform and then automatically
maximize the mainform again?


Thanks,
Tom


  #2  
Old July 26th, 2004, 09:29 PM
Larry Daugherty
external usenet poster
 
Posts: n/a
Default Forms DoCmd.Maximize | DoCmd.Restore

Hi Tom,

You might try something like;

DoCmd.SelectObject A_FORM, "frmNewMeetingNotes"
DoCmd.Maximize

in the OnCurrent event of the form.

HTH
--
-Larry-
--

"Tom" wrote in message
...
I have a main form that (when opened) is maximized (using the

DoCmd.Maximize
OnOpen event).

On this form, I have a CommandButton that calls another form when being
clicked. Currently, this form is also maximized once being called via
clicking on the Command button. However, I don't really care about
automatically maximizing this form.

Now, when I close the subform (which has been called via command button)

the
main form is (I guess) "RestoreForm" mode (not maximized nor mimized).
This is not what I want though. I want the view mode of the main form
unchanged.

So, my question is... how can I close the subform and then automatically
maximize the mainform again?


Thanks,
Tom




  #3  
Old July 26th, 2004, 11:18 PM
Wade
external usenet poster
 
Posts: n/a
Default Forms DoCmd.Maximize | DoCmd.Restore

I have had a similar issue and I wish I knew more about
VB. I tried Larry's approach, but the main form remained
Restored after I closed the second form.

The only way I got mine to work was to make two Macros
and call each one for their function (mcroRestore and
mcroMaximize). Once you do this, in the Events,
choose "mcroRestore" under On Open and
choose "mcroMaximize" under On Close. It will do the job
and they can be easly referenced on multiple forms but I
know there is a better way.

Does anyone know how to force only one form to Restore
and keep the other forms Maximized? I'd like to get rid
of

-----Original Message-----
I have a main form that (when opened) is maximized

(using the DoCmd.Maximize
OnOpen event).

On this form, I have a CommandButton that calls another

form when being
clicked. Currently, this form is also maximized once

being called via
clicking on the Command button. However, I don't

really care about
automatically maximizing this form.

Now, when I close the subform (which has been called via

command button) the
main form is (I guess) "RestoreForm" mode (not maximized

nor mimized).
This is not what I want though. I want the view mode

of the main form
unchanged.

So, my question is... how can I close the subform and

then automatically
maximize the mainform again?


Thanks,
Tom


.

  #4  
Old July 27th, 2004, 02:20 PM
Tom
external usenet poster
 
Posts: n/a
Default Forms DoCmd.Maximize | DoCmd.Restore

Wade:

Got to hear that I am not the only one w/ this problem.

Larry's suggestion did fix my issue though... the only thing I had to
change to NOT to use the OnCurrent event... instead I put Larry's code
(certainly w/ my form name) into the OnClose event... that did the "trick".

HTH,
Tom




"Wade" wrote in message
...
I have had a similar issue and I wish I knew more about
VB. I tried Larry's approach, but the main form remained
Restored after I closed the second form.

The only way I got mine to work was to make two Macros
and call each one for their function (mcroRestore and
mcroMaximize). Once you do this, in the Events,
choose "mcroRestore" under On Open and
choose "mcroMaximize" under On Close. It will do the job
and they can be easly referenced on multiple forms but I
know there is a better way.

Does anyone know how to force only one form to Restore
and keep the other forms Maximized? I'd like to get rid
of

-----Original Message-----
I have a main form that (when opened) is maximized

(using the DoCmd.Maximize
OnOpen event).

On this form, I have a CommandButton that calls another

form when being
clicked. Currently, this form is also maximized once

being called via
clicking on the Command button. However, I don't

really care about
automatically maximizing this form.

Now, when I close the subform (which has been called via

command button) the
main form is (I guess) "RestoreForm" mode (not maximized

nor mimized).
This is not what I want though. I want the view mode

of the main form
unchanged.

So, my question is... how can I close the subform and

then automatically
maximize the mainform again?


Thanks,
Tom


.



  #5  
Old July 27th, 2004, 04:03 PM
Wade
external usenet poster
 
Posts: n/a
Default Final Question

How dose the main form remain Maximized if it remains
open but placed behind the Restored form.

Every time I try this, after I close the Restored form,
the Main form stays Restored. I want it to stay
Maximized.

What am I missing?

-----Original Message-----
Wade:

Got to hear that I am not the only one w/ this problem.

Larry's suggestion did fix my issue though... the only

thing I had to
change to NOT to use the OnCurrent event... instead I

put Larry's code
(certainly w/ my form name) into the OnClose event...

that did the "trick".

HTH,
Tom




"Wade" wrote in

message
...
I have had a similar issue and I wish I knew more about
VB. I tried Larry's approach, but the main form

remained
Restored after I closed the second form.

The only way I got mine to work was to make two Macros
and call each one for their function (mcroRestore and
mcroMaximize). Once you do this, in the Events,
choose "mcroRestore" under On Open and
choose "mcroMaximize" under On Close. It will do the

job
and they can be easly referenced on multiple forms but

I
know there is a better way.

Does anyone know how to force only one form to Restore
and keep the other forms Maximized? I'd like to get

rid
of

-----Original Message-----
I have a main form that (when opened) is maximized

(using the DoCmd.Maximize
OnOpen event).

On this form, I have a CommandButton that calls

another
form when being
clicked. Currently, this form is also maximized once

being called via
clicking on the Command button. However, I don't

really care about
automatically maximizing this form.

Now, when I close the subform (which has been called

via
command button) the
main form is (I guess) "RestoreForm" mode (not

maximized
nor mimized).
This is not what I want though. I want the view mode

of the main form
unchanged.

So, my question is... how can I close the subform and

then automatically
maximize the mainform again?


Thanks,
Tom


.



.

  #6  
Old July 27th, 2004, 06:05 PM
Tom
external usenet poster
 
Posts: n/a
Default Final Question

Wade:

My "mainform" (maximized) calls the "Subform"... which also is openen in
Maximized view (I don' care how the subform is opened).

Until I used Larry's code, the Subform (when closed) caused the Mainform to
be viewed in Restore mode... this now is not the case any longer.

So, if okay, try to open your subform also in maximized view.

Hth,
Tom



"Wade" wrote in message
...
How dose the main form remain Maximized if it remains
open but placed behind the Restored form.

Every time I try this, after I close the Restored form,
the Main form stays Restored. I want it to stay
Maximized.

What am I missing?

-----Original Message-----
Wade:

Got to hear that I am not the only one w/ this problem.

Larry's suggestion did fix my issue though... the only

thing I had to
change to NOT to use the OnCurrent event... instead I

put Larry's code
(certainly w/ my form name) into the OnClose event...

that did the "trick".

HTH,
Tom




"Wade" wrote in

message
...
I have had a similar issue and I wish I knew more about
VB. I tried Larry's approach, but the main form

remained
Restored after I closed the second form.

The only way I got mine to work was to make two Macros
and call each one for their function (mcroRestore and
mcroMaximize). Once you do this, in the Events,
choose "mcroRestore" under On Open and
choose "mcroMaximize" under On Close. It will do the

job
and they can be easly referenced on multiple forms but

I
know there is a better way.

Does anyone know how to force only one form to Restore
and keep the other forms Maximized? I'd like to get

rid
of

-----Original Message-----
I have a main form that (when opened) is maximized
(using the DoCmd.Maximize
OnOpen event).

On this form, I have a CommandButton that calls

another
form when being
clicked. Currently, this form is also maximized once
being called via
clicking on the Command button. However, I don't
really care about
automatically maximizing this form.

Now, when I close the subform (which has been called

via
command button) the
main form is (I guess) "RestoreForm" mode (not

maximized
nor mimized).
This is not what I want though. I want the view mode
of the main form
unchanged.

So, my question is... how can I close the subform and
then automatically
maximize the mainform again?


Thanks,
Tom


.



.



  #7  
Old July 27th, 2004, 06:57 PM
external usenet poster
 
Posts: n/a
Default Final Question

Thanks Tom,

I guess my issue is a little different. I'm trying to
get a main form to remain Maximized. When a command
button is clicked on that main form, it calls up other
forms for quick reference. I'm trying to get those quick
reference forms to be restored while maintaining a
Maximized view of the main form.


-----Original Message-----
Wade:

My "mainform" (maximized) calls the "Subform"... which

also is openen in
Maximized view (I don' care how the subform is opened).

Until I used Larry's code, the Subform (when closed)

caused the Mainform to
be viewed in Restore mode... this now is not the case

any longer.

So, if okay, try to open your subform also in maximized

view.

Hth,
Tom



"Wade" wrote in

message
...
How dose the main form remain Maximized if it remains
open but placed behind the Restored form.

Every time I try this, after I close the Restored form,
the Main form stays Restored. I want it to stay
Maximized.

What am I missing?

-----Original Message-----
Wade:

Got to hear that I am not the only one w/ this

problem.

Larry's suggestion did fix my issue though... the

only
thing I had to
change to NOT to use the OnCurrent event... instead I

put Larry's code
(certainly w/ my form name) into the OnClose event...

that did the "trick".

HTH,
Tom




"Wade" wrote in

message
...
I have had a similar issue and I wish I knew more

about
VB. I tried Larry's approach, but the main form

remained
Restored after I closed the second form.

The only way I got mine to work was to make two

Macros
and call each one for their function (mcroRestore

and
mcroMaximize). Once you do this, in the Events,
choose "mcroRestore" under On Open and
choose "mcroMaximize" under On Close. It will do

the
job
and they can be easly referenced on multiple forms

but
I
know there is a better way.

Does anyone know how to force only one form to

Restore
and keep the other forms Maximized? I'd like to get

rid
of

-----Original Message-----
I have a main form that (when opened) is maximized
(using the DoCmd.Maximize
OnOpen event).

On this form, I have a CommandButton that calls

another
form when being
clicked. Currently, this form is also maximized

once
being called via
clicking on the Command button. However, I don't
really care about
automatically maximizing this form.

Now, when I close the subform (which has been

called
via
command button) the
main form is (I guess) "RestoreForm" mode (not

maximized
nor mimized).
This is not what I want though. I want the view

mode
of the main form
unchanged.

So, my question is... how can I close the subform

and
then automatically
maximize the mainform again?


Thanks,
Tom


.



.



.

 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
datasheet forms open in form mode from the Switchboard Paul James Using Forms 5 July 13th, 2004 06:51 AM
Word Forms? CEVisker New Users 4 June 21st, 2004 01:25 AM
Forms Check Box not working DLLower General Discussion 2 June 17th, 2004 09:34 PM
matching multiple forms on open to form records EdwardA Using Forms 0 June 10th, 2004 06:38 PM


All times are GMT +1. The time now is 11:16 AM.


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