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 3 8779
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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 "
|
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)
|
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...
|
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) ||
|
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".
| |
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?
|
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
|
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
|
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.
|
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...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
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...
| |