Search results

Greetings, I am a bit drained today and can't think clearly. How do I stop a new window opening everytime I open a new form. When I get going on the latest project, inputting data I can have up to 6 different windows open. ~rbinder

Greetings all, Continuing to work on my problem and I am now getting and error of '3075' - syntax error (missing operator) in query expression the error line is strSQL = strSQL & "HAVING (tbl_data_DispatchDetails.TradingName) = " & varVal2 & " AND (tbl_Data_DispatchLineitems.WineNumber) =...

Greetings all, I am trying to run the query below to tell me how much stock a company has available by deducting the amount dispatched from its allocation. I am getting an error message; Run Time error '3061' Too few parameters expect 2 The code is; Dim db As DAO.Database, qr1 As...

Greetings all, I seem not to be able to loop through a recordset with the code. When I run the code below it works on the first row but then does not work any further with a error message of 'Object invlaid or no longer set' . I have tried a .update but this does not work. I have used...

Greetings all, I am getting an error message on this code of Runtime error '3061' Too few paramters expected '1' The code is; Dim db As DAO.Database, qr1 As DAO.QueryDef Dim rs1 As DAO.Recordset, rs2 As DAO.Recordset Dim strSQL As String Set db = DBEngine(0)(0) varRet =...