Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    15

    Unanswered: cbos used to find info in table

    What sort of code would allow me to to parse a table for information based on two textboxes? The first textbox references the first column in the table (always), and the second textbox references one of eight columns.

    Any help would be appreciated.

  2. #2
    Join Date
    Oct 2003
    Posts
    15
    Would I need to use a BuildCriteria or GetCriteria at all?

    Just so I know…do I understand this correctly?


    Dim strSQL as string

    ‘strVariable represents a combo drop-down with variables (<, >, =, etc.)
    ‘strValue represents a textbox that allows alphanum search parameters
    strVariable = Me.cboVariable1.value
    strValue = Me.txtValue1.text
    strParameters = strVariable & “ “ & strValue

    strSQL = “SELECT “& txtSQL & “, “& txtSQL2 & “ Where strParameters

    From tblQryTrans_Report


    Thanks, in advance, for any assistance.

  3. #3
    Join Date
    Oct 2003
    Posts
    15
    This code identifies the WHERE. Could someone look this over?

    ------------------------------------------------

    Dim strSQL as string

    ‘strVariable represents a combo drop-down with variables (<, >, =, etc.)
    ‘strValue represents a textbox that allows alphanum search parameters
    strVariable = Me.cboVariable1.value
    strValue = Me.txtValue1.text
    strParameters = strVariable & “ “ & strValue

    strSQL = “SELECT “& txtSQL & “, “& txtSQL2 & “ Where txtSQL2 strParameters

    From tblQryTrans_Report

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •