Search results

Hi All I have a form FrmAuditClientTransactions that populates from a query displaying transaction line items for a given client. I have used a form so that the user can type into text boxes in the footer which then get written to the client table by clicking a button. I also want the code...

Hi All I have some VBA code that gives this error : 3464 Data Type Mismatch In Criteria Expression UpDateAuditTo = "UPDATE TblClients SET TblClients.Audit_to = #" & Format(Me!MaxPostingDate, "mm/dd/yyyy") & "# WHERE TblClients.CUSTOMERNUMBER = " & Me!txtCUSTOMERNUMBER DoCmd.RunSQL...

Hi All I'm Stage73, Based in Manchester UK. ;) Although self taught, I have a solid understanding of databases after cutting my teeth learning to write queries in foxpro SQL to make up for the shortcomings of built in reports in our organisations system. However, as I'm now building Access DBs...