Search results

  1. S

    Solved Need help with number as text

    No I usually work with unbound forms. Someone also suggested this change, dubbel = "Bestelbon = "' & Me.txtBestelbonNew & '" How is your suggestion different?
  2. S

    Solved Need help with number as text

    I have following code that gives me error 3464 "type mismatch criteria". I am certain it has the do with this line, dubbel = "Bestelbon = " & Me.txtBestelbonNew.Value The value in the textbox is saved as short text in the table. I've tried to put in in single quotes, double quotes. But...
  3. S

    Problem with sql syntax with JOIN and WHERE in vba

    Damn, you were right about the single quotes. It is a number stored as short text. But first time I typed the single quotes in the wrong order. It works now! Thx a lot
  4. S

    Problem with sql syntax with JOIN and WHERE in vba

    I actually got this code from a query that does work. But when I try to adapt it to vba I now get error "3464 data mismatch in criteria" Here is my full code, Private Sub cmdSearch_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim sql As String If...
  5. S

    Problem with sql syntax with JOIN and WHERE in vba

    No I've tried that already and it didn't work
  6. S

    Problem with sql syntax with JOIN and WHERE in vba

    I'm trying to do a lookup in vba with sql where I search for the value of a textbox in two linked tables. sql = "SELECT Bestelbon, Productnaam FROM Planning INNER JOIN Tanks " & _ "ON Planning.Productcode = Tanks.Productcode WHERE Planning.Bestelbon = " & Me.txtSearch & "" But I can't seem to...
  7. S

    New to MS Access

    Hi everybody! New to access and databases. Hope to learn lots of new skills here.
Back
Top Bottom