Access 2003: VBA editor - inadvertantently "damaged" it, it's not showing the sub-windows

Hi EE,

I "damaged" the vba editor, don't know what i clicked on that did this but,
I'm looking for the vba code window to be on the right side of the project explorer and properties window

this is the closest that i got in the screen shot below.
Would like the code window on the right side of screen with horizontal and vertical scroll bars.

Tx for your help, sandra
2010-04-07-vba-editor.GIF
mytfeinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well, you can drag any of those windows where ever you want ...

mx
0
mytfeinAuthor Commented:
Hi mx,

tx for writing,

if i drag the project/properties to the left, the code window takes up the whole window
UNDERNEATH and does not shrink and move to the right....

i found this so far...

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_21400441.html?eeSearch=true

tx, s
0
Richard DanekeTrainerCommented:
The windows are what is known as 'floating' - they are detached from the 'walls'.   They can be 'docked' by dragging the window by the title bar (the top section of the window) to the left until they re-attach or dock.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Rey Obrero (Capricorn1)Commented:
you drag it back to the left side of the vba window
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
s ... here are my docking settings:
Docking.gif
0
Rey Obrero (Capricorn1)Commented:
if you are having difficulty restoring it back, upload your db.
0
mytfeinAuthor Commented:
Hi,

I can move the project, properties, and immediate window to the way it was before.
Please see the screen shot below...
However, the code window is hidden underneath....
I'd like it to appear to the right, with scroll bars

Mx, the first check box by me is also checked....

Any ideas, btw, i went to excel and the same thing is happening "across the board".

tx, s
2010-04-07-vba-editor2.GIF
0
Richard DanekeTrainerCommented:
On the code window, double click its title bar, this will let it maximize within the settings of the other windows.
0
mytfeinAuthor Commented:
oh btw,
the little toolbar on the upper right hand side is software that does the mouse clicks for me
due to carpal tunnel,

 which is probably how i got into this issue,
 bec when the mouse stops moving it automatically clicks so i do not have to use my hand to click
and maybe it clicked on something it was not supposed to.

tx, s
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"Any ideas, btw, i went to excel and the same thing is happening "across the board"."

Because it's common to all Office apps that use VBA.

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mytfeinAuthor Commented:
Hi DDD,

Tx for writing,
when i double click on on code window's title bar, it minimizes itself,
       and it can be dragged, but that's not the effect that i need.

i need the vba icon to be in the upper left corner of screen.

is this a registry issue, everyone, tx, s
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"is this a registry issue, everyone, tx, s"

In fact, the VBA IDE settings are in a Registry key ... which can be moved to different systems and versions of Access, including A2007 and A2010.  So, I can easily retain my custom settings and colors.

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
This is the Reg key:

[HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common]

mx
0
mytfeinAuthor Commented:
Hi Cap,

tx for writing,

i just created a mdb called db1 with a module doing a debug.print.
it will probably be fine on your pc, yet if i downloaded the mdb after you making a change, i will
probably still have the issue.

below is mdb...tx, s
db1.mdb
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Here is my Reg file FWIW:


VbaEditorRegKey-UIAccess.reg
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
s ... you can export out your exist Reg key - save ... and import mine if you like.

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
s ... uploading your file is not going to help, because it will just adapt to our VBA IDE settings.

mx
0
mytfeinAuthor Commented:
ok everyone,

i just googled how to backup registry... will start with that....tx, s
0
mytfeinAuthor Commented:
ok everyone,

our IT has locked us out from the System Restore facility.....
will have to call them... tx, s
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
s ... you shouldn't need to deal with the Registry.  You *should* be able to drag, etc ... the windows to the desired locations.

mx
0
mytfeinAuthor Commented:
Hi mx,

i went to registry, and renamed dock under vba/common   to 2007_04_10Renamed_dock

then opened the db1.mdb file that Cap suggested that i create

and Thank G-d, the docking is restored as in the screen shot below

then i went to my real mdb, and that's working, too

then i opened an excel project, that's working too

Thx so much everyone for writing...

Tx Mx for your additional help, s


2010-04-07-vba-editor3.GIF
2010-04-07-vba-editor4.GIF
2010-04-07-vba-editor5.GIF
0
mytfeinAuthor Commented:
Dear Public,

If you get this error, just follow the instructions here (that DatabaseMx confirmed) that i found in the
EE link above

http://www.erlandsendata.no/english/index.php?d=envbavberestorevbewindow

tx, s
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.