Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2007

Tip: Looking for answers? Try searching our database.

Making a form open full page

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gil - 04 Feb 2006 20:20 GMT
quick question: How can I make a form open up full screen without menubar or
toolbar on startup. I want The user to only see the form but still allow me
to edit the form if needed and database if needed but not allow them to
access it. Sorry for the dumb question but i am a supernoob with access.
Thanks in advance  for any help:)
fredg - 04 Feb 2006 21:29 GMT
> quick question: How can I make a form open up full screen without menubar or
> toolbar on startup. I want The user to only see the form but still allow me
> to edit the form if needed and database if needed but not allow them to
> access it. Sorry for the dumb question but i am a supernoob with access.
> Thanks in advance  for any help:)

Code the Form's Open event:
DoCmd.Maximize

Then click on Tools + Start Up.
In the Display Form/Page dialog box select the form.
Uncheck the Display Application Window check box.

If you ever need get into the application, simply hold down the shift
key when you open it, or press F11 while it is open.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Soddy - 14 Oct 2006 20:37 GMT
Hello!

Is there a way to make it 'open' and 'cover' (or hide) the Access's menu bar?

Signature

Thanks!
Soddy

> > quick question: How can I make a form open up full screen without menubar or
> > toolbar on startup. I want The user to only see the form but still allow me
[quoted text clipped - 11 lines]
> If you ever need get into the application, simply hold down the shift
> key when you open it, or press F11 while it is open.
Van T. Dinh - 15 Oct 2006 08:23 GMT
You can hide the Menu Bar with code like:

   DoCmd.ShowToolBar "Menu Bar", acToolbarNo

Signature

HTH
Van T. Dinh
MVP (Access)

> Hello!
>
[quoted text clipped - 19 lines]
>> If you ever need get into the application, simply hold down the shift
>> key when you open it, or press F11 while it is open.
Soddy - 15 Oct 2006 16:11 GMT
Hello!

I just tried that for my startup form and it doesn't seem to work.  I put it
in the 'On Open' event of the form.  I can get it to 'hide' the items on the
menu bar by using the '=1' for the 'menu bar' property in the 'startup'
form...

Signature

Thanks!
Soddy

> You can hide the Menu Bar with code like:
>
[quoted text clipped - 23 lines]
> >> If you ever need get into the application, simply hold down the shift
> >> key when you open it, or press F11 while it is open.
Soddy - 15 Oct 2006 16:15 GMT
Hello!

I just tried using that in my 'startup' form in the 'on open' event along
with a docmd.maximize command and it doesn't seem to work - the menu bar
still shows.  I can 'hide' the menu bar items by using the '=1' in the 'menu
bar' property of the startup form.  But if possible, I would like to
hide/remove the menu bar and then return it when the startup form is closed
(on close event).

Signature

Thanks!
Soddy

> You can hide the Menu Bar with code like:
>
[quoted text clipped - 23 lines]
> >> If you ever need get into the application, simply hold down the shift
> >> key when you open it, or press F11 while it is open.
Soddy - 15 Oct 2006 16:52 GMT
Hello!

Say, I ran across this in the Access 2003 help on 'customizing toolbars,
etc...':

You can customize menus and toolbars yourself; you can add and remove
buttons and menus on toolbars, create your own custom toolbars, hide or
display toolbars, and move toolbars. You can customize the menu bar the same
way you customize any built-in toolbar (built-in toolbar: A toolbar that is
part of Access when it's installed on your computer. In contrast, a custom
toolbar is one that you create for your own application.)— for example, you
can quickly add and remove buttons and menus on the menu bar— but you can't
hide the menu bar.

Thoughts...??

Signature

Thanks!
Soddy

> Hello!
>
[quoted text clipped - 32 lines]
> > >> If you ever need get into the application, simply hold down the shift
> > >> key when you open it, or press F11 while it is open.
Rick Brandt - 15 Oct 2006 17:02 GMT
> Hello!
>
[quoted text clipped - 11 lines]
>
> Thoughts...??

Rather than trying to have NO menu bar just create your own and put nothing on
it that you don't want users to have access to and then use startup properties
to make that menu bar the main menu bar for the application.  The application
main menu is where the control buttons for maximized objects are placed so it is
not logical to have no menu bar at all.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Soddy - 15 Oct 2006 17:52 GMT
Thanks for the info and makes sense...

However, I have a slight problem now...!  In screwing around with the 'menu
bar', I got involved in 'customizing' it (i.e., I dragged a couple of menu
bar items off - like the 'File', etc...).  Now it stays that way even when I
create a new DB in Access.  How can (if I can) get the 'original' menubar
back??

Signature

Thanks!
Soddy

> > Hello!
> >
[quoted text clipped - 17 lines]
> main menu is where the control buttons for maximized objects are placed so it is
> not logical to have no menu bar at all.
Soddy - 15 Oct 2006 19:31 GMT
Hello!

I think I figured out how to fix the problem...  I just went into the
'customize menu' and selected the 'menu bar' and the 'reset' button which did
the trick.  So, thanks alot!!

Signature

Thanks!
Soddy

> Thanks for the info and makes sense...
>
[quoted text clipped - 25 lines]
> > main menu is where the control buttons for maximized objects are placed so it is
> > not logical to have no menu bar at all.
Soddy - 15 Oct 2006 20:13 GMT
Hello!

Say, is there a way to eliminate the 'extra' wording in the top 'title bar'
after you enter the 'application' title in the 'startup' menu??

Signature

Thanks!
Soddy

> Thanks for the info and makes sense...
>
[quoted text clipped - 25 lines]
> > main menu is where the control buttons for maximized objects are placed so it is
> > not logical to have no menu bar at all.
Rick Brandt - 16 Oct 2006 14:01 GMT
> Hello!
>
> Say, is there a way to eliminate the 'extra' wording in the top
> 'title bar' after you enter the 'application' title in the 'startup'
> menu??

What "extra wording" would that be?

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

emtrouwee - 29 Apr 2007 21:46 GMT
I think Soddy means the form title when maximized. When a form is maximized
it shows: apllication name - form name

> > Hello!
> >
[quoted text clipped - 3 lines]
>
> What "extra wording" would that be?
Norm75 - 13 Nov 2006 04:48 GMT
I have a similar problem. Where do I place the code that you show:
DoCmd.ShowToolBar "Menu Bar", acToolbarNo  ? I have been able to hide the
Menu Bar on the Switchboard form by adding =1 to the MenuBar in the form's
properties. However, I have a number of datasheets that respond to buttons on
the Switchboard. For each datasheet which is developed from queries, the
"Menu Bar" remains and I can't seem to get rid of it - again so a recipient
can't change any information on the datasheets.

Thanks. Norm.

> You can hide the Menu Bar with code like:
>
[quoted text clipped - 23 lines]
> >> If you ever need get into the application, simply hold down the shift
> >> key when you open it, or press F11 while it is open.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.