Repost: Maximise Instance & Startup event order

[Basil]

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]

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).

 

[Basil]

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,

could get a "stop wasting your time Baz" or, if I'm lucky,
maybe a tip.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).

 

[James]

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.

 

[Basil]

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

problem. Can play a bit of havoc for my forms when people
have customised the way Access looks on their machinesuggested 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

 

[Jim/Chris]

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
3. Open my database
3.a The autoexec in the db runs executing "Maximise" command

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.

 

[James]

Right sorry... In Access 2000 all I have to do is tell it
to Maximize...

Sorry didnt relise you were using A97...

James