By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,437 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Form that does not have menu nor can be minimized

P: n/a
Col
Hi - I'm working in a database that someone else created. They set up
the switchboard so that it can't be minimized nor can you switch to
design view. It's been a hassle because I'm testing stuff in a query
that pulls from fields on the form, so I can't just leave the form open
and run the query. I cannot figure out how to change the form so I can
minimize it or switch to design view or leave it open while working on
other aspects of the database. Any ideas?

Thanks.

Aug 21 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Sounds as if it has been "compiled to MDE"... if so, that DB is intended for
users, not for further development and you need to find the original MDB
format database.

Have you tried holding down the Shift key when you open it to see if you get
the database window, or pressing F11 after it opens? Those should bypass
the startup form, assuming one has been specified, but won't allow you to
open all Forms or Reports in design view.

It may also have had workgroup level security applied, which would make what
you want to do even more difficult. In regards to this, do you have to log
in with a userid and password?

Larry Linson
Microsoft Access MVP
"Col" <cm****@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
Hi - I'm working in a database that someone else created. They set up
the switchboard so that it can't be minimized nor can you switch to
design view. It's been a hassle because I'm testing stuff in a query
that pulls from fields on the form, so I can't just leave the form open
and run the query. I cannot figure out how to change the form so I can
minimize it or switch to design view or leave it open while working on
other aspects of the database. Any ideas?

Thanks.

Aug 21 '06 #2

P: n/a
Col
Hi - you originally needed to log in with an id & password, but there
is no longer a need for that level of security. I might try contacting
the original developer to see how he set the security up. F11 does not
work. If I click button on the form, it runs a query, and I can get to
the tables & queries, but the form automatically closes, and I need it
open to test some queries. Will try shift key. Thanks.
Larry Linson wrote:
Sounds as if it has been "compiled to MDE"... if so, that DB is intended for
users, not for further development and you need to find the original MDB
format database.

Have you tried holding down the Shift key when you open it to see if you get
the database window, or pressing F11 after it opens? Those should bypass
the startup form, assuming one has been specified, but won't allow you to
open all Forms or Reports in design view.

It may also have had workgroup level security applied, which would make what
you want to do even more difficult. In regards to this, do you have to log
in with a userid and password?

Larry Linson
Microsoft Access MVP
"Col" <cm****@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
Hi - I'm working in a database that someone else created. They set up
the switchboard so that it can't be minimized nor can you switch to
design view. It's been a hassle because I'm testing stuff in a query
that pulls from fields on the form, so I can't just leave the form open
and run the query. I cannot figure out how to change the form so I can
minimize it or switch to design view or leave it open while working on
other aspects of the database. Any ideas?

Thanks.
Aug 21 '06 #3

P: n/a
Did you try right-clicking on the form and seeing if Design View is an
option? It may be modal which would explain why you can't edit it.

Col wrote:
Hi - you originally needed to log in with an id & password, but there
is no longer a need for that level of security. I might try contacting
the original developer to see how he set the security up. F11 does not
work. If I click button on the form, it runs a query, and I can get to
the tables & queries, but the form automatically closes, and I need it
open to test some queries. Will try shift key. Thanks.
Larry Linson wrote:
Sounds as if it has been "compiled to MDE"... if so, that DB is intended for
users, not for further development and you need to find the original MDB
format database.

Have you tried holding down the Shift key when you open it to see if you get
the database window, or pressing F11 after it opens? Those should bypass
the startup form, assuming one has been specified, but won't allow you to
open all Forms or Reports in design view.

It may also have had workgroup level security applied, which would make what
you want to do even more difficult. In regards to this, do you have to log
in with a userid and password?

Larry Linson
Microsoft Access MVP
"Col" <cm****@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
Hi - I'm working in a database that someone else created. They set up
the switchboard so that it can't be minimized nor can you switch to
design view. It's been a hassle because I'm testing stuff in a query
that pulls from fields on the form, so I can't just leave the form open
and run the query. I cannot figure out how to change the form so I can
minimize it or switch to design view or leave it open while working on
other aspects of the database. Any ideas?
>
Thanks.
>
Aug 21 '06 #4

P: n/a
Col
Hi - I can right click and get design view. I also can click the
command button on the form (which opens a query) and then click F11,
but the problem is I need to leave the form open to test somethings in
a query, and when the form is open, it's maximized with no menu bar and
I can't toggle back to my query.

Thanks.

ManningFan wrote:
Did you try right-clicking on the form and seeing if Design View is an
option? It may be modal which would explain why you can't edit it.

Col wrote:
Hi - you originally needed to log in with an id & password, but there
is no longer a need for that level of security. I might try contacting
the original developer to see how he set the security up. F11 does not
work. If I click button on the form, it runs a query, and I can get to
the tables & queries, but the form automatically closes, and I need it
open to test some queries. Will try shift key. Thanks.
Larry Linson wrote:
Sounds as if it has been "compiled to MDE"... if so, that DB is intended for
users, not for further development and you need to find the original MDB
format database.
>
Have you tried holding down the Shift key when you open it to see if you get
the database window, or pressing F11 after it opens? Those should bypass
the startup form, assuming one has been specified, but won't allow you to
open all Forms or Reports in design view.
>
It may also have had workgroup level security applied, which would make what
you want to do even more difficult. In regards to this, do you have to log
in with a userid and password?
>
Larry Linson
Microsoft Access MVP
>
>
"Col" <cm****@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
Hi - I'm working in a database that someone else created. They set up
the switchboard so that it can't be minimized nor can you switch to
design view. It's been a hassle because I'm testing stuff in a query
that pulls from fields on the form, so I can't just leave the form open
and run the query. I cannot figure out how to change the form so I can
minimize it or switch to design view or leave it open while working on
other aspects of the database. Any ideas?

Thanks.
Aug 22 '06 #5

P: n/a
Col
It was the modal setting. Thanks for the help. All set now.

Col wrote:
Hi - I can right click and get design view. I also can click the
command button on the form (which opens a query) and then click F11,
but the problem is I need to leave the form open to test somethings in
a query, and when the form is open, it's maximized with no menu bar and
I can't toggle back to my query.

Thanks.

ManningFan wrote:
Did you try right-clicking on the form and seeing if Design View is an
option? It may be modal which would explain why you can't edit it.

Col wrote:
Hi - you originally needed to log in with an id & password, but there
is no longer a need for that level of security. I might try contacting
the original developer to see how he set the security up. F11 does not
work. If I click button on the form, it runs a query, and I can get to
the tables & queries, but the form automatically closes, and I need it
open to test some queries. Will try shift key. Thanks.
>
>
Larry Linson wrote:
Sounds as if it has been "compiled to MDE"... if so, that DB is intended for
users, not for further development and you need to find the original MDB
format database.

Have you tried holding down the Shift key when you open it to see if you get
the database window, or pressing F11 after it opens? Those should bypass
the startup form, assuming one has been specified, but won't allow you to
open all Forms or Reports in design view.

It may also have had workgroup level security applied, which would make what
you want to do even more difficult. In regards to this, do you have to log
in with a userid and password?

Larry Linson
Microsoft Access MVP


"Col" <cm****@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
Hi - I'm working in a database that someone else created. They set up
the switchboard so that it can't be minimized nor can you switch to
design view. It's been a hassle because I'm testing stuff in a query
that pulls from fields on the form, so I can't just leave the form open
and run the query. I cannot figure out how to change the form so I can
minimize it or switch to design view or leave it open while working on
other aspects of the database. Any ideas?
>
Thanks.
>
Aug 22 '06 #6

P: n/a
Col
And the popup setting too.
Col wrote:
It was the modal setting. Thanks for the help. All set now.

Col wrote:
Hi - I can right click and get design view. I also can click the
command button on the form (which opens a query) and then click F11,
but the problem is I need to leave the form open to test somethings in
a query, and when the form is open, it's maximized with no menu bar and
I can't toggle back to my query.

Thanks.

ManningFan wrote:
Did you try right-clicking on the form and seeing if Design View is an
option? It may be modal which would explain why you can't edit it.
>
Col wrote:
Hi - you originally needed to log in with an id & password, but there
is no longer a need for that level of security. I might try contacting
the original developer to see how he set the security up. F11 does not
work. If I click button on the form, it runs a query, and I can get to
the tables & queries, but the form automatically closes, and I need it
open to test some queries. Will try shift key. Thanks.


Larry Linson wrote:
Sounds as if it has been "compiled to MDE"... if so, that DB is intended for
users, not for further development and you need to find the original MDB
format database.
>
Have you tried holding down the Shift key when you open it to see if you get
the database window, or pressing F11 after it opens? Those should bypass
the startup form, assuming one has been specified, but won't allow you to
open all Forms or Reports in design view.
>
It may also have had workgroup level security applied, which would make what
you want to do even more difficult. In regards to this, do you have to log
in with a userid and password?
>
Larry Linson
Microsoft Access MVP
>
>
"Col" <cm****@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
Hi - I'm working in a database that someone else created. They set up
the switchboard so that it can't be minimized nor can you switch to
design view. It's been a hassle because I'm testing stuff in a query
that pulls from fields on the form, so I can't just leave the form open
and run the query. I cannot figure out how to change the form so I can
minimize it or switch to design view or leave it open while working on
other aspects of the database. Any ideas?

Thanks.
Aug 22 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.