Solved

Access 2007 = Forms

Posted on 2014-11-24
9
247 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
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 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 119

Expert Comment

by:Rey Obrero
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
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 40462572
look in the Advanced options, but still it will not let you change the default setting.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 22

Accepted Solution

by:
Flyster earned 250 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 57
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Outlook Free & Paid Tools
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…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

930 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

18 Experts available now in Live!

Get 1:1 Help Now