Solved

Problem with code search box

Posted on 2014-11-04
11
167 Views
Last Modified: 2014-11-05
My code search box is jammed at the top of the screen and is therefore useless.  See attached image.  

Any advice?

Thanks in advance.
Capture.JPG
0
Comment
Question by:CRB1609
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 10

Expert Comment

by:etech0
ID: 40423057
Make sure that Access is maximized. That might help.
0
 
LVL 24

Accepted Solution

by:
Bitsqueezer earned 250 total points
ID: 40423910
Hi,

fortunately the search window is a normal window so you can simply activate the window by clicking on it, then press CTRL-Space (which opens the system menu) and then "M" for "Move". Press any cursor key, that will move the window. It also attaches the window to the mouse so if you press a cursor key once you can then also move the window with the mouse (without clicking a mouse button).

That works with any window in Windows if it is not a special window created by the application.

By the way, since Windows 7 you can use the Windows key with the cursor keys to quickly resize and move a window (also between screens) but unfortunately that doesn't work with the find window in VBA.

Cheers,

Christian
0
 
LVL 35

Assisted Solution

by:PatHartman
PatHartman earned 250 total points
ID: 40424004
Hi Christian,
That didn't work for me.  The "solution" I found was to open the main window and reduce its size and bring it down from the top of the screen.  Then when the dialog opens, there is room above to fit the whole box.  Move the box down to the middle of the screen.  Hopefully, Access will remember that spot and open the dialog there the next time.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 24

Expert Comment

by:Bitsqueezer
ID: 40424094
Hi Pat,

what didn't work? If you performed it like described above there should be no problem (I tested that of course).
Unfortunately Access doesn't remember the coordinates where you had the search box, it always tries to position it outside of the code window. If you've moved it succesfully to grab it it is a good idea to enable the immediate window and move it there so it mostly keeps this place until your next VBA session.

Cheers,

Christian
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 40424296
activate the window by clicking on it, then press CTRL-Space
That cleared the search field and did not open the system menu (I'm not sure I've ever seen the menu you are talking about).
0
 
LVL 24

Expert Comment

by:Bitsqueezer
ID: 40424717
Hi Pat,

you're right, sorry, I wrote CTRL-Space but it is of course ALT-Space what I meant.

That opens the system menu in any window, this is a relict from at least Windows 3.1 where you closed a window with a double click on the upper left corner. A single click opens the system menu. This works only if the window has an icon, but ALT-Space also works if the window at least has a system menu enabled which is the case with the find window in VBA.

Cheers,

Christian
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 40424756
OK, we've made progress.  ALT-Space brings up the dialog and pressing the M key activates the four-headed cursor.  remove your finger from the alt key and then the four arrow keys work:)
Thanks Christian.  I wonder if the same technique works on the relationships page when it goes kerfuey and tables slip up off the top or left.
0
 

Author Closing Comment

by:CRB1609
ID: 40424796
Thanks very much.  You've saved me a lot of grief.  Interestingly,  I have 2 screens and this only happened on screen 2.

CRB
0
 
LVL 24

Expert Comment

by:Bitsqueezer
ID: 40424822
No, unfortunately not, as the relationship window is an MDI window. You can move this window completely (if you have not enabled the tabbed windows) but you cannot do anything with it's contents. The displayed tables looks as if they are windows but they are only graphic elements (maybe based on a window base class but not with the complete functionality of an application window).
0
 
LVL 24

Expert Comment

by:Bitsqueezer
ID: 40424846
Hi CRB,

that also depends on the relative positions of the screens, mostly if the are not of the same size or vertical position. I'm afraid there's nothing you can do about that as the VBA editor always places the find window wherever it thinks that's OK.

I recommend to let it open during a VBA session and move it to the lower right corner so you can grab it when you need it.

The VBA editor was made in an era when more than one screen was really seldom...:-)

Cheers,

Christian
0
 

Author Comment

by:CRB1609
ID: 40425094
Thanks, Christian.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question