Search results

CurrentDb.Execute "UPDATE tblAT SET Total = Total + " & Me.Quantity & " WHERE tblAT.ISBN = " & Me.ISBN And tblAT.Condition = " & Me.Condition" I am trying to update two tables at once in the OnClick Event Proc. One with this line of code, one with GotoNewRecord. This code returns "Object...

Hey folks - I have a db Im working on in which I need to use one button to update two tables. I have one table that shows data recently entered, and another table which will search for and update quantities if SKU exists, or append the record to the table if it does not, when Update record is...

Hello folks I am having trouble with an Inventory DB I am building. I know the general theory of calculating inv on hand as opposed to storing it, but this is the issue: I deal with a book buying company, and as such, there is a pool of over 500,000 records that contains book information...