Search results for query: *

It worked...thanks!!!

How do you find and replace null values in Access tables? Thanks!

I've included all options regarding the plurals, but if i remove the space between the percent sign and double quotes then i will get results for words contained in words. For example, if i search for "opera" then the word "operations" may display. i need to display records for exact words...

The above code works fine if the variable is contained in the middle of a sentence. Because of the space between the percent sign and double quotes, sentences beginning with or ending with the variable are not displayed. variable LIKE '% " & variable & " %' How can i fixed this? Thanks!!!

I think I figured it out. I replaced the second space before the percent sign with an "s". I guess I can do this for all forms of plurals (i.e. es, ies). Please advise, thanks! SELECT * FROM tablename WHERE attribute LIKE '% " & variable & "s%';

The space before and after the variable worked, thanks!!! how do i handle plurals? For example, if someone enters "hat" then the topic that has the word "hats" in it will not be displayed. Thanks again for your help!!!

I'm using the "%" as the wildcard to search for ALL headers, speakers and lecture times. I removed the comma in front of FROM and removed the percent signs surrounding the the variable and I'm receiving the following error message: SELECT s_id, first_name, last_name FROM webupdates WHERE...

Here's what's being displayed: SELECT s_id, first_name, last_name, FROM webupdates WHERE header LIKE '%American Culture%' AND S_ID LIKE '%%%' AND min_time LIKE '%%%' AND topic = '19th-Century German Art Songs' ORDER BY topic, last_name, first_name

The error message is being displayed in the speakers field. Topic, description and min_time values are being displayed correctly.

nothing is being displayed

I'm getting the same error message.

I have created a search box to search for keywords in a paragraph contained in a field within a table. Whenever I use SELECT... WHERE variable LIKE '%" &variable& "%', words containing the keywords appear. For example, if I search for the word "day", paragraphs containing words such as "today"...

I'm getting an error message that states: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect...

I successfully screwed up the entire page! Please let me know what I did wrong. Thanks !! <% Dim Bool header = Request.Form("header") speaker_name = Request.Form("speaker_name") lecture_time = Request.Form("lecture_time") header = replace(header, "'", "") Set rsOuter =...

Could you please provide more detailed code for the areas in which you have the word "loop"? Thanks!

The code you provided worked but the speakers' names are listed in separate rows. Is it possible to have them all listed in the same cell?

That didn't work...any other suggestions? Thanks!

I have developed a web page that retrieves a list of topics and speakers from an Access database and displays them in a table. Some topics have multiple speakers, therefore I do not want the topics to be displayed again - just additional speakers. The code I have developed works fine for one...

I am retrieving info from a database into a table. How can I highlight every other row in the table for the number of records displayed? Thanks!

it doesn't work there either...i'm using Access 2000