Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

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

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
Louverril
Asked:
Louverril
  • 3
  • 2
1 Solution
 
MINDSUPERBCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
LouverrilAuthor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Jeffrey CoachmanMIS LiasonCommented:
Yeah, I did this once for a client and it was a bit complex, but it worked out nicely...

;-)

JeffCoachman
0
 
LouverrilAuthor Commented:
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
 
LouverrilAuthor Commented:
Unfortunately there is no easy solution apparently. But At least I know that now.

Thanks Jeff.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now