473,735 Members | 2,091 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

default settings for search and replace dialogbox

jj
Hi NG

I have a form, where I can activate the search and replace dialogbox when
pressing a button.

My problem is that the dialogbox opens with the default that it should
search for full match only, and I want it to open with default "a part of
field".

The VBA used is:
docmd.domenuIte m acformbar, acEditmenu, 10, , acMenuVer70

How do I change it to default "A part of the field"?

Thanks in advance
Nov 13 '05 #1
3 8786
Hi.

You won't be able to control these settings with VBA 4.0 code, which is what
Access 95 uses. (acMenuVer70 is for version 7.0, or Access 95, and
DoMenuItem has been deprecated since Access 97.)

To apply the search option in VBA code, use the DoCmd.FindRecor d( ) method.
Use acAnywhere as the second argument of this method to search in any part
of the field.

However, it would probably be easiest if you just changed the default option
setting for Access. To do so, select the Tools -> Options menu to open the
"Options" dialog window. Select the "Edit/Find" tab. Select the "General
Search" option button at the top left of the window, then the "OK" button to
close the window. Access will continue to use your current setting that
you've already manually applied in the "Find And Replace" window (whether
it's "Any Part of Field," "Whole Field," or "Start of Field") for any future
search during your current session. However, the next time you open the
database in Access, it will use your new default "Any Part of Field" for
searches, so you won't have to apply it manually again.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"jj" <jj@get2net.d k> wrote in message
news:41******** *************@d read11.news.tel e.dk...
Hi NG

I have a form, where I can activate the search and replace dialogbox when
pressing a button.

My problem is that the dialogbox opens with the default that it should
search for full match only, and I want it to open with default "a part of
field".

The VBA used is:
docmd.domenuIte m acformbar, acEditmenu, 10, , acMenuVer70

How do I change it to default "A part of the field"?

Thanks in advance

Nov 13 '05 #2
jj
Great - thanks alot!
"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAM> wrote in
message news:sha%c.6683 $vI2.4502@trndd c02...
Hi.

You won't be able to control these settings with VBA 4.0 code, which is what Access 95 uses. (acMenuVer70 is for version 7.0, or Access 95, and
DoMenuItem has been deprecated since Access 97.)

To apply the search option in VBA code, use the DoCmd.FindRecor d( ) method. Use acAnywhere as the second argument of this method to search in any part
of the field.

However, it would probably be easiest if you just changed the default option setting for Access. To do so, select the Tools -> Options menu to open the "Options" dialog window. Select the "Edit/Find" tab. Select the "General
Search" option button at the top left of the window, then the "OK" button to close the window. Access will continue to use your current setting that
you've already manually applied in the "Find And Replace" window (whether
it's "Any Part of Field," "Whole Field," or "Start of Field") for any future search during your current session. However, the next time you open the
database in Access, it will use your new default "Any Part of Field" for
searches, so you won't have to apply it manually again.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"jj" <jj@get2net.d k> wrote in message
news:41******** *************@d read11.news.tel e.dk...
Hi NG

I have a form, where I can activate the search and replace dialogbox when pressing a button.

My problem is that the dialogbox opens with the default that it should
search for full match only, and I want it to open with default "a part of field".

The VBA used is:
docmd.domenuIte m acformbar, acEditmenu, 10, , acMenuVer70

How do I change it to default "A part of the field"?

Thanks in advance


Nov 13 '05 #3
You're welcome!

Gunny
"jj" <jj@get2net.d k> wrote in message
news:41******** *************@d read11.news.tel e.dk...
Great - thanks alot!
"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAM> wrote in message news:sha%c.6683 $vI2.4502@trndd c02...
Hi.

You won't be able to control these settings with VBA 4.0 code, which is what
Access 95 uses. (acMenuVer70 is for version 7.0, or Access 95, and
DoMenuItem has been deprecated since Access 97.)

To apply the search option in VBA code, use the DoCmd.FindRecor d( )

method.
Use acAnywhere as the second argument of this method to search in any part
of the field.

However, it would probably be easiest if you just changed the default

option
setting for Access. To do so, select the Tools -> Options menu to open

the
"Options" dialog window. Select the "Edit/Find" tab. Select the "General Search" option button at the top left of the window, then the "OK" button to
close the window. Access will continue to use your current setting that
you've already manually applied in the "Find And Replace" window

(whether it's "Any Part of Field," "Whole Field," or "Start of Field") for any

future
search during your current session. However, the next time you open the
database in Access, it will use your new default "Any Part of Field" for
searches, so you won't have to apply it manually again.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"jj" <jj@get2net.d k> wrote in message
news:41******** *************@d read11.news.tel e.dk...
Hi NG

I have a form, where I can activate the search and replace dialogbox

when pressing a button.

My problem is that the dialogbox opens with the default that it should
search for full match only, and I want it to open with default "a part of field".

The VBA used is:
docmd.domenuIte m acformbar, acEditmenu, 10, , acMenuVer70

How do I change it to default "A part of the field"?

Thanks in advance



Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

22
11119
by: Phlip | last post by:
C++ers: Here's an open ended STL question. What's the smarmiest most templated way to use <string>, <algorithms> etc. to turn this: " able search baker search charlie " into this: " able replace baker replace charlie "
5
2635
by: pembed2003 | last post by:
Hi all, I need to write a function to search and replace part of a char* passed in to the function. I came up with the following: char* search_and_replace(char* source,char search,char* replace){ char* result; size_t l = strlen(source), r = strlen(replace), i; int number_of_replaces = 0; for(i = 0; i < l; i++){ if(source == search)
3
5574
by: C# Learner | last post by:
Is it possible to set a command button to the "default" button of the form? Here's an example of what I mean -- press Start -> Run. Notice that the "OK" button has a dark rectangle around it, and when you press ENTER, this "OK" button's Click event handler is eventually fired. I was expecting Button to have a Default property, but can't seem to find anything like it...
32
14881
by: tshad | last post by:
Can you do a search for more that one string in another string? Something like: someString.IndexOf("something1","something2","something3",0) or would you have to do something like: if ((someString.IndexOf("something1",0) >= 0) || ((someString.IndexOf("something2",0) >= 0) ||
1
1969
by: foreman | last post by:
Hello Everybody: I am trying out DialogBox, and I have been trying to press the OK Button on the dialogbox hoping I can receive the OK DialogResult to Main Form. Below is my OK button click event handler code on AboutBox Dialogbox: DialogResult = DialogResult::OK; It can also dismiss the dialogbox and return OK "Ideally".
3
1661
by: majid | last post by:
When i show a webform as a dialogbox using showModalDialog script any postback event in dialogbox cause a new window pops up . How can i control the postback?
6
1992
by: Robert_5032 | last post by:
when our users press "Search and Replace" all is fine exept that they ALWAYS have to change the criteria "Match the hole field" to "Part of the field" (ruffly spelled...(swedish lang)). -Is there anyway to change/ add some code so that the search dialogbox shows with this already done? That would make me happy Thank you for any clue! Robert
9
3418
by: joemo2003 | last post by:
Please help. I created a custom dialogbox name "DialogBox". What i want is input values to the dialogbox, and those values appear on a textbox in Visio. After i creat the textbox and the dialogbox, I used "DialogBox.show", so i can enter values, and I use "ashape as shape", "ashape.Text=userinput", then how should i defind "userinput"? Thanks
10
10800
Shakss2
by: Shakss2 | last post by:
I have a form, where I can activate the search and replace dialogbox when pressing a button. My problem is that the dialogbox opens with the default that it should search for full match only, and I want it to open with default "a part of field". I did change it to default "A part of the field"? by going to Tools -> Options menu to open the "Options" dialog window. Select the "Edit/Find" tab. Select the "General Search" option button.
0
8959
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8784
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9462
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8199
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6049
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4558
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3270
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2738
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2187
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.