How to keep VBA window in Access 2002 main Window ?

  • Thread starter Thread starter Rene
  • Start date Start date
R

Rene

Hello ebery body.

I was used to the Access 97 that keep the VBA windows and
the Access Windows in the same main window.

With Access 2002, I've got 2 separate windows, one for the
tables and so the other for the VBA.

It is very anoying as soon as you works with more than a
DB at a time.

Does anybody knows a way to keep all the windws in only
one main window ?

Thanks for your help and time.

A+
 
Rene said:
Hello ebery body.

I was used to the Access 97 that keep the VBA windows and
the Access Windows in the same main window.

With Access 2002, I've got 2 separate windows, one for the
tables and so the other for the VBA.

It is very anoying as soon as you works with more than a
DB at a time.

Does anybody knows a way to keep all the windws in only
one main window ?

Thanks for your help and time.

A+
Click to expand...

I'm sorry, I don't believe there is any way to do that -- at least not
without extremely low-level Windows-API magic. The VB Editor
environment was divorced from the Access user-interface environment,
starting with Access 2000, and never the twain shall meet.
 
It is not possible AFAIK. It is actually an improvement in A2K & AXP to
make it more uniform across all different flavours of VBAs.

IIRC, you can look at the Title Bar of the window to see which one you are
in. If I have to use 2 copies of Access, I tend to open the first Access,
open its IDE, open the second Access, then open its IDE. In this case, all
the icons in the Windows Taskbar are in order for me to select.
 
Hum...yes..I tend to agree with you.

At first I did not like the separation. However, now, often I do like the
separate IDE.

For example, I can be in the middle of some code...and then whack alt-tab (I
am a real keyboard user anyway......I am instantly transported back to the
ms-access window ready to open, or do something else. In most cases, I am
right back to the form I was designing anyway (this I really like).

And, if your form is in design mode, you can then launch the query builder
for the reocrdsouce. In access 97, you are model if you do this! You cant
view, or go to anything else...let alone the same code window that you just
came from. With the split, you can jump back to the open code window (the
access side is model when you launch the query builder on the form...but
your code IDE is still free...very nice!).

And, as mentioned I use alt tab to make this quick jump....right back to the
code window.

So, there are some benefits to the split IDE. I think the split arrangement
does tend to negate any drawbacks.

I don't mind either setup now. I think ones does have a bit more flexibility
with the split ide to move around (you don't get trapped like you do in
a97).

I will concede that the split IDE is not as "tight" as a97...but gee, you
know? It is just fine!

I don' view the split IDE as penalty anymore...in fact, I kind of like it
now.
 
Oh...more thing...I do hate the "windows in task bar....

I turn that off right away...and all my new start-up code also does this!
 
I did some programming in Word97 & Excel97 (I think) so when Access2K uses
the same IDE, it is already familiar to it.

Yep. I hate the Windows-In-Taskbar, too.
 
If you add a unique Application Title (Tools > Startup...), then it will be easier for you to
differentiate between the two instances of Access, since you'll see the title instead of the
generic "Microsoft Access". The Visual Basic editor will still display "Microsoft Visual Basic"
in both cases (you might see a bit more, if you don't have too much stuff open, but usually I
just see that much or a portion of this string. You can see a "tool tip" if you hover over the
VBE icon in the taskbar, that indicates which database it represents.

_______________________________________


It is not possible AFAIK. It is actually an improvement in A2K & AXP to
make it more uniform across all different flavours of VBAs.

IIRC, you can look at the Title Bar of the window to see which one you are
in. If I have to use 2 copies of Access, I tend to open the first Access,
open its IDE, open the second Access, then open its IDE. In this case, all
the icons in the Windows Taskbar are in order for me to select.
 
OK, it ends my quest for a confortable working space.

Thanks for the help.

Have a nice day.
 
Thanks for your experience and time.

I generaly works with around 10 opened applications at a
time so I appreciate that my code and other usefull
information windows stay in the main container.

Most of my colleage don't like the split between VBA
editor and other applicationlike Excel. It realy confuses
us.

And I think this againt OO design in a broad view of the
term but it is well known that MS is againt OO.

Maybe in the next version this will come as an option like
having a different window for each open objet in Access
letting people works as they like and not as an MS enginer
has decided they like ... at least I hope.

Have a nice day.
 
Albert D. Kallal said:
Hum...yes..I tend to agree with you.

At first I did not like the separation. However, now, often I do like the
separate IDE.

For example, I can be in the middle of some code...and then whack alt-tab (I
am a real keyboard user anyway......I am instantly transported back to the
ms-access window ready to open, or do something else. In most cases, I am
right back to the form I was designing anyway (this I really like).
Click to expand...

Just don't modify code while the form is in Form View.

That can lead to corruption.
 
Albert D. Kallal said:
At first I did not like the separation. However, now, often I do like the
separate IDE.
Click to expand...

I particularly like it when I'm using dual monitors. However I
haven't yet gone as far as Allen Browne who has the right hand monitor
in portrait mode so he can see more of the code.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top