In my SQL Service I have a customer name in these formats
Lastname FirstName
Lastname/FirstName
FirstName LastName
FirstName/LastName
It just depends how a user enters it in.
HOw can I search for LastName/FirstName if a users enters a search string of FirstName LastName??
Using VB 2008 with Access database I'm trying to make a search field (txtSearch), but I'm not getting success with code in the button (cmdSearch). I'm making this manually, not using the Query Builder, and the result will be displayed in a datagridview (added to the form dragging the table from the Datasource Panel). So, the datagrid is already populated (with no SQL). What code must I use for the cmdSearch, to return the txtSearch.Text (or part of it) in the Datagridview? I've tried this: "Select Product, Price, Quantity FROM tblProducts WHERE Product LIKE txtSearch.Text & '*'" (but it doesn't work).
View 1 RepliesI have some coding which displays a label if the value of a textbox matches any of the first values of each line in a textfile.[code]....
View 4 RepliesI have a search function in my app which is a groupbox with a textbox that contains the search keyword and a couple of radiobuttons. Do I have to create a keydown event for every single radiobutton and textbox? Or is there a better way? I tried making a keydown event for the groupbox but that didn't work.
If your interested, this is my
Private Sub Search()
Dim textBoxContents As String = txtBoxKeyword.Text
Dim keyword As String = Nothing
[code]....
I have two text files, the first text file has two columns separated by a space (" ") and the second text file only has one column.
The column 1 in text file 1 and text file 2 match albeit in different order, what I'm trying to achieve is for every field in column 1 text file 2 I want to search for column 1 in text file 1 and display the matching column 2 field in column 2 text file 2.
Dim*OpenTextFile*As*String*= IO.Path.Combine("C:Test1.txt")
Dim*OpenTextFile2*As*String*= IO.Path.Combine("C:Test2.txt")
Dim*SaveTextFile*As*String*= IO.Path.Combine("C:Test2.txt")
[code]....
I am making a wrapper program for this game called VFK. It is written in flash. I am trying to make an auto-text feature, but i cant code it, because i dont know how to auto-fill a flash text field.
View 3 RepliesI want to make it so I have a form and a button and a web browser. The web browser will automatically load to a website that has boxes to fill in. In google chrome when i right click on the text box i can find the element or whatever its called. I am just wondering how I can make it so when I press the button it will change the text of the textbox on the website to whatever I want. Also how to make it press a button on a web browser as well.
View 11 RepliesI want to search a string (which contains html source of webpage)and get all text that strinh holds, like:
TC83886783380753647814458
TC27072318654272127623234
...
so, i want to find all text that is located in code between "serviceid=" and "&" (example how it would look in html source/in string: serviceid=TC27072318654272127623234&)
so the result would be only text in that format (starting with TC and 23 numbers following it)
I think i could do it by parsing a string somehow
How can search text on webbrowes? sample :On my web site have text " Welcome to my website " And If search on web have that text then function ...
View 3 RepliesI have a text box called "txtDescription" and listbox called "lstDetails" and a RichTextBox called "rttFullDes.
When the User inputs the search query into the description box(txtDescription) e.g "books" then it returns all the records that contains the word "books" and displays their Id in the listbox(lstDetails). When you click on the IDs it returns the full description in the Description box(rttFullDes)
This all works fine. But i want all the words to be hightlighted. i have got this code which i found.
Dim wordToFind As String = txtDescription.Text
Dim index As Integer = rttFullDes.Text.IndexOf(wordToFind)
While index <> -1
[Code].....
I have create a database program in vb, with 3 forms, on the second form, I have populated it with fields from 'databaseDataSet'.
Basically my question to you is that I want to create a search field at the top of this form that when the user inputs a query, it searches through the last name field and goes to the matching record.
[URL]
I have an access database called BKWThermDB1. Within than I have a table called THERMOWELL_DATA. within this table I have a column called QuoteNumber. All I want to do is search that column for an existing number so I can let the user know that this number already exists and to create a different number. I am using the code below which will tell me my Column exists. How can I alter the code to tell me if a certain number exists within that column?
Imports System.Data.OleDb
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
how do i search a varchar field in a sql database and get rid of the char unless it is an number 0 thru 9 and then add that number to the monthly calendar todays date to determine a due date?
View 4 RepliesI am trying to do a SQL query to see if an Address already exists in my database. My addresses are structure like this:
line1
line2
line3
city
state
zipcode
country
Sometimes line2 and line3 are NULL values in my database.I am using .NET TableAdapter and DataTable to make my query. When I try to pass in my line2 parameter (@line2) it is equal to a string with value = nothing. My database does not interpret this as NULL and says the records don't match, but I know they do? How do I pass in a string = nothing and have it compare to a NULL value in the database as being equal? I have tried string = DBNULL.value but won't compile.I have done similar comparisons with integers etc. using integer = Nullable (of integer) but this does not exist for strings.
What are the steps & code to make a text searcher in visual basic 2008:...........-I select or load the document in wich i want to search the word
View 1 RepliesI have a folder containing about 100 word documents (.docx format)... I want to make a search application for them. How to read a document using the openxml method... but my query is how to search for text, shall I load each one and carry out the search in the textbox?
View 1 Replieshow to search for a word or string in a PDF file & then get it's x/y position?
View 4 RepliesI have this code to search text and replace it in a file. But might it optimized?
Example:
Dim reader As StreamReader
Dim contents As String
Dim writer As StreamWriter
[Code]....
I understand that within a rich field text box you can search for a string and then format that string, but I am looking to change the formating of a certain position in a string regardless of what character is at that position.Can this be done in VB 2008?
View 3 RepliesI'm trying to search for a specific text inside of a textbox.If the text is found, I want all lines above to be deleted.
View 8 RepliesI have a textbox where I want to search for a folder on your computer, Have all folders that resemble that list into a listbox, and when click it on the listbox it opens that folder
View 3 RepliesIm working on a small program that is suppost to make my life easier but im running into a little problem:I want to search active directory using the Description field as the search field but somehow my code below doesnt return anything.[code]
View 2 Repliesi want to ask that how i can open a search page in my vb.net webbrowser with a separate textbox in a tool bar separate from the url text box
View 2 Repliessaving data from a text field and multiple combo boxes to a file on a server in visual basic 2008
View 1 RepliesI have a combo box on my application (working with VB.net) called CmbAttendantstatus. I have sent the dropdownstyle = dropdownlist at the Properties level of the combobox.
There are 200 field types e.g;
Current Attendant
Ever Attendant
Never Attendant etc
The issue is I can only select one from the list, fine, but I want to be able to type the first letter on the combobox and it takes me to the nearest field type rather than looking through the entire drop list. For example I want Never Attendant, I just need to type N and the drop list takes me to anything starting from N and if I add E for example any field starting with NE shows up for selection. Presently, when the dropdownlist is selected you are not allowed to type anything...
What I'm trying to do is parse out some links via a google search and fill a text box with said results. This is the code I have in a module which I call upon inside of a command button.
Imports System.Text
Imports System.Text.RegularExpressions
Module Module1
[CODE]...
I'm trying to search for text that is known to be in a TextBox.
Once it is found, I want to return the line number it was found on.
Also, I would like to know how to delete all blank lines from a TextBox.
These two problems have been plaguing me for the last 2 days.
I am creating a search function which searches a database for keywords in a selected field in FilmTable (name of table to be searched)
This is the SQL I am using:
CODE:
It is saying there is an error in the FROM syntax
I have a question, how would i have a button, then when you click it, it puts the text at the text cursor in the RTF?
View 5 RepliesIm trying to make a search bar that has a Go button now heres where it gets diffcuilt How do i make this search bar take the text in the the text bar and add it into a pre defined weblink and replace a bit of text with that word in the search bar so the user types into the text bar for example they type in NAME HERE so when you click go it taxt for instance [URL] now how could i make it so when you hit the GO button that it takes the text in the textbox and and replaced REPLACE TEXT in the pre defined address and put NAME HERE into the address and then load it up with a web browser and also how would i make it open up with the web browser that the person is useing (since lods of people use diffrent web browsers)
View 3 Replies