Recent content by pokeytrev

I am completely fine with using the recommended procedure, I just need to know how to make the calculations.

This is very helpful. Thank you. I will try fiddling around with it a bit to see if I can figure out how it works.

This is great! How would I change the table to append only?

:) Good tips! I don't really know if they need to be connected, like you said. I am going to try a different variety of things to see what works best and then possible seek further help from there. Thanks

I am wondering how I can go about entering a number in a form and having it add that number to a sum in another table. I have an inventory database that keeps track of current inventory items in tblInventoryItems and a table that keep track of transactions called TblTransactionHistory. There is...

I hail from the United States, and have very limited experience with access--self taught. Nice to see such knowledgeable people from all over the world. Glad to meet you.

I tried the method arnelgp posted, and noticed that the query that combined tblTransaction and tblProducts was frozen, meaning I couldn't edit it. I was just wondering if the relationships were wrong based on this: TblTransaction * Transaction ID KEY Product Code Description Transaction Qty...

I am having trouble getting the form to run correctly. Take a look at my relationships and tell me what you think I may need to do? TblTransaction * Transaction ID KEY Product Code Description Transaction Qty TblProducts * Product Code KEY Part Description Vendor ID InvQty...

I will give this a shot. Thank you very much:)

Yes, that is exactly what I want to do. I want to have inventory levels in one table and the transactions in another table. Any tips on how I could go about doing this?

Thanks to another user who helped me with a previous topic, I have created a database wherein exists an inventory table (to list the current inventory level) and a transaction table (to keep track of additions to inventory and depletions as line items). How would I go about linking the inventory...

That makes a lot of sense, actually. I over thought this by way too much. I will go ahead and try that. I will make a test database tomorrow before thinking of applying it to the main database. Cheers:)

Hello, I haven't been using access for long, and I have run into a bit of a snag. Question Detailed: I have three tables and three forms I use to track inventory movement: 1) Table: Inventory items; Form: Modify Inventory Items 2) Table: Parts Received; Form: Receive Part(s) 3) Table:Parts...