o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Simple Search Database -

Dear Gurus

I have been developing databases in Access and know VBA fair bit but I have never developed a database in VB.

I had to develope a simple database comprising of just one table Contacts and all I want is one text box to enter full and partial name and one subform displaying the matching results. When you click on one of the record it shows the detail in another form.

I can do this in Access in 30 mins but I have to do it in VB as some one wants a exe file with access mdb so that it will run on non MS Access machines as well.

I am sure some one will have a simple search database that I can make use. I understand VB editor well so it will not be a problem. I just need a simple example in which you search and display records from an Access database.

Thanks in advance

 

Simple Search Database -
Dear Gurus I have been developing databases in Access and know VBA fair bit but I have never developed a database in VB. I had to develope a simple database comprising of just one table Contacts and all I want is one text box to enter full and partial name and one subform displa


Simple search engine -
I've got a database and a simple search screen, that I want to make a little better. I want to create a search text box, so that I can find things like:- Cat Mat I want the screen to search to find Cat and Mat words, I think the term is boolean search, does anyone know any goo


Displaying database results in ASP -
Is there any simple method, when displaying the results of a database search to highlight the parts of the results which matched the search criteria? E.g. Search for any products starting with VBF* Results would be VBForums VBFans VBFanatics but highlighting the VBF part.


Search Page -
Hey, I'm new to ASP. Net and have built a website with an SQL database. I'd like to create a simple search page for records in my database. this simple search will do only filtering of given fields and then will display the results in a different page. could you help me with a sa


Database Search Please Help -
Sorry about posting this again but my Question from a while back was not answered yet so I thought I’ll ask again. I have a simple front End for an Access database and would like to include a Search option. I have looked in my books and did not find anything there. (well it’s prob


Searching through access database.. -
I am trying to create a search button to search through an access 2000 database using Visual basic 6.0. i dont know how to code the search button so that it can go through a database and search all the text fields and everything to look for matches of the search word entered. the user


Search through data -
Since it was my initiation to .net I thought I'd do a simple project using bindingnavigator to connect to my database. I've coded with vb6 but am new to .net and am not sure how to search a database using an sql chain and thereafter display the result in textboxes or labels. Any help o


simple vba search code not working -
ive got a simple piece of code here in VBA in Excel, to search and extract info from an Access database, based on a text box search: Set rs = db.openrecordset("SELECT * FROM Pipeline WHERE Advisor like = '" + Sheet2.TxtAdvisor.Text + "*'") It works fine witho


More Visual basic and access help -
Hello Sorry to keep posting this question. It is now clear that I know nothing about visual basic (.NET) so I would appreciate if you would keep the responses as simple as possible Ok here goes Problem I have to create a vb.net application for a video store it has to include


Making a simple Searcher -
okie im just wondering what i want to do is make a simple searcher from poplular site aka google yahoo ask ect but say like i wana search for all the sites with xbox360 in there URL adreass and list them but only search for what i put in the search box how would i go making a s


Ado DB Search command -
I am building a database for a company and got stuck at the search command that I need. I am using ADO and am pretty new with it so I have lots of questions, but my main one right now is how to get a search engine going. I pretty much have everything coded out so if you need a snippet,


Disabling database search... -
The problem is to get VB to disable a search in a single database but not in others... I have a program that searches in severeal database and wishes to create a function so the user can select wich database to search in if not all!! How can I do this??


Very odd 'search' problem. -
Wotcha, folks. Bit by bit, I'm designing a simple stock & sales database using the Data Control. As sales are made, the stock is adjusted accordingly - that sort of thing. I've also put together a simple search routine using .findfirst. The search routine seems to work oka


Site Search -
I need to add a simple site search to my asp3.0 site with out using the database.I use a select case on my index page and need the results to come from my index.asp page.The site is still in developement at 69.6.219.125 . Whats happenning when i use a simple search is everything comes


How The Cyber World Works -
I know the very simple idea of how a search engine works. You type in a word and it searches (database?). But how does a mainstream search engine (ie Yahoo!, Google, etc.) seach these vast quantities of cyberspace? I mean hundreds upon hundreds of gigabytes in times under a second.


2 questions Registry and database -
I am wondering can you store lots of strings in the registry wittout causing any problems? Like for instance (I know i can use INI or Database but lets just say) you had a list of 40 usernames could you store all of these usernames in the Registry without having it crash or errors lik


Searching a Data Base -
I have written a program that can search a database by six different fields. What is the easiest way to perform this search without having to write code for each seperate field to search The user can search for Last Name, City, Company, Date of Birth, State or Zip Code They can


Anyone done such before -
hi, has anyone produced a VB program (connected to a database such as MS Access .mdb file) that features a search facility?? a search facility in VB that would search specific fields ir records of text in the database and come back with results (text/string search). if so, ho


Newbie Database Question -
Hi all, OK, I've been playing with VB for about a year, but haven't really done anything with database stuff yet. I want to create a fairly simple program where the user imputs several data fields for each record, and then be able to sort and search that data in a....DATABASE!!! Ya


Simple Query Problem Please Help, its urgent! -
I am trying to be able to search my database, using a form, but i have one major problem, i have to fill in every feild in the querey. Hoe can i have it so when i dont want to search by price, i leave it blank, and it is ignored during the query My current to search with the feil


Database (Search) -
Guys im just new here in VB Forums. And also im only a begineer in VB world. I'd like to ask if u have an idea of the code (maybe its just a simple problem or may be not a problem) on how to search in a database example student name. SInce i used ADO. WHats the code of searching record


Simple Database Trouble -
Hi there all you happy coders I'm having a little problem with a simple MS Access database. I want my app to search through the database and switch to that record if the result is found. This is the Database layout. Camera.mdb <--- Database -Camera <--- Table


Simple Search -
Hello I've seen many posts on this topic but I need a real simple and clean way to search my hardrive for a specific file (me.exe for example) and display the resualts in a listbox. Thanks


[02/03] Help with VB to SQL Server 200 database -
I have a Visual Basic Program that is connecting to a SQL Server Database. I am trying to build search querries to search the database using variables inputed by the user to search the database for specific rows. I have built a procedure in SQL Server and it executes without errors b


Search Query in Database using TextBox -
Hi everyone, thank you for the help you provide on this forum, I've learned a lot so far. Right now I'm making a simple Access-Visual Basic 2005 .NET database. I want to make a Search Query that will search the Database for text similar to what the user inputs into TextBox1.Text on


Search with multi result -
Hi guys i am told to do a site with asp language. After entering entry into database theres a search button that allows user to key in what they wanted to search. When user search for items that only have one in database its no problem. But what my project supervisor wanted is w


search database from vb6 -
Hello out there - i have a little database library program i would like to have a search by one field eg the author or book title and allow the results of this search to be returned to the main form text controls - the same form that is used to update the database. any help with t


Concept: File Searching with VB -
I am a simple person, with a simple family. I need to create a simple search program to be used with MP3s. I cant just let everyone access the music folder, you know how that goes. So what I want to do is create a search program that lists and shows my music. I know, I know, the


Seach database in VB -
Me again with more VB and Database questions. I want to put a search button on my VB form. i.e. Search for "The Kings Head" in a pub database. I would probably need to set up quiry in Access first?? But how do i perform the search?


best database for... -
I've been working a little with vb.net, and I'm to the point of needing data storage and retrival. I'm aware of SQL, and Access and the such. But what is the simpliest way to go about things. I need some direction. I'm talking simple here. like an address book, or music database


LIKE Operator with a Text Box Input -
Sir, I have tried every possible syntax bit no success. I need to input a value in a search text box named searchtext.text using my Access 2000 search button and the search should include the LIKE operator e.g In the Search box I type "Medicine" and all records like Nigerian


Search help... -
Plain and simple here... yeah right! I have an email directory database currently with 10 records. Does anyone have any source code for how to do an ASP.Net page that will return the results of the search? Thanks in advanced... HWKY


Anyone know why (searching and memory question) -
hi all.. I have this issue which has been buging me for quite some time now. I wonder if anyone can shed some light on it. I have an Access database of 40 MB size connected via ADO to my VB app. When performing a search (through VB) on the database the memory usage jumps from


Creating simple search engine -
Good day experts, I want to create an simple dictionary search engine, my form includes 2 textbox and a button named "search". TextBox1 and TextBox2. TextBox1 is for the entry of the keyword entered by the user. And TextBox2 displays the definition of the word. My question is


diplaying DB with VB6 -
I started a project a little over a year ago to make a VB6 program that can display Bible scriptures, songs, announcements, etc... for the new church we are saving to build. I started going at it using a simple : ElseIf txt.Text = "" Then Load frm


develop apps to do "Search" -
Hi, I've been asked to develop my company's library catalogue, which includes search function. The search is not a simple one, but it has to be able to take keywords like AND, NOT, OR, and also search whole words or any of each words (e.g., "My Book Title" vs My Book Title).


Multi Search -
Now as you will have gathered from now, i am in no way a brain box, and studying as computing, with a little knowledge is nothing short of dangerous really and you will understand what i mean in a moment i have a database with a form. and i can search the form by using the CTRL +


Search engine in SQL Server -
Hi, I'm creating a search engine in ASP which accesses a SQL Server database. The way the search engine works, just like any other search engine, is by specifying some key words and then the search is launched. When the users clicks the search button, a SQL request is passed to


Query a search engine -
Is there a way to connect to and query a search engine's database? I am designing a WebFerret-type application and i want to pass search words to the search engine database and input the returned values into a listbox. Please help!


Search Scoring -
With using a database as the backend for a search engine, can someone explain how scoring is achieved? Ex. searching for a term, and the results are listed in order by relevance... 100%, 90%, etc... The method that i am using at the moment is quite simple, no regular expressions e