Microsoft Access - Keyword search
Asked By Howard Lepolstat
20-Nov-09 07:17 PM
I am trying to give users a simple keyword search. The table to be searched has five fields, both text and memo data type. There are few enough records (less than 5000) so that the lack of indexing capability (for the memo field) is not really a problem. I want to give the user the ability to enter a keyword and have it search all five fields. The search return to the user will be a two field table. The first field in the return table will be the complete data from one of the five original fields. The second field in the return table will be the name of the field in the original table in which the keyword was found.
The typical user is expected to have very little computer familiarity other than "point & click" and entering a word or two in a text field.
Since I have never created this complex a query before, I would appreciate some feedback as to the general process that might be used. Any suggestions are appreciated. Thanks.
re
u just take input of keywork and pass create a select statement with like key on all five field then u will be get desired row
SqlDataAdapter1.SelectCommand.CommandText = "SELECT ID, Question, Answer FROM table Where field1 LIKE '%" & txtkeyword.Text & "%'" & " OR field2 LIKE '%" & txtkeyword.Text & "%'" & " OR field3 LIKE '%" & txtkeyword.Text & "%'" " or field LIKE '%" & txtkeyword.Text & "%'" & " OR field4 LIKE '%" & txtkeyword.Text & "%'"
that to the second statement it becomes null Can somebody help me on this? using (Microsoft.Win32.RegistryKey sqlServerKey = Microsoft.Win32.RegistryKey.OpenRemoteBaseKey(Microsoft.Win32.RegistryHive.LocalMachine, <My Machine name> ).OpenSubKey(@"SOFTWARE \ Microsoft \ Microsoft SQL Server \ <Instance Name of the sql server> \ MSSQLServer \ CurrentVersion")) using (Microsoft.Win32.RegistryKey sqlServerKey Microsoft.Win32.RegistryKey.OpenRemoteBaseKey(Microsoft.Win32.RegistryHive.LocalMachine, <My Machine name> ).OpenSubKey(@"SOFTWARE \ Microsoft \ Microsoft SQL Server \ <Instance Name of
2011 19:10:25.0731] [0] * ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** * [11 / 17 / 2011 19:10:25.0731] [0] Starting Microsoft Exchange Server 2010 Setup [11 / 17 / 2011 19:10:25.0731] [0] * ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** * [11 / 17 / 2011 Central Time (US & Canada). [11 / 17 / 2011 19:10:25.0731] [0] Operating System version: Microsoft Windows NT 6.1.7601 Service Pack 1. [11 / 17 / 2011 19:10:25.0731 17 / 2011 19:10:27.0135] [0] Exchange configuration container for the organization is 'CN = Microsoft Exchange, CN = Services, CN = Configuration, DC = mr238, DC = org'. [11 / 17 / 2011 19:10:27.0135] [0] Exchange organization container for the organization is 'CN = First Organization, CN = Microsoft Exchange, CN = Services, CN = Configuration, DC = mr238, DC = org'. [11 / 17 / 2011 19:10:27 EXCHANGE, CN = Servers, CN = Exchange Administrative Group (FYDIBOHF23SPDLT), CN = Administrative Groups, CN = First Organization, CN = Microsoft Exchange, CN = Services, CN = Configuration, DC = mr238, DC = org'. [11 / 17 / 2011 19:10:27 EXCHANGE, CN = Servers, CN = Exchange Administrative Group (FYDIBOHF23SPDLT), CN = Administrative Groups, CN = First Organization, CN = Microsoft Exchange, CN = Services, CN = Configuration, DC = mr238, DC = org'. [11 / 17 / 2011 19:10:27 15. [11 / 17 / 2011 19:11:17.0415] [0] Exchange Installation Directory : 'F: \ Program Files \ Microsoft \ Exchange Server \ V14'. [11 / 17 / 2011 19:11:17.0446] [0] Applying default role selection 17 / 2011 19:11:17.0477] [0] Setup will run from path 'F: \ Program Files \ Microsoft \ Exchange Server \ V14 \ '. [11 / 17 / 2011 19:11:17.0493] [0] InstallModeDataHandler has 0 DataHandlers
2011 19:10:25.0731] [0] * ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** * [11 / 17 / 2011 19:10:25.0731] [0] Starting Microsoft Exchange Server 2010 Setup [11 / 17 / 2011 19:10:25.0731] [0] * ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** * [11 / 17 / 2011 Central Time (US & Canada). [11 / 17 / 2011 19:10:25.0731] [0] Operating System version: Microsoft Windows NT 6.1.7601 Service Pack 1. [11 / 17 / 2011 19:10:25.0731 17 / 2011 19:10:27.0135] [0] Exchange configuration container for the organization is 'CN = Microsoft Exchange, CN = Services, CN = Configuration, DC = mr238, DC = org'. [11 / 17 / 2011 19:10:27.0135] [0] Exchange organization container for the organization is 'CN = First Organization, CN = Microsoft Exchange, CN = Services, CN = Configuration, DC = mr238, DC = org'. [11 / 17 / 2011 19:10:27 EXCHANGE, CN = Servers, CN = Exchange Administrative Group (FYDIBOHF23SPDLT), CN = Administrative Groups, CN = First Organization, CN = Microsoft Exchange, CN = Services, CN = Configuration, DC = mr238, DC = org'. [11 / 17 / 2011 19:10:27 EXCHANGE, CN = Servers, CN = Exchange Administrative Group (FYDIBOHF23SPDLT), CN = Administrative Groups, CN = First Organization, CN = Microsoft Exchange, CN = Services, CN = Configuration, DC = mr238, DC = org'. [11 / 17 / 2011 19:10:27 15. [11 / 17 / 2011 19:11:17.0415] [0] Exchange Installation Directory : 'F: \ Program Files \ Microsoft \ Exchange Server \ V14'. [11 / 17 / 2011 19:11:17.0446] [0] Applying default role selection 17 / 2011 19:11:17.0477] [0] Setup will run from path 'F: \ Program Files \ Microsoft \ Exchange Server \ V14 \ '. [11 / 17 / 2011 19:11:17.0493] [0] InstallModeDataHandler has 0 DataHandlers
When was the first version of Microsoft SQL Server released? This explains the first version of SQL Server release from Microsoft. Microsoft released its first version of SQL Server in the year of 1988 . This version was developed jointly by Microsoft and Sybase for the OS / 2 platform. Related FAQs What is Denali? This explains about Stored Procedures and functions in SQL Server 2008 R2. When was the first version of Microsoft SQL Server released? ( 130 Views ) View Santhosh N's FAQs Create New Account keywords: Microsoft, SQL Server, first, version, 1988, Sybase, release description: This explains the first version of SQL Server release from Microsoft.
Next Microsoft’s Windows OS Release in 2012? This briefs you about the next probable Windows OS (Windows 8) release from Microsoft. Microsoft might release its next Windows OS with the name Windows 8 could be released sometime the main functionalities that are handled by WWW service in IIS 6 and prior versions. Microsoft .Net Framework introduced for developers This explains when .Net Framework introduced to the developers and operating systems This explains and lists four major operating systems used in the mobiles Next Microsoft’s Windows OS Release in 2012? ( 242 Views ) View Santhosh N's FAQs Create New Account keywords: Microsoft, Windows 8, OS, release, 2012, APP STORE, performance, sleep, mode description: This briefs you about the next probable Windows OS (Windows 8) release from Microsoft.