Search results

  1. O

    Quoting wild card (*) in SELECT statement

    * didn't return blank when I used the msg box to show me the value. % returned the value in the column so just % works in my database.
  2. O

    Quoting wild card (*) in SELECT statement

    Hmm... I used % instead of * and it worked. ------------------------------------------------ records.Open "SELECT record.amount FROM record WHERE vendor_code = '" & vendor & "' AND period_covered LIKE '" & SelectMonth & "%';", Application.CodeProject.Connection, adOpenStatic, adLockOptimistic...
  3. O

    Quoting wild card (*) in SELECT statement

    selectMonth is set as a String. It contains the value from a combo box control. vendor is another String that contains the value from another combo box. The purpose of the select statement is to extract the "amount" value from the records where the records have both "vendor" and...
  4. O

    Quoting wild card (*) in SELECT statement

    Thanks FoFa. I understand that but I am actually looking for the syntax. SelectMonth is a combo control that I am quoting in the SELECT statement. At the same time, I also want to add * at the end of SelectMonth to catch the full word of the month like "January". I couldn't figure out the...
  5. O

    Quoting wild card (*) in SELECT statement

    Could someone give me a heads up on how to quote * in the select statement?? Here is my code. I am not sure where to put the * and how to quote it. I am trying to catch the month. For example catch January by using Jan* ----------------------------------------------------------------------...
  6. O

    table won't load into the Recordset

    Oh...it worked! It must be the spacing because I tried the single quotes at first and it didn't work. Then I just tried again by copying an pasting the codes you editted. Thanks a bunch, Bogzla!! Appreciated!!!
  7. O

    table won't load into the Recordset

    I guess I should ask this quetsion "What's the proper syntax to enclose a variable in SQL statement??"
  8. O

    table won't load into the Recordset

    I am not sure which one I did is numeric. "vendor" is a String that I am trying to pass in. The following statement works when I use it. -------------------------------------------- Me!List212.RowSource = "SELECT record.ID, record.vendor_code, record.invoice_date, record.period_covered...
  9. O

    table won't load into the Recordset

    Hope someone can help me on this. I am trying to load a table into a RecordSet, but it seems I cannot load the data. I can get the column headers but not the values.:confused: I had some code to MsgBox the values of the table but it's all blank so I don't think the table is loaded into the...
Back
Top Bottom