Access 2003 startup question

[Fuzzy Logic]

I recently upgradd from Access 2000 to Access 2003 and it used to startup with my Favorites Group selected
and open. This no longer happens and opens to Groups but not the Favorites. Any idea how I can get it to open
to my Favorites Group at startup?

TIA

 

[Joseph Meehan]

I recently upgradd from Access 2000 to Access 2003 and it used to
startup with my Favorites Group selected and open. This no longer
happens and opens to Groups but not the Favorites. Any idea how I can
get it to open to my Favorites Group at startup?

TIA

Do you mean the default file location? ? ?

 

[Fuzzy Logic]

Do you mean the default file location? ? ?

Nope. On the left side of Access is Groups and Objects. Under Groups is Favorites. I want this Group to open
by default.

 

['69 Camaro]

Hi.

Any idea how I can get it to open
to my Favorites Group at startup?

There's no setting or function for this. The only way I can think of is to
create an Autoexec macro with the following settings that will tab over to
the Favorites group when the database is opened:

Action: Sendkeys
Keystrokes: {TAB}{TAB}~
Wait: No

Whenever you open the database, these keys will automatically be executed,
but beware that it may have unintended consequences. At the very least, if
you have the VB Editor open and compact the database, the database reopens
to the VB Editor, not the Access window, so these keys are sent needlessly.
If other processes are going on at the same time, processing these key
strokes could be harmful. Sendkeys isn't recommended except as a last
resort.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Fuzzy Logic]

in
Yuck...I wonder why it defaults there in Access 2000 just fine?

Thanks for the reply.

 

['69 Camaro]

You're welcome.

Yuck...I wonder why it defaults there in Access 2000 just fine?

Each new version is an improvement over the last version. In Access 2007,
it's so different that there's no Database Window any more, so you'll have
to come up with a whole different approach.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Fuzzy Logic]

[email protected]:

Sigh, Microsoft's idea of improvements and mine are obviously different.