Recent content by NNLogistics

Thanks, Hope this is better Private Sub cmboToWarehouse_Exit(Cancel As Integer) 'For Reference 'Transfer Quantity=me.txtTransferredQuantity fromfrmInventoryTransactions 'From Key = me.txtFromKey = me.cmboWarehouseID + me.cmboPartNumber established in me.cmboPartNumber exit 'To Key =...

Thanks vbainet, for taking the time. I hope this is relatively clear, I know I find it very difficult to follow someone else's code. It's long . Basically if there is a record in the "To Warehouse" I update it. If there is no record I write it. Then I always write to a transaction table(This is...

Thanks,John Sorry I didn't respond on Monday. I have spent the last 2 days basically on this statement - Me!subfrmDailyTransaction.Form.Requery - and every variation of it. on every event that applies. I was familar with the document you suggested. Perhaps I am still missing the exact syntac...

I know this topic has been covered lately and often, so I apologize in advance for the repeat, but I have been working on this for quit some time. I have a Form (frmInventoryTransactions) and a subform(subfrmDailyTransaction.Form). The subform is based on a query. The form is unbound. “On Exit”...

Thanks Uncle gizmo SELECT tblInventory.fldWarehouse, tblInventory.fldPartNumber, tblInventory.fldDescription, tblInventory.fldQuantity, tblInventory.fldKey FROM Products INNER JOIN (qryAllActiveWarehouses INNER JOIN tblInventory ON qryAllActiveWarehouses.WarehouseID =...

I hope this makes sense(It doesn't to me). If the Record exits, I update the record, If it doesn't exit then I write it (This code is not displayed). If the record has a positive Quantity I can find it, if its a zero, it gets to EOF. I have to be missing something. I dont see why Quantity has...

Thanks Bob Yes, as soon as I saw the adLockBatchOptimistic, I thought what the heck is that. I dont know how to use batch. I must have used the first line on the drop doww, saw optimistic and picked it. Thank you so much. Dont go far, I have a lot more code to write or screw up. Thanks...

Thanks Bob. At this point i've invested more than I want to giveup (just yet). I love writing this code but its also very frustrating. Thanks again. Joe

Thanks Bob I just manually updated the qry(ok) and then checked the table and it was also updated.

Thanks Steve I think I'm doing exactly what they suggest. Editing a Recordset (ADO Server) ' ADO is naturally in edit mode, so do not use "rs.Edit" rs("LastName") = "Smith-Jones" rs.Update But I have to be overlooking something

Thanks Joanne, but no difference.:confused: I added a msgbox right before the update and now move next and before the update fldQuantity = 3 and after update it = 1, just like the table tells me. I think I'm just more confused. Thanks so much , please let me know if you tink of any other...

This is the First time I have written code for a form with all unbound objects. Bascially I have a inventory table that uses a combination of warehouse and PartNumber as the key, It also seperately has those fields(I know its not efficient). So What I want to do is If I find the key it wont...

Oh Iv'e been away from this to long. Thankyou,Thankyou

I used to think of my self as an advanced beginner but having not used any of these skills for several years, I’m not sure anymore. I have the need to convert the format of a table.I was not sure where to post question, I guess the solution will tell me that. From : (Different record for same...