About Hiding Access Window & Maximise All DB windows with code

S

Stefanos_Karametos

I want to hide the access window whenever my DB starts. with they use of
code Also i would like the main DB window to start maximised using code. Is
it possible to make all the DB windows start maximised also?
 
D

Douglas J. Steele

When you maximize one form in Access, all forms are maximized, so once
you've maximized the main DB window, you're be fine.

To maximize it, simply put DoCmd.Maximize in the form's Open event.

Not quite sure what you mean by hiding the access window. If you mean the
database window (that lists all of the tables, queries, etc.), you can
control this under Tools | Startup on the menu bar. If you want to hide
Access, take a look at http://www.mvps.org/access/api/api0019.htm at "The
Access Web"
 
S

Stefanos_Karametos

Dear Douglas,

Sorry to caused problems to you with my attitude. The point is I'm a newbie
and i'm despered to find help and answers off course. The fact that i am so
anxious to do so is that it's about a diplomacy paper i've got to finish and
it involves a DB which io have to build from point zero. I have nothing more
to tell about it except that i'm very very sorry and that this will not
happen again.
Now about the code you suggest i'll say that i did have found it through
your homepage but i tried to make it work and it didn't; for this might be
the reason that i'm not an IT graduate or something but a mechanic on
energy issues. Please i need to know the exactly place of the function in
which i'll put the declared constants and to provide help to add it in my
startup code ( it's the one from the Northwind's DB from Access example ).

Thank You A Lot!!!
 
A

Albert D. Kallal

You actually don't need any code at all to hide the ms-access interface.

It is just not clear if you are trying to hide all of the ms-access stuff,
or you are trying to hide the main ms-access background window (this is a
considerably different question).

If you want to see a code free approach that hides all of the ms-access
interface, then download the 3rd example here:
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

Try running the above....and see how it hides ms-access. It might be want
you want...and you don't have to use code to do this.
 
A

Allan TFF

My question is similar to Stefanos' original, except that I don't know any
code.

I would like the database window to open maximized every single time I start
the database. I've tried maximinzing the database window and saving the
database before closing, but to no avail: the next time I start the database
window is once again too small for all my objects in it.

Would greatly appreciate some help.

Allan
 
A

Albert D.Kallal

My question is similar to Stefanos' original, except that I don't know any
code.

I would like the database window to open maximized every single time I
start
the database. I've tried maximinzing the database window and saving the
database before closing, but to no avail: the next time I start the
database
window is once again too small for all my objects in it.

Would greatly appreciate some help.

Allan
Click to expand...

First, my sample link was broken. You can find that sample that hides the
access interface here:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

Grab the 3rd example...ms-access interface hidden.

The above example used no code to hide the ms-access interface (only
tools->startup options were used).

As for maximizing the application when it starts?

Do you have a form set in the tools->startup?


If you don't have a startup form (I think you should), then you can use a
autoexec macro.

Just create a macro called autoexec.

Then add to the macro:
RunCommand

Command: AppMaximize
 
Top