MS Access, Closing a form when other form is opening but reopening when all forms closed

Closing a form when other form is opening but reopening when all forms closed

Author	Message
kev #1 / 6	Closing a form when other form is opening but reopening when all forms closed Basically I need to have a default form. This is what I want the form to do: Open by default Maximized when the mdb is opened When a command is executed on this form, I want to minimize or close the form, and when the other form is closed, to maximize or open the form again. I know this is possible, I just can't seem to find out how to do it. Thank you for your time
Wed, 15 Oct 2003 03:14:13 GMT

Randy Frit #2 / 6	Closing a form when other form is opening but reopening when all forms closed This one is easy enough for me to handle - Thanks Kev just create a macro that has a close action for your main form and an OpenForm action for the Form you are wanting to open - then on your command buttons On Click event have it run your Macro Randy Quote: > Basically I need to have a default form. > This is what I want the form to do: > Open by default Maximized when the mdb is opened > When a command is executed on this form, I want to minimize or close the > form, and when the other form is closed, to maximize or open the form again. > I know this is possible, I just can't seem to find out how to do it. > Thank you for your time
Wed, 15 Oct 2003 04:27:27 GMT

Randy Frit #3 / 6	Closing a form when other form is opening but reopening when all forms closed PS. Include in your macro the Maximize Action for your form. Randy Quote: > Basically I need to have a default form. > This is what I want the form to do: > Open by default Maximized when the mdb is opened > When a command is executed on this form, I want to minimize or close the > form, and when the other form is closed, to maximize or open the form again. > I know this is possible, I just can't seem to find out how to do it. > Thank you for your time
Wed, 15 Oct 2003 04:28:57 GMT

kev #4 / 6	Closing a form when other form is opening but reopening when all forms closed Thanks for that, thats a good idea.. now what are the chance i could get something like this to work when a Report Preview is opened or closed. Quote: > PS. Include in your macro the Maximize Action for your form. > Randy > > Basically I need to have a default form. > > This is what I want the form to do: > > Open by default Maximized when the mdb is opened > > When a command is executed on this form, I want to minimize or close the > > form, and when the other form is closed, to maximize or open the form > again. > > I know this is possible, I just can't seem to find out how to do it. > > Thank you for your time
Wed, 15 Oct 2003 04:35:53 GMT

Tomas Bucc #5 / 6	Closing a form when other form is opening but reopening when all forms closed When I wanted something like this I simply toggled the .visible property of the form(s). This way also has the added benifit that it is faster than opening and closing. On open of the second form, the first form's visible property is set to false, and on the close of the second form the first form's visible property is set back to true. Quote: -----Original Message----- Basically I need to have a default form. This is what I want the form to do: Open by default Maximized when the mdb is opened When a command is executed on this form, I want to minimize or close the form, and when the other form is closed, to maximize or open the form again. I know this is possible, I just can't seem to find out how to do it. Thank you for your time .
Wed, 15 Oct 2003 04:17:29 GMT

MMPalmy #6 / 6	Closing a form when other form is opening but reopening when all forms closed I'm not sure what you are doing but to open a form when the db is opened you can do one of two things. One you can create a macro which opens the form and name the macro autoexec. Two you can use the built in startup dialog box. For that go to Tools>Startup and play with the properties. To close the form and open another create a command button with the wizard and pick form functions. That makes it easy. Mike
Wed, 15 Oct 2003 09:03:54 GMT

Page 1 of 1

[ 6 post ]