Solved

Problem with code search box

Posted on 2014-11-04
11
164 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 34

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
 
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 34

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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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 34

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now