Search results

Hi All, I am getting the above error when I run the following code. # Dim db As DAO.Database Dim strsql As String Dim rs1 As DAO.Recordset Set db = CurrentDb() strsql = strsql & "SELECT Last(tblPOHeader.PODate) AS LastOfPODate, tblPOLines.StockCode, Sum(tblPOLines.Quantity) AS SumOfQuantity...

Hi all, OK - I know I am probably being thick, but I can't see my error. I have written a very simple sub to try to identify where I am going wrong but no joy. I have attached a screen print showing the relevant table, module, error message and immediate window. I can not figure out what is...

Hi All, There is quite a lot of info around this out there, but I have been unale to solve my issue. I have a parent form with a child subform. On the parent form: I have a textbox which the after update property includes a vba query to update a list box. There is no .requery...

Dear All, I hope you can help. I have been working round this problem for 2 days... I am running the following query directly from the code: Public Sub Test() Dim dbs As DAO.Database Dim MyRs As DAO.Recordset Dim MyRsFilter As DAO.Recordset Dim strsql As String...

Hello, I hope someone can help. I have a sales order system. My main data entry form has the following setup: frmNewSale, sfrmSalesHeader, sfrmSalesLine. The onload event sets sfrmSalesHeader to the next invoice number. In certain circumstances I wish to recall an existing sales...

Hi All, I am a fairly new, self taught, access developer (18 months worth) feeling that I am now, in certain circumstances, hitting my head against a brick wall. There is a lot of conflicting advice out there, and I am hoping to get more specific issues resolved with your input. Here goes...