Recent content by stage73

Thanks so much CJ and Lpurvis. Greatly appreciated. You're goodn's ! Kind regards Chris

Thanks CJ, your input is much appreciated. Apologies, I'm very new to this and teaching myself... So I'm getting the code to copy the records from the current form to an Excel spreadhseet ? - How do I tell Access what I'm copying ? Is this the bit where you detail: copyfromrecordset P2Rst You...

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...

Thanks Rx. Much appreciated.

Thanks so much James for the prompt reply - worked a treat ! I'll remember that. Thanks again, top man - much appreciated. :)

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...