Hello all, First off, I am using Access 2002. I had a class in school about using Access, but that was 7 yrs ago & I was a young college student & only paid enough attention and studied just enough to pass the class. Needless to say I didn't think I'd ever use Access again. Well I was wrong...haha!!
Anyway, I am hopeing that I can get some help with this. I have a supply room that I would like to be able to keep inventory on. So I have created a table that has all my hardware parts listed on it...ID, prod. desc., size, vendor, & Qty. That was the easy part & the only part that I remembered from my class. Here is what I don't know how to do. I would like to have some kind of box on the screen that shows 2 things. First thing I want to be on there is the "Product ID" and then have a blank box beside it where you type in the Product ID #. Second thing I want on there is a second box that says "Quantity" and have a blank box beside it where you type in the Quantity that is taken out of the supply room. Then I would like an "Enter" box that when I click the "Enter" box Access would go through my table, find the product ID that was typed in and then subtract the "Quantity" that was typed in from the quantity on the table.
I'm pretty sure that I have to create this screen from scratch and put those boxes that I'm speaking about on there. But what I don't know how to do is put "value" to those boxes, especially value to the "Enter" button. Is there anyone here that could take some time to help me out. I've gotten a couple books that I thought would help, but they don't go into the depth. If know one knows how to help then maybe someone could recomend some quality programming books or soemthing. Thanks in advance for the help. I truely do appreciate it.
Thanks,
Andy
Anyway, I am hopeing that I can get some help with this. I have a supply room that I would like to be able to keep inventory on. So I have created a table that has all my hardware parts listed on it...ID, prod. desc., size, vendor, & Qty. That was the easy part & the only part that I remembered from my class. Here is what I don't know how to do. I would like to have some kind of box on the screen that shows 2 things. First thing I want to be on there is the "Product ID" and then have a blank box beside it where you type in the Product ID #. Second thing I want on there is a second box that says "Quantity" and have a blank box beside it where you type in the Quantity that is taken out of the supply room. Then I would like an "Enter" box that when I click the "Enter" box Access would go through my table, find the product ID that was typed in and then subtract the "Quantity" that was typed in from the quantity on the table.
I'm pretty sure that I have to create this screen from scratch and put those boxes that I'm speaking about on there. But what I don't know how to do is put "value" to those boxes, especially value to the "Enter" button. Is there anyone here that could take some time to help me out. I've gotten a couple books that I thought would help, but they don't go into the depth. If know one knows how to help then maybe someone could recomend some quality programming books or soemthing. Thanks in advance for the help. I truely do appreciate it.
Thanks,
Andy
