Results 1 to 2 of 2

Keyword search with Access 2010 FE

  1. #1
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009

    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 online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    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.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!


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, 05:45 PM
  2. Access 2010 Listbox search
    By Bsamms in forum Database Design
    Replies: 9
    Last Post: 01-15-2012, 10:52 AM
  3. Creating a dynamic search box in Access 2010
    By bob500000 in forum Access
    Replies: 1
    Last Post: 11-24-2011, 01:27 PM
  4. Making a keyword search
    By timmy in forum Forms
    Replies: 9
    Last Post: 03-14-2011, 01: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
Tech Forums: Microsoft Office Forums