Recent content by spdolan

well it seems we arent out of the woods yet. it is now writing to the tblAT, and adding the quantity together, but on the wrong condition. I entered condition 2, 22 copies, and condition 2, 25 copies, but in the tblAT it shows 47 copies in the condition 11 record. I appreciate your advice...

Thanks so much. This worked for the major problem. However, when I dropped this code in, my refresh stopped working. I tried to put in that RefreshMe code, but I think I messed it up somehow. I will keep playing with it. Sean

I'd love to but its over 300MB due to 2 million records. I'll cut down the amount of records so that there will be a small sampling, should knock the size down. EDIT: I knocked out all but about 13k records, so please check tblAT for testing ISBN's etc. Thanks. Sean

Private Sub Add_New_Record_Click() On Error GoTo Err_Add_New_Record_Click CurrentDb.Execute "UPDATE tblAT SET Total = tblAT.Total + " & Me.Quantity & " WHERE tblAT.SKU = ' " & Me.sfTblAT.SKU ' DoCmd.GoToRecord , , acNewRec Exit_Add_New_Record_Click: Exit Sub...

I tried, but there is no error happening now, just no updating of the destination field. I know my data exists, because a subform pulls Author Title Rating and SKU from the tblAT. Since the SKU is the primary on tblAT, I am going to try to update based upon that field instead of multiple...

I understand that I am not supposed to store calc'd values, but I am at a loss to know how to do this any other way. Books from all over the country come to my warehouse, and arranged alphabetically on my shelves. I dont know what books I am getting until they arrive, so I have a pool of 2...

well that removed the error, but it is not dumping the calculated total into the tblAT. Any thought on that one? Sean

Hi Aman - They are text fields - where do i put the single quotes? around the TblAT.* or the Me.*?

Oh - Both fields are text, should have mentioned that. I have checked, and both fields are text, 2. Thanks

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

Yes, I know I'm not supposed to store quantity on hand, but in my case, I am dealing with an alphabetized warehouse of books, stacked on shelves, and we dont know what books we are going to have. I have a table which is essentially a pool of potential inventory, and a table which is actual. I...

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

SprintDB issue Sorry to piggyback the thread, but I am having trouble setting up a SprintDB database. I am fair-to-middlin at Access, and the DB I am building should be very simple. We have a college textbook store, and I am building this DB to send students on remote buybacks. What I want...