Search results

  1. G

    Noob help with executing SQL UPDATE

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

    Noob help with executing SQL UPDATE

    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 =...
  3. G

    Noob help with executing SQL UPDATE

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

    Noob help with executing SQL UPDATE

    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...
Back
Top Bottom