Recent content by Glo0

Right i think i have found out why this isnt working for me.... I have tried the final suggestion, thanks MSAccessRookie and it works if i try it on a new fresh database that has only 1 table and 1 form. But if i use it on my current project that has 10 tables nothing happens. I dont even get...

Hey tried that and still i get nothing removed the 2 where clause and tried Private Sub Command61_Click() Dim strsql As String strsql = "Update PaperAccounts" & _ "Set InvoiceNumber = Forms!PaperAccountsInvoiceDetails!txtBox1" & _ "WHERE AccountNumber =...

Thanks thats answered one part. But if i put Private Sub Command61_Click() Update PaperAccounts Set InvoiceNumber = Forms!PaperAccountsInvoiceDetails!txtBox1 WHERE AccountNumber = Forms!PaperAccountsInvoiceDetails!txtBox2 AND InvoiceStatus = 0 End Sub I get no change in my table. I dont...

Hi Im new to access, made the plunge straight from php to oh what does that button do in access. ive figured out most of what i want to do but im stuck with how to run a sql update query from a buton click I have no back ground and VBA but intend to start learning after i have this little...