[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

The search box on the naigation bar - use it elssewhere.

Posted on 2011-03-03
6
Medium Priority
?
238 Views
Last Modified: 2012-08-13
Hello,

I love the search box on the Navigation bar but I am using my own record navigation from the ribbon so would like to remove these  - which you can't do without removing the search box.

Can you get at the search box from anywhere else? I like the simplicity of it over the filter options. It would be good just to have it on the ribbon.

I have a lot of tables and forms and don't what to create a complicated custom search. I just want the search box!

If you hads to recreate it is there a quick and dirty way ...

find "whatever entered in a box"  in Screen.ActiveForm.RecordSource

Thanks,

Lou
0
Comment
Question by:Louverril
  • 3
  • 2
6 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35026661
Lou,

You might not get what you want. It is part of the "module' of record navigation.

You might have no choice except to customize your own search box.

Sincerely,

Ed
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35029618
You can turn it off:
Office Button-->Access Options-->Current Database-->Navigation-->Navigation Options-->Display Options
Then Uncheck "Show Search Bar"

But, AFAIK, you cannot "Move" it anywhere else.

"it is there a quick and dirty way ...
find "whatever entered in a box"  in Screen.ActiveForm.RecordSource"

You syntax here presumes that the object they are searching for:
Is Open
Has the focus
Is a Form (Or Is an object that has a Recordsource)
Is spelled out completely and Correctly.
However this is not entirely the way the Searchbox works.

Also, you are looking for the recordsource, so I don't see how that even has anything to do with the navigation pane Search...?

So can you please state your *ultimate* goal here is?
Search for an object?
Search for a form?
Search for the Active form's recordsource?
Search for a Form or Report recordsource?
All of the above?
...ect?
...and state the exact scenario that a user would go through to do this.

Perhaps there is a more efficient way of doing this than trying to clone and modify the Nav Pane Search functionality.

JeffCoachman

0
 

Author Comment

by:Louverril
ID: 35068455
Jeff,

I just wanted the search box without the record navigation stuff.

People like it's simplicity. My users find it very easy and quick to use. Please ignore my syntax what I was trying to say was something that does what the search box does.

As mentioned I don't want (can't justify the time!) to create a complex custom search. It's not worth it as the users have access to the filter commands on the ribbon and various combo  boxes. But these are not as quick and simple as the search box.

If as it  seems the search box can't be moved then "in an ideal" world I would want something that does the same thing for the active screen from the ribbon. The search box appears to search the currently displayed record (all fields)  and then a sort of findfirst for all the fields in the recordset..

Lou







.

0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 35071286
Yeah, I did this once for a client and it was a bit complex, but it worked out nicely...

;-)

JeffCoachman
0
 

Author Comment

by:Louverril
ID: 35082561
Thanks Jeff.

There is no need for me go to those lengths for this application.

Will close the question.

Thanks again.

BTW have you seen this question of mine?  http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26872052.html
 If you have two PC's available and a bit of time please install the attachments and see what I mean. It's ANY memo field.  Try setting one up yourself!

Best wishes Lou
0
 

Author Closing Comment

by:Louverril
ID: 35439617
Unfortunately there is no easy solution apparently. But At least I know that now.

Thanks Jeff.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

591 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