Full Screen on database

[Simon]

Is there a way i can have a full screen view of my database with out
any of the toolbars at the top of the page.

Just to make it look tiredier and more profetional

Thanks


SImon

 

[Mikal via AccessMonster.com]

Simon:

First make a backup copy of your database. That way if you lock yourself out
you won't go too crazy till somebody tells you how to get back in.

First thing is to right-click the toolbars at the top and then click
"customize". Click the toolbar tab and uncheck everything that is checked.
You won't be able to get rid of the menu bar, though. Then click tools |
Startup and uncheck the four boxes at the bottom of the screen. Save the
database. That ought to get rid of everything but an abbreviated menu bar.

HTH

Mike

 

[aaron.kempf]

or if you lose the training wheels; and you used Access Data Projects;
then you could use tools like SQL Server Management Studio in order to
develop queries.

Real-mans tools for a real-mans job.

Access Queries are for retards and losers.

-Aaron

 

[Bill Mosca, MS Access MVP]

You can get rid of that little default menu by setting all your forms and
reports menu bar to =-1 or to a customized menu.

Be sure to include the equal sign.

 

[Mikal via AccessMonster.com]

Mr. Mosca:
Would you mind explaining a bit more? Where do I make that setting change?
Mike

Mr. Kempf:
I have long admired your erudition and gentlemanly discourse on this
newsgroup, not to mention the evident depth of your knowledge and your good
taste in database development platforms. It is true that I among others am
dependent on training wheels and certainly, I do aspire one day to operate
without them. However, that day has not yet arrived and I would deeply
appreciate the favor of your continued involvement in tthis discussion long
enough to satisfy my curiousity. I have a very tiny amount of experience
with .adp files as I do not have access to a SQL Server at work and have done
just a little experimentation at home as I have had the time for it. However,
I do not understand how the use of SQL Server Management Studio in order to
develop queries will remove unwanted toolbars from the application layer of
Simon's database.

Thanking you in advance for all of your professional courtesies, I remain

Yours most sincerely,

Mikal Ralph Pippins

You can get rid of that little default menu by setting all your forms and
reports menu bar to =-1 or to a customized menu.

Be sure to include the equal sign.

Simon:

[quoted text clipped - 22 lines]

 

[SusanV]

Bill -
I'm looking at an "out" if you will - for further dev. Should this code be
bound to a user id (other than admin) or to the designated startup form's On
Open (to allow a bypass)

TIA,

SusanV

 

[Van T. Dinh]

Susan

If you allow special shortcut keys, you only have to hit F11 to get back to
the Database window and the standard MenuBar.

Otherwise, you can use an AutoKeys macro to run code like:

Application.Screen.ActiveForm.MenuBar = ""

or
Application.Screen.ActiveForm.MenuBar = ""

to make the standard MenuBar re-appear for the current Form / Report.

Note that Bill advised that you need to use the "= -1" on *all* Forms and
Reports thus the MenuBar commands (sub-menu) will disappear every time you
open a Form / Report (not sure about the Dialog-mode Form / Report).

 

[aaron.kempf]

because there is a 'auto-hide all windows' option in SQL Server
Management Studio.

because in an access data project; or in SSMS you can design PART of a
query in design view.

you can't do that in MDB.

MDB is for babies; I really reccomend taking some training on SQL
Server or a real database system; it's a lot more productive.

I can give better examples if you need; but im out the door.

-Aaron

Mr. Mosca:
Would you mind explaining a bit more? Where do I make that setting change?
Mike

Mr. Kempf:
I have long admired your erudition and gentlemanly discourse on this
newsgroup, not to mention the evident depth of your knowledge and your good
taste in database development platforms. It is true that I among others am
dependent on training wheels and certainly, I do aspire one day to operate
without them. However, that day has not yet arrived and I would deeply
appreciate the favor of your continued involvement in tthis discussion long
enough to satisfy my curiousity. I have a very tiny amount of experience
with .adp files as I do not have access to a SQL Server at work and have done
just a little experimentation at home as I have had the time for it. However,
I do not understand how the use of SQL Server Management Studio in order to
develop queries will remove unwanted toolbars from the application layer of
Simon's database.

Thanking you in advance for all of your professional courtesies, I remain

Yours most sincerely,

Mikal Ralph Pippins

You can get rid of that little default menu by setting all your forms and
reports menu bar to =-1 or to a customized menu.

Be sure to include the equal sign.

Simon:

[quoted text clipped - 22 lines]

SImon