Hi,
I would like that my subform is immediately filtered as soon as one types a
letter in an unbound searchbox in the form.
If one types an 's' the content of the subform shows only records starting
with s
If one continues with 'e' the subform would show the ones starting with se.
If one would correct that to 'e' by going back and removing the 's' the
records would start with an e.
Any suggestions?
Thanks in advance
Michiel
8  1293 
On Thu, 24 Apr 2008 20:20:11 GMT, "Michiel Rapati-Kekkonen"
<nn@nonsense.zz wrote:
Write your code in the <control>_Chang e event.
-Tom.
>Hi,
I would like that my subform is immediately filtered as soon as one types a
letter in an unbound searchbox in the form.
If one types an 's' the content of the subform shows only records starting
with s
If one continues with 'e' the subform would show the ones starting with se.
If one would correct that to 'e' by going back and removing the 's' the
records would start with an e.
Any suggestions?
Thanks in advance
Michiel
great
and thank you
(Dank je)
Michiel
"Tom van Stiphout" <no************ *@cox.netwrote in message
news:ra******** *************** *********@4ax.c om...
On Thu, 24 Apr 2008 20:20:11 GMT, "Michiel Rapati-Kekkonen"
<nn@nonsense.zz wrote:
Write your code in the <control>_Chang e event.
-Tom.
>>Hi,
I would like that my subform is immediately filtered as soon as one types
a
letter in an unbound searchbox in the form.
If one types an 's' the content of the subform shows only records starting
with s
If one continues with 'e' the subform would show the ones starting with
se.
If one would correct that to 'e' by going back and removing the 's' the
records would start with an e.
Any suggestions?
Thanks in advance
Michiel
butbut, how do I know what is in the box?
at the moment of the Change event the content of the control is not yet
recognized.
Or I donot know how to get it from it...
Michiel
"Tom van Stiphout" <no************ *@cox.netwrote in message
news:ra******** *************** *********@4ax.c om...
On Thu, 24 Apr 2008 20:20:11 GMT, "Michiel Rapati-Kekkonen"
<nn@nonsense.zz wrote:
Write your code in the <control>_Chang e event.
-Tom.
>>Hi,
I would like that my subform is immediately filtered as soon as one types
a
letter in an unbound searchbox in the form.
If one types an 's' the content of the subform shows only records starting
with s
If one continues with 'e' the subform would show the ones starting with
se.
If one would correct that to 'e' by going back and removing the 's' the
records would start with an e.
Any suggestions?
Thanks in advance
Michiel
"Michiel Rapati-Kekkonen" <nn@nonsense.zz wrote in message
news:%X******** ******@read4.in et.fi...
Hi,
I would like that my subform is immediately filtered as soon as one types
a letter in an unbound searchbox in the form.
If one types an 's' the content of the subform shows only records starting
with s
If one continues with 'e' the subform would show the ones starting with
se.
If one would correct that to 'e' by going back and removing the 's' the
records would start with an e.
Any suggestions?
Thanks in advance
What you describe is the way that Combo Boxes work with their AutoExpand
property set to Yes (the default setting). If you would clarify what you
are attempting to accomplish, rather than how you intended to accomplish it,
perhaps someone could make a useful suggestion. Perhaps you might even use
a Combo Box, instead of a continuous forms view Form embedded in a Subform,
to perform the function you want.
Tom is correct... I am certain you can, with expenditure of time and effort,
re-implement the AutoExpand functionality for your Subform (the examples of
which I have read did so for a List Box, though I cannot imagine why they
did not use a Combo Box instead).
If you cannot get at the current content, what VBA code are you using? The
complete contents of that text box should be available in the OnChange event
should be available as its Text property -- determining whether an
additional letter has been added, or a backspace deleted one, or the
contents cleared are what will make this more of a challenge than just using
a ComboBox, which has the added benefit of preventing you from going afar
off typing several letters of a non-existent term.
Larry Linson
Microsoft Office Access MVP
Larry Linson
Microsoft Office Access MVP
On Sun, 27 Apr 2008 09:23:48 GMT, "Michiel Rapati-Kekkonen" <nn@nonsense.zz >
wrote:
>butbut, how do I know what is in the box?
at the moment of the Change event the content of the control is not yet
recognized.
Or I donot know how to get it from it...
Michiel
Read the "Text" property of the control. It returns the current displayed
content of the control not the stored value.
strSearch = Me.MyCombo.Text
Wayne Gillespie
Gosford NSW Australia
Thank you
indeed I never used that property before!
Good to know, very good to know.
Michiel
"Wayne Gillespie" <be*****@NOhotm ailSPAM.com.auw rote in message
news:rn******** *************** *********@4ax.c om...
>
On Sun, 27 Apr 2008 09:23:48 GMT, "Michiel Rapati-Kekkonen"
<nn@nonsense.zz >
wrote:
>>butbut, how do I know what is in the box?
at the moment of the Change event the content of the control is not yet
recognized.
Or I donot know how to get it from it...
Michiel
Read the "Text" property of the control. It returns the current displayed
content of the control not the stored value.
strSearch = Me.MyCombo.Text
Wayne Gillespie
Gosford NSW Australia
Thanks for your extensive response,
but it was the Text property, I did not know about.
Now I know, and now it works the way I want it.
Thank you
Michiel
"Larry Linson" <bo*****@localh ost.notwrote in message
news:IE3Rj.2321 $Rk6.2285@trndd c07...
>
"Michiel Rapati-Kekkonen" <nn@nonsense.zz wrote in message
news:%X******** ******@read4.in et.fi...
>Hi,
I would like that my subform is immediately filtered as soon as one types
a letter in an unbound searchbox in the form.
If one types an 's' the content of the subform shows only records
starting with s
If one continues with 'e' the subform would show the ones starting with
se.
If one would correct that to 'e' by going back and removing the 's' the
records would start with an e.
Any suggestions?
Thanks in advance
What you describe is the way that Combo Boxes work with their AutoExpand
property set to Yes (the default setting). If you would clarify what you
are attempting to accomplish, rather than how you intended to accomplish
it, perhaps someone could make a useful suggestion. Perhaps you might
even use a Combo Box, instead of a continuous forms view Form embedded in
a Subform, to perform the function you want.
Tom is correct... I am certain you can, with expenditure of time and
effort, re-implement the AutoExpand functionality for your Subform (the
examples of which I have read did so for a List Box, though I cannot
imagine why they did not use a Combo Box instead).
If you cannot get at the current content, what VBA code are you using?
The complete contents of that text box should be available in the OnChange
event should be available as its Text property -- determining whether an
additional letter has been added, or a backspace deleted one, or the
contents cleared are what will make this more of a challenge than just
using a ComboBox, which has the added benefit of preventing you from going
afar off typing several letters of a non-existent term.
Larry Linson
Microsoft Office Access MVP
Larry Linson
Microsoft Office Access MVP
"Michiel Rapati-Kekkonen" <nn@nonsense.zz wrote
Thanks for your extensive response,
but it was the Text property, I did not know about.
Now I know, and now it works the way I want it.
Content is available in the .Text property or the .Value property (the
latter is the default property of a Control). It can be an interesting read
to learn the differences, but in the long run, may just be easier to try
..Value (or nothing, using the default to .Value) and then try .Text when
that doesn't do what you want.
Larry Linson
Microsoft Office Access MVP This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jason |
last post by:
I am trying to filter records in a primary form based on records in
related tables. The data in the related tables is being displayed in
the primary form
through subforms. To be more specific, I have a primary form named
TestResults, which is connected to data in a table named TestResults.
There are basically two other tables that are related to the
TestResults table (and the primary form) named Names-Normalized and
SiteAddresses. The...
|
by: Jon Davis |
last post by:
How do I get the Immediate window back? It seems to be gone. Command window
doesn't work. "View" menu items don't seem to show it
Jon
|
by: Russell Stevens |
last post by:
Can anyone tell me how to get to the immediate window in VS2005. The help
file says (when debugging) to click Debug, Windows, Immediate. There is no
Immediate window listed there, nor anywhere else I can find it.
Also, is there a trick now to single step. I can't find that anywhere
either.
Thanks
Russ Stevens
|
by: |
last post by:
Hello,
Does anyone have an idea on how I can filter the data in the gridview
control that was returned by an sql query?
I have a gridview that works fine when I populate it with data. Now I want
to look at that data and filter it based on what is in it.
I know that this could have been done with data sets and data views in
asp.net 1.1 but how is this done now in asp.net 2.0?
|
by: JUAN ERNESTO FLORES BELTRAN |
last post by:
Hi you all,
I am developping a python application which connects to a database
(postresql) and displays the query results on a treeview. In adittion to
displaying the info i do need to implement filtering facility for all the
columns of the treestore/liststore model in order to allow the user an easy
search method to find the desired information.
The treestore is created with information related to cars, the columns are:
| | |
by: vul |
last post by:
In VB6 I used to use Immediate Window to get or change values of variables.
It is very convenient while debugging. I used drag and drop operation to
paste the variable name into Immediate Window. In VB 2005 this approach
either doesn't work or I need to do it some different way. Of course VB 2005
environment allows to see values right in the code window, but it's true
only for not too long strings. With a long string I still need Immediate...
|
by: dgk |
last post by:
Using VS2005 Standard Edtion, I have an Immediate window during ASP
debugging. My co-worker, using VS2005 Team Edtion does not have an
Immediate window. He does have a Command window, which is sort of ok
but doesn't have intellisense. Documentation shows that editions above
Express do have immediate windows.
We've looked under Debug, View, and just about everywhere else. I
don't see the Immediate window under View on my system either,...
|
by: Harry Haller |
last post by:
Hello, I want to implement a generic list which will be used to
display 7 columns in a GridView. One should be able to sort, filter
and page each of the 7 columns. Ideally the filter should be
implemented simultaneously for multiple columns - but the data need
only be sorted by a single column at a time. Sorting should be both
ascending and descending.
I'm currently using a DataView but it's far too slow, because there
are a large...
|
by: Frank Rizzo |
last post by:
I am using the Immediate Window a lot to see the progress of the
application. In VS2003, if your cursor was at the very bottom, the
window would scroll down whenever something new showed up. If your
cursor was somewhere in the middle of the text output, then there would
be no scrolling.
In VS2005, the Immediate Window scrolls regardless of where the cursor
is which is very annoying. Sometimes you want to go back up in the
window to...
|
by: Rahul Babbar |
last post by:
Hi,
I have the following doubt.
Suppose I use the execute immediate statement and the statement to be
executed is a Select statement from the sysibm.sysdummy1 table which
will always return me one row.
Further, i need to capture the result of the execute Immediate into a
|
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: 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();...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |
