Search results

  1. 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...
  2. 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...
  3. S

    New to MS Access

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