Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2007 = Forms

Posted on 2014-11-24
9
Medium Priority
?
258 Views
Last Modified: 2014-11-24
My OS is win 7 prof 64 bit and I use Office 2007.  I have a small and simple database, where I have a Form that displays the data.  whenever I want to do a search, I usually place the cursor in the required field, and then do a control +F, and it brings up a dialog box to enter the search criteria.  But the "Match" criteria defaults fo " Whole Field".  Is there anyway I can change this to "Any part of the field" as the default.
Thank u.
0
Comment
Question by:jegajothy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 total points
ID: 40462299
With the DB open, click file (or the office button) and click "Options" at the bottom.

Select "Client Settings" on the left, then about half way down, you'll find "Default find/replace behavior".  I believe "general search" is what you want.

Jim.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40462302
sorry, but you can't, add more keystrokes after Ctrl F
Alt H, then 'a'
0
 

Author Comment

by:jegajothy
ID: 40462553
in response to Jim Dettman, thank u for your response.  But in my Access 2007, I do not get what u gave. when I click on the Office button, with the db open or Form open, I only see Access Options.  And when I click on this, I see : Popular; current database; datasheet; object designers, etc. etc.
Hope u are using the same Access version as mine.  thank u.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40462572
look in the Advanced options, but still it will not let you change the default setting.
0
 
LVL 22

Accepted Solution

by:
Flyster earned 1000 total points
ID: 40462643
In 2007 select Access Options - Advanced. Under Editing, the fourth option is Default find/replace behavior. Select General Search as Jim stated above.

Flyster
0
 
LVL 58
ID: 40462714
Thanks for jumping in Flyster!

I was looking at 2010.   I think of 2010/2007 being one in the same, but there are differences.

@ jegajothy

 That setting is there...little hard to find but it is there.

Jim.
0
 

Author Comment

by:jegajothy
ID: 40463149
Well done to Flyster.  Thank u and well done.
0
 

Author Closing Comment

by:jegajothy
ID: 40463154
thank u it worked.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 40463466
Glad to help. I too have 2007 in a Window 7 Pro 64-bit environment.

@ Jim- I'll have to take a look at my laptop. It has 2010. Thanks.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

670 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