all forms maximized.... help!

i installed office 2007 and had to import all my old databases before a lot
of the code would run. Now all forms are maximized. if i create a new
database those forms are maximized too and i can find no way of restoring or
minimizing them. i presume its a setting somewhere.
this is driving me nuts and i'm getting no work done. Maybe i should go
back to 2003, please help

Go to:
Office Button | Access Options | Current Database
and change the setting for Document Window Options to:
Overlapping Windows.

The default is Tabbed Documents.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mike@work" wrote in message
...
i installed office 2007 and had to import all my old databases before a lot
of the code would run. Now all forms are maximized. if i create a new
database those forms are maximized too and i can find no way of restoring
or
minimizing them. i presume its a setting somewhere.
this is driving me nuts and i'm getting no work done. Maybe i should go
back to 2003, please help

thank you very much for the prompt reply Allen. I scanned thru those
settings myself but obviously missed it, as all is fine now.

"Allen Browne" wrote:

Go to:
Office Button | Access Options | Current Database
and change the setting for Document Window Options to:
Overlapping Windows.

The default is Tabbed Documents.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mike@work" wrote in message
...
i installed office 2007 and had to import all my old databases before a lot
of the code would run. Now all forms are maximized. if i create a new
database those forms are maximized too and i can find no way of restoring
or
minimizing them. i presume its a setting somewhere.
this is driving me nuts and i'm getting no work done. Maybe i should go
back to 2003, please help

Allen,
Do you know how to do this in VBA?
Jay

"Allen Browne" wrote:

Go to:
Office Button | Access Options | Current Database
and change the setting for Document Window Options to:
Overlapping Windows.

The default is Tabbed Documents.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mike@work" wrote in message
...
i installed office 2007 and had to import all my old databases before a lot
of the code would run. Now all forms are maximized. if i create a new
database those forms are maximized too and i can find no way of restoring
or
minimizing them. i presume its a setting somewhere.
this is driving me nuts and i'm getting no work done. Maybe i should go
back to 2003, please help

Allen,
Just figured it out!

Application.CurrentDb.Properties("UseMDIMode") = 0 or 1

This seems to work, but you've still got to close then reopen the
CurrentDb. You might find the following helpful:
http://allenbrowne.com/ser-69.html. :-)
Anyway, I've always enjoyed your posts to this forum and elsewhere.

Jay

"jay" wrote:

Allen,
Do you know how to do this in VBA?
Jay

"Allen Browne" wrote:

Go to:
Office Button | Access Options | Current Database
and change the setting for Document Window Options to:
Overlapping Windows.

The default is Tabbed Documents.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mike@work" wrote in message
...
i installed office 2007 and had to import all my old databases before a lot
of the code would run. Now all forms are maximized. if i create a new
database those forms are maximized too and i can find no way of restoring
or
minimizing them. i presume its a setting somewhere.
this is driving me nuts and i'm getting no work done. Maybe i should go
back to 2003, please help