473,396 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Access 2003 defaults

Hi
Does anyone know how to chage the
following default setting in Access 2003?

Under "Find and Replace" the default setting
is "Whole Field", I want to change it to
"Any Part of Field".

Is there any way to do this?

Thanks, Bob
Oct 8 '08 #1
4 1345
missinglinq
3,532 Expert 2GB
Choose Options from the Tools menu. On the Edit/Find tab, set:

Default find/replace behavior

to:

General Search

If I remember correctly, you'll have to close Access then re-open it before this change takes place.

Welcome to Bytes!

Linq ;0)>
Oct 8 '08 #2
ADezii
8,834 Expert 8TB
To do it in code would be:
Expand|Select|Wrap|Line Numbers
  1. Application.SetOption "Default find/replace behavior", 1
Oct 8 '08 #3
missinglinq
3,532 Expert 2GB
Keeping in mind that after the code executes, Access still has to be closed then re-opened before the changes take place.

Linq ;0)>
Oct 8 '08 #4
Choose Options from the Tools menu. On the Edit/Find tab, set:

Default find/replace behavior

to:

General Search

If I remember correctly, you'll have to close Access then re-open it before this change takes place.

Welcome to Bytes!

Linq ;0)>
Thank You, this is what I was looking for. Bob
Oct 10 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Mike Thomas | last post by:
I have two clients now who want to have an Access 2000 & 2002 application running on NT Server 2000 do some file updating at night when nobody is in the office. I have used Windows scheduler to...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
11
by: rkershberg | last post by:
Recently converted the entire office to Access 2003 as a by-product of upgrading all users to XP sp2 and Office 2003. My performance on the Access 2003 datasheet view of a bound (to an...
3
by: kihoshk | last post by:
Hi, I have a C# app that needs to copy files from the local machine to another on a WORGROUP network (not a domain). The app is running as a service under the SYSTEM account. When an attempt is...
37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
3
by: mishj | last post by:
Just want you all to know (just in case you have this issue) that some standard sql doesnt work by default in MS ACCESS 2003 anymore (I didnt know this, not sure if others do or not - and I couldnt...
6
by: Roger | last post by:
if I make a copy of northwind.mdb sample and import data till it reaches 350Gb in size and then I make a second copy of northwind then I open nw1.mdb and do a compact / repair that takes 30-60...
1
by: janetopps | last post by:
I used a database transfer utility (Bullzip) to move data from Access to MySQL Asp pages, I couldn't transfer the data if i did not opt to leave the default values, therefore the default values...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.