John, I am confused. I have a situation similar to Ralph. If I put the Record source as the query, the rest of the information in the form is gone. I have the form set to the table source. Jim
John Viescas <[EMAIL PROTECTED]> wrote: Ralph- Use that query as the Record Source of your form. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ralph Krumdieck Sent: Monday, January 16, 2006 5:51 PM To: [email protected] Subject: Re: [ms_access] Querying a memo field Thank you. This worked very well. One other question. The results display in datasheet mode. Is there some way to have the results display in the form I created? Thanks. ralph ----- Original Message ----- From: "John Viescas" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, January 16, 2006 5:23 AM Subject: RE: [ms_access] Querying a memo field > Ralph- > > In SQL View, your query will look like: > > SELECT MyTable.* > FROM MyTable > WHERE MyTable.MemoField LIKE "*" & [Enter search word:] & "*" > > To do this on the query grid, on the Criteria line under your memo field, > enter: > > LIKE "*" & [Enter search word:] & "*" > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Ralph Krumdieck > Sent: Sunday, January 15, 2006 11:20 PM > To: [email protected] > Subject: [ms_access] Querying a memo field > > This question may not make any sense. I'm a novice at Access. I have a > simple database and one of the fields in my main table is a memo field. Is > it possible to write a query that would search this memo field for the word > the user inputs at the prompt and returns all the records that contain that > word in the memo field? > ralph > > > > > Yahoo! Groups Links > > > > > > > > > > > > Yahoo! Groups Links > > > > > Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
