Finding things (1 Viewer)

K

kirkm

Registered User.

Local time

Today, 11:12

Joined

Oct 30, 2008

Messages

1,257

• Apr 29, 2019

• #1

I'm not used to access 2010 so simple thing drive me batty. I have a query half designed, but had to Open a Table... now I can't find the query. Is there a "Windows" type option anywhere in Access?
I can get back to it by long and tedious method (the LH column of components) but it's way too big to navigate easily.
Is there any better way ? Thanks.

 

essaytee

Need a good one-liner.

Local time

Today, 09:12

Joined

Oct 20, 2008

Messages

512

• Apr 29, 2019

• #2

In the left hand column, there is a search bar, enter partial element of your query (form, module, table etc) and the list will be accordingly filtered.

 

K

kirkm

Registered User.

Local time

Today, 11:12

Joined

Oct 30, 2008

Messages

1,257

• Apr 29, 2019

• #3

The left hand column is the list of Tables, Forms, Queries etc This is where a search bar is ?
Can't see one here, must it be turned on somehow ?

 

essaytee

Need a good one-liner.

Local time

Today, 09:12

Joined

Oct 20, 2008

Messages

512

• Apr 29, 2019

• #4

Right click in panel, select 'Navigation Options'. A dialog opens, you'll see a checkbox for 'Show Search Bar'.

 

K

kirkm

Registered User.

Local time

Today, 11:12

Joined

Oct 30, 2008

Messages

1,257

• Apr 29, 2019

• #5

Thank you. Got it.