Results 1 to 2 of 2
  1. #1
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147

    Keyword search with Access 2010 FE

    I am trying to create a stored procedure that will allow me to search column named "AuditResults" within Access. As the StartDate and EndDate popsup to enter my date range, I would like the keyword search to popup as well so I can enter the keyword I am looking for in the "AuditResults" column. This is what I have but can't get it to work.



    ALTER PROCEDURE dbo.[Proc_QryCon&RegKeywordSearch]
    (@StartDate datetime,
    @EndDate datetime)
    AS SELECT PI, RDStudyNo, Waiverofconsent, WaiverofDocumentation, Consents, TotalSubjects, Ref#, ID, Findings, AuditResults
    FROM dbo.[TblConsents&RegulatoryAudits]
    WHERE (AuditResults LIKE '%') AND (Monthtoreport >= @StartDate) AND (Monthtoreport < @EndDate)


    I am using SQL 2008 R2 and Access 2010.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    I don't anything about SQL stored procedures, but in Access query could use:

    WHERE (AuditResults LIKE [enter word to search] & "*")

    I never use query input parameter prompts because can't validate entry.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. A TRUE Keyword Search
    By Meep in forum Queries
    Replies: 72
    Last Post: 05-13-2013, 06:45 PM
  2. Access 2010 Listbox search
    By Bsamms in forum Database Design
    Replies: 9
    Last Post: 01-15-2012, 11:52 AM
  3. Creating a dynamic search box in Access 2010
    By bob500000 in forum Access
    Replies: 1
    Last Post: 11-24-2011, 02:27 PM
  4. Making a keyword search
    By timmy in forum Forms
    Replies: 9
    Last Post: 03-14-2011, 02:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums