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 / Database Design / April 2004

Tip: Looking for answers? Try searching our database.

Repost: Maximise Instance & Startup event order

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Basil - 13 Apr 2004 11:21 GMT
Hello

Got no response last time, so was hoping this time I could get a "stop wasting your time Baz" or, if I'm lucky, maybe a tip

1. Is there any code I can run on db startup that will maximise the current instance of Access in windows

2. Can someone shed some light on events at startup? - eg If you have an autoexec that is set to open a particular toolbar and then open a form... why will it ALWAYS open the toolbar last, regardless of the order of the actions (also applicable in VBA code run either through autoexec macro or through startup form)
  Could you see if this happens to you too
(I know this happens to me since a form set to open at centre (auto centre) will open slightly higher if there are no toolbars visible at time of opening - hence a copy of the form opened after the toolbar is open at the top will be lower)

Thanks loads

Basil
James - 13 Apr 2004 12:55 GMT
Hi...

Right as for you maximise thing...  your best option would
be to create the autoexec macro and just put the command
maximise in there... that will maximize access for you.

Ok as for the second question...

I have tried opening a certain toolbar and then a form and
yes it seems to open the toolbar last... I dont have an
explination as to why but you not alone it maybe default
access behaviour as it may need to check to see if the
toolbar is needed or something...

For the proper and a certain answer maybe someone else
could assist... maybe an MVP or someone..

Hope this Helps

James

>-----Original Message-----
>Hello,
>
>Got no response last time, so was hoping this time I could get a "stop wasting your time Baz" or, if I'm lucky,
maybe a tip.

>1. Is there any code I can run on db startup that will maximise the current instance of Access in windows?
>
>2. Can someone shed some light on events at startup? - eg If you have an autoexec that is set to open a particular
toolbar and then open a form... why will it ALWAYS open
the toolbar last, regardless of the order of the actions
(also applicable in VBA code run either through autoexec
macro or through startup form).
>   Could you see if this happens to you too?
>(I know this happens to me since a form set to open at centre (auto centre) will open slightly higher if there
are no toolbars visible at time of opening - hence a copy
of the form opened after the toolbar is open at the top
will be lower).

>Thanks loads,
>
>Basil
>.
Basil - 13 Apr 2004 13:26 GMT
Thanks for the quick response James.

It's nice to know I'm not alone with the toolbar problem.  Can play a bit of havoc for my forms when people have customised the way Access looks on their machine.

Regarding the maximise problem - the solution you suggested does not maximise the Access instance in Windows - it will maximise the focussed object within the Access instance.  The difference is visible if you 'restore down' an Access instance and then re-open - it won't open maximised.

Baz
   
    ----- James wrote: -----
   
    Hi...
   
    Right as for you maximise thing...  your best option would
    be to create the autoexec macro and just put the command
    maximise in there... that will maximize access for you.
   
    Ok as for the second question...
   
    I have tried opening a certain toolbar and then a form and
    yes it seems to open the toolbar last... I dont have an
    explination as to why but you not alone it maybe default
    access behaviour as it may need to check to see if the
    toolbar is needed or something...
   
    For the proper and a certain answer maybe someone else
    could assist... maybe an MVP or someone..
   
    Hope this Helps
   
    James
   
    >-----Original Message-----
    >Hello,
    >>Got no response last time, so was hoping this time I
    could get a "stop wasting your time Baz" or, if I'm lucky,
    maybe a tip.
    >>1. Is there any code I can run on db startup that will
    maximise the current instance of Access in windows?
    >>2. Can someone shed some light on events at startup? - eg
    If you have an autoexec that is set to open a particular
    toolbar and then open a form... why will it ALWAYS open
    the toolbar last, regardless of the order of the actions
    (also applicable in VBA code run either through autoexec
    macro or through startup form).
    >   Could you see if this happens to you too?
    >(I know this happens to me since a form set to open at
    centre (auto centre) will open slightly higher if there
    are no toolbars visible at time of opening - hence a copy
    of the form opened after the toolbar is open at the top
    will be lower).
    >>Thanks loads,
    >>Basil
    >.
James - 13 Apr 2004 14:20 GMT
hmmm thats strange as I have done it before and have just
tried it now after reading your post....

Ok let me get it straight first...

You want Access to be maximized at all times no matter
what database you open? or do you just want access
maximized when ever a certain database is open?

Many Thanks

James

>-----Original Message-----
>Thanks for the quick response James.
>
>It's nice to know I'm not alone with the toolbar problem.  Can play a bit of havoc for my forms when people
have customised the way Access looks on their machine.

>Regarding the maximise problem - the solution you suggested does not maximise the Access instance in
Windows - it will maximise the focussed object within the
Access instance.  The difference is visible if
you 'restore down' an Access instance and then re-open -
it won't open maximised.

>Baz
>    
[quoted text clipped - 45 lines]
>     >
>.
Basil - 13 Apr 2004 14:41 GMT
Only necessary for the 1 database.  Does it make a difference that I am running A97

Just to clarify... this is the process I am doing that doesn't work

1. open Access, restore down the instance (so that I can see the deskyop around the edges behind
2. close the instanc
3. Open my databas
3.a The autoexec in the db runs executing "Maximise" comman

The instance is still not maximised though - desktop still visible around the edges

As I understand it, the command wouyld do nothing since at that stage nothing is open within my Access Instance (hence there is nothing to be maximised within it).  The helpful would follow this thought that the command only maximises items WITHIN the Access instance

Help states
You can use the Maximize action to enlarge the active window so that it fills the Microsoft Access window

If following the steps I've written above, you get the instance to maximise... I'd love to know why/how

Thanks for persevering for me

    ----- James wrote: ----
   
    hmmm thats strange as I have done it before and have just
    tried it now after reading your post...
   
    Ok let me get it straight first..
   
    You want Access to be maximized at all times no matter
    what database you open? or do you just want access
    maximized when ever a certain database is open
   
    Many Thank
   
    Jame
   
    >-----Original Message----
    >Thanks for the quick response James
    >>It's nice to know I'm not alone with the toolbar
    problem.  Can play a bit of havoc for my forms when people
    have customised the way Access looks on their machine
    >>Regarding the maximise problem - the solution you
    suggested does not maximise the Access instance in
    Windows - it will maximise the focussed object within the
    Access instance.  The difference is visible if
    you 'restore down' an Access instance and then re-open -
    it won't open maximised
    >>Ba
    >>     ----- James wrote: ----
    >>     Hi..
    >>     Right as for you maximise thing...  your best option
    would
    >     be to create the autoexec macro and just put the
    command
    >     maximise in there... that will maximize access for
    you
    >>     Ok as for the second question..
    >>     I have tried opening a certain toolbar and then a
    form and
    >     yes it seems to open the toolbar last... I dont have
    an
    >     explination as to why but you not alone it maybe
    default
    >     access behaviour as it may need to check to see if
    the
    >     toolbar is needed or something..
    >>     For the proper and a certain answer maybe someone
    else
    >     could assist... maybe an MVP or someone.
    >>     Hope this Help
    >>     Jame
    >>>-----Original Message----
    >>Hello
    >>>Got no response last time, so was hoping this time
    I
    >     could get a "stop wasting your time Baz" or, if I'm
    lucky,
    >     maybe a tip
    >>>1. Is there any code I can run on db startup that
    will
    >     maximise the current instance of Access in windows
    >>>2. Can someone shed some light on events at
    startup? - eg
    >     If you have an autoexec that is set to open a
    particular
    >     toolbar and then open a form... why will it ALWAYS
    open
    >     the toolbar last, regardless of the order of the
    actions
    >     (also applicable in VBA code run either through
    autoexec
    >     macro or through startup form)
    >>   Could you see if this happens to you too
    >>(I know this happens to me since a form set to open
    at
    >     centre (auto centre) will open slightly higher if
    there
    >     are no toolbars visible at time of opening - hence a
    copy
    >     of the form opened after the toolbar is open at the
    top
    >     will be lower)
    >>>Thanks loads
    >>>Basi
Jim/Chris - 13 Apr 2004 15:30 GMT
The correct macro command is

AppMaximize

Jim

>-----Original Message-----
>Only necessary for the 1 database.  Does it make a difference that I am running A97?
>
>Just to clarify... this is the process I am doing that
doesn't work:

>1. open Access, restore down the instance (so that I can see the deskyop around the edges behind)
>2. close the instance
[quoted text clipped - 4 lines]
>
>As I understand it, the command wouyld do nothing since at that stage nothing is open within my Access Instance (hence
there is nothing to be maximised within it).  The helpful
would follow this thought that the command only maximises
items WITHIN the Access instance:

>Help states:
>You can use the Maximize action to enlarge the active window so that it fills the Microsoft Access window.
[quoted text clipped - 6 lines]
>    
>     hmmm thats strange as I have done it before and have
just
>     tried it now after reading your post....
>    
[quoted text clipped - 12 lines]
>     >>It's nice to know I'm not alone with the toolbar
>     problem.  Can play a bit of havoc for my forms when
people
>     have customised the way Access looks on their machine.
>     >>Regarding the maximise problem - the solution you
>     suggested does not maximise the Access instance in
>     Windows - it will maximise the focussed object within
the
>     Access instance.  The difference is visible if
>     you 'restore down' an Access instance and then re-open -
[quoted text clipped - 3 lines]
>     >>     Hi...
>     >>     Right as for you maximise thing...  your best
option
>     would
>     >     be to create the autoexec macro and just put the
[quoted text clipped - 5 lines]
>     form and
>     >     yes it seems to open the toolbar last... I dont
have
>     an
>     >     explination as to why but you not alone it maybe
[quoted text clipped - 12 lines]
>     I
>     >     could get a "stop wasting your time Baz" or, if
I'm
>     lucky,
>     >     maybe a tip.
[quoted text clipped - 18 lines]
>     there
>     >     are no toolbars visible at time of opening -
hence a
>     copy
>     >     of the form opened after the toolbar is open at
the
>     top
>     >     will be lower).
[quoted text clipped - 4 lines]
>     >
>.
James - 13 Apr 2004 16:03 GMT
Right sorry... In Access 2000 all I have to do is tell it
to Maximize...

Sorry didnt relise you were using A97...

James

>-----Original Message-----
>The correct macro command is
[quoted text clipped - 131 lines]
>>
>.
 
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.