Hello every one<br>i started to use access2000 <br>when i enter a select query statement as query this query runs fine<br>but when i put this query behind a button in the VBA code Access2000 gives the fault couldn't find object<br><br>this is the query<br>SELECT Stoffen.STOFNAAM, Stoffen.SYNONIEM_1, Stoffen.SYNONIEM_2, Stoffen.SYNONIEM_3, Stoffen.FORMULE, Stoffen.CAS_NUM, Stoffen.GEVAAR_SYM, Stoffen.MOL_GEW, Invoer.RUIMTE, Invoer.HOEVEELH, Invoer.EENHEID, Invoer.Plaatscode, Invoer.UGD, Invoer.datum, Invoer.leveranc, Invoer.zuiverh, Invoer.certnr, Invoer.lotnr, Invoer.memo<br>FROM Invoer RIGHT JOIN Stoffen ON Invoer.STOF_REF = Stoffen.STOF_REF<br>WHERE stofnaam like "**" or stofnaam like "*benzeen*"<br>ORDER BY Stoffen.STOFNAAM;<br><br><br>And this is the VBA code so far<br>Private Sub Knop0_Click()<br>Dim strSQL As QueryDef<br><br>Set QueryDef = kaart.CreateQueryDef(kaart, "SELECT Stoffen.STOFNAAM, Stoffen.SYNONIEM_1, Stoffen.SYNONIEM_2, Stoffen.SYNONIEM_3, " & _<br>"Stoffen.FORMULE, Stoffen.CAS_NUM, Stoffen.GEVAAR_SYM, Stoffen.MOL_GEW, Invoer.RUIMTE, " & _<br>"Invoer.HOEVEELH, Invoer.EENHEID, Invoer.Plaatscode, Invoer.UGD, Invoer.datum, " & _<br>"Invoer.leveranc , Invoer.zuiverh, Invoer.certnr, Invoer.lotnr, Invoer.memo " & _<br>"FROM Invoer RIGHT JOIN Stoffen ON Invoer.STOF_REF = Stoffen.STOF_REF " & _<br>"ORDER BY Stoffen.STOFNAAM;"
<br>DoCmd.OpenQuery kaart<br>End Sub<br><br><br>Could anyone tell me what i do wrong in here
<br>DoCmd.OpenQuery kaart<br>End Sub<br><br><br>Could anyone tell me what i do wrong in here 