Is it possible for a textbox to predict phrase as user types in?I know comboboxes can make it happen but what if I want a text box to do the same and predict string?
12 3593 NeoPa 32,566
Recognized Expert Moderator MVP
It's probably possible, but would involve quite a bit of coding and handling of characters at a low, and detailed, level.
Okay.If it is possible then how?I searched a lot but could not find any relevant idea.
NeoPa 32,566
Recognized Expert Moderator MVP
It would involve building a database to handle the possibilities and managing keystrokes manually. This is so large a project that it is not an appropriate question for these forums. Having said that, it may not be clear how large a project it is without understanding what it involves, so I understand why you might ask it.
Essentially, this is much, much bigger/more complicated than you might have thought, and if you're asking for help at that level then I very much doubt you could handle it.
If you disagree, then the first step would be to do the consideration for the project of exactly what you would need in such a project. If you were to do a proper job of that then I suspect you'd start to understand why I say what I do.
- 'declare global variable
-
Dim lastSrchs[] As String
-
Dim i As Integer = 0
-
-
'button click code
-
lastSrchs[i] = textboxSearch.text
-
i = i + 1
-
-
'textbox change code
-
Dim isTriggerX As Boolean
-
Dim chrToCompare As String
-
Dim chrOflastSrch As String
-
chrToCompare = Trim(txtboxSearch.text)
-
isTriggerX = 0
-
For x = 0 To i
-
chrOflastSrch = Trim(lastSrchs[x])
-
if chrOflastSrch = chrToCompare Then
-
listboxRelated.add lastSrchs[x]
-
listboxRelated.Visible = 1
-
isTriggerX = 1
-
End if
-
If isTriggerX = 0 Then
-
'clear list.
-
End If
-
Next x
im not sure about this codes.. but i think array can be used as data storage.. if the system is closed the array will reset.
or else..
you are willing to save the array values in your database.. which is not good at all.. because theres a high posibility that you save nonsense data in your database. making your database crowded. =)
NeoPa 32,566
Recognized Expert Moderator MVP
Please review Before Posting (VBA or SQL) Code.
@rekedtechie
I have to disagree strongly with your analysis. Anything other than a table to store the information would be wholly inappropriate and would fail to manage and reflect previous usage. Managing the entries used only in the current session would be pointless, as the data across that session wouldn't even start to be worth the effort.
I can't say too much about the code except that we like compiled code here for good reason. Such code that is uncompiled and uncompilable tends only to mislead users. Even looking at it as pseudo-code I fail to see how it can be considered even as illustrating the fundamental logic required for this question. The obvious omission of any event procedures indicates clearly it cannot correctly handle the problem raised.
I'm not here to have a go at your code. I just felt it was important not to allow the idea that it is a viable solution to go unchallenged, as it misleads those less experienced and less capable members into following a dead-end path.
@mod[NeoPa]
im sorry but i dont have PC at home..
i do all my school project at computershop, and that makes me 'ughh..' for the rest of my college life..
i need to bypass all security just to make my assignments..
thats the reason why its so hard being a poor..haha :))
-but thanks to your post now i know that i dont need to create a project that will save temp data..im trying to relate with vba.. because i saw macros before and its totaly looks like vb6.. =)
I would like to know why you are so adamantly against using a combobox?
You can make a combobox act more like a textbox if that is what you require, and its far easier then making a textbox act like a combobox.
NeoPa 32,566
Recognized Expert Moderator MVP
Who's adamantly against use of the ComboBox Smiley?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: refer_to_website |
last post by:
My VB.NET web application has a textbox where the user is allowed to
enter up to 50 characters. I have a label on the form next to the
textbox that tells the user how many remaining characters he can
enter. This label needs to be refreshed on the fly each time the user
types a character into the text box.
Eventually, the user will click the SAVE button on the web form, and
the data he entered in the text box will be written to the...
|
by: Allen Browne |
last post by:
If you are looking for opinon on what's useful in Access 2007, there's a new
article at:
http://allenbrowne.com/Access2007.html
Covers what's good (useful features), what's mixed (good and bad), what's
gone (features removed), what's fixed (old issues solved), what's broken
(new bugs), configuration, compatibility, should you buy, and links.
It is opinion, so you may disagree, but hopefully it's an informative
summary.
|
by: Neil |
last post by:
Just found out that the Microsoft Rich Textbox does not support full text
justification, since it's based on Version 1.0 of the RichEdit Window Class,
and full text justification is only available in versions 3.0 or later of
the class.
However, also just found out that the new Rich Text property in Access 2007
ALSO does not support full text justification! This seems incredible, that
MS would create a brand new application, and not...
|
by: Neil |
last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text
feature does not support: a) full text justification; b) programmatic
manipulation.
I was hoping that someone might know one way or the other whether that was
true or not, or could point me to an article or help text that would. What I
have seen so far online and in Access 2007 help seems to confirm the above.
But that (or at least (b)) seems incredible that it...
|
by: PatdeLux |
last post by:
Hi,
I have have an Access 2003 application with Sql Express as back end.
After migrating the front end to Access 2007, users have a serious
problem:
One form contains text controls bound to date fields.
When one user opens the form and clicks the date control, the
application does not react for about 10 seconds.
If the user types a date in that time, the characters appear only
after that 10 sec. period.
| |
by: Robert S. |
last post by:
Searching some time now for documents on this but still did not find
anything about it:
Is it possible to replace the entry screen of MS Office Access 2007 -
that one presenting that default 'templates' (with that big graphic
buttons) - with some sort of own HTML-Page? I could imagine, that
somehow it is possible to change this construction (hopefully not
hardcoded in MS-Acc07), like it is possible to edit the 'Fluent Ribbon'?
If so...
|
by: blueskies |
last post by:
Hi All,
Can someone please advise how to create users and user groups in Access 2007. In 2003 it was simple and straight forward, and at the risk of sounding stupid I can't find the same interface in ver.2007.
Any help will be appreciated.
|
by: HSXWillH |
last post by:
I'm working in Access 2007 and coming to something that's always caused me problems. I have a form titled frmUsers. There are 3 subforms that list exercise dates and exercise types for each user. My goal is for whenever you click on any of the subform listings that a report will pull up with that date's activity.
Main Form = frmUsers
Subform item = Workout_List
Subform name = frmList_Workout
OnClick field = Workout_Date in the subform...
|
by: Seun Oguntomini |
last post by:
Hi,
How are you and work? Pls am a user of Microsoft Access 2007. There is need for me to enter multiple words in a field in MS Access 2007 which am finding it difficult to do
For me to be able to enter multiple words in a field, i need word wrap which am finding it dificult to get in Access 2007 Menu
So, i need a clue to how to use word wrap in table view of Microsoft Access 2007
Thanks and waiting for your response
Regards,
|
by: Elaine Huseby |
last post by:
I have a form "PartsAndInvoices that has all the parts in the database listed in split form view. I want the user to use Access 2007's filter section on the ribbon to choose mutiple filters. Me.Filter may equal (.="dnr1940"). I tried pass ing me.filter to the report but get all the records in the report not the custom filtered set.
Private Sub cmdPartsNInvoiceReport_Click()
Dim strFilter As String
strFilter = ""
If Me.Filter = ""...
|
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: 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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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...
| |