Hi,
I am working on a warehouse database for a charity that collects and distributes donations. The charity accepts all sorts of donations (food, clothing, furniture etc.) When a donation comes in, an "addition receipt" is created, containing a list of all the items that a donor brought in, and an "estimated value" for each item, plus other details. Similarly, when donations leave the warehouse, (usually collected by volunteer social workers,) a "removal receipt" is created, with a list of all the items this social worker collected, and again, an estimated value for each item.
The addition form was relatively easy to replicate in Access, but the removal form, which I'm working on now, is a bit more complicated.
With the removal form, the user should not be allowed to enter items freely, only items that are actually in the warehouse (items that were entered in the inventory list, and whose remaining quantity is >0) should be available for removal. Also, the user cannot enter an "estimated value" for an item that's different from the "estimated value" that was assigned when the items came in, that would be an accounting nightmare if it were allowed to happen. For these reason, the removal form should be a selection-based form, for specifying which items (from a list of "Added" items) have been removed.
The "Removal Receipt" consists of a main form and a subfrom. The Main form has the following fields: Receipt Number, Date, Recipient Name. The subform has the following fields: ItemID, Unit (think of it as Item size), Quantity, Estimated Value, and Comments. The main form fields are manually entered by the user, but the subform should basically function as "selection" form. Only the Quantity and the Comments field can be entered manually.
I want the user to be able to select the item from a drop down list, this list only shows available items. Then, when the user has picked the item, a popup from should show up, containing a list of all the entries for this item, the user should be able to select a line (a record) from that list, then the remaining controls would get populated with the corresponding values from the selected record. The user would then be able to enter or edit the quantity and add comments if necessary.
So far, I have figured out how to show only available items, I edited the row source of the "ItemID" control, and used a query to show only available Items (group by items where Remaining quantity >0) I could set up the ItemID's AfterUpdate event to open a pop-up form for selecting one of this item's entries, but I don't know what to do next.
I would appreciate any tips/advice you could give me.
Please keep in mind that I'm still a beginner
Thanks!
I am working on a warehouse database for a charity that collects and distributes donations. The charity accepts all sorts of donations (food, clothing, furniture etc.) When a donation comes in, an "addition receipt" is created, containing a list of all the items that a donor brought in, and an "estimated value" for each item, plus other details. Similarly, when donations leave the warehouse, (usually collected by volunteer social workers,) a "removal receipt" is created, with a list of all the items this social worker collected, and again, an estimated value for each item.
The addition form was relatively easy to replicate in Access, but the removal form, which I'm working on now, is a bit more complicated.
With the removal form, the user should not be allowed to enter items freely, only items that are actually in the warehouse (items that were entered in the inventory list, and whose remaining quantity is >0) should be available for removal. Also, the user cannot enter an "estimated value" for an item that's different from the "estimated value" that was assigned when the items came in, that would be an accounting nightmare if it were allowed to happen. For these reason, the removal form should be a selection-based form, for specifying which items (from a list of "Added" items) have been removed.
The "Removal Receipt" consists of a main form and a subfrom. The Main form has the following fields: Receipt Number, Date, Recipient Name. The subform has the following fields: ItemID, Unit (think of it as Item size), Quantity, Estimated Value, and Comments. The main form fields are manually entered by the user, but the subform should basically function as "selection" form. Only the Quantity and the Comments field can be entered manually.
I want the user to be able to select the item from a drop down list, this list only shows available items. Then, when the user has picked the item, a popup from should show up, containing a list of all the entries for this item, the user should be able to select a line (a record) from that list, then the remaining controls would get populated with the corresponding values from the selected record. The user would then be able to enter or edit the quantity and add comments if necessary.
So far, I have figured out how to show only available items, I edited the row source of the "ItemID" control, and used a query to show only available Items (group by items where Remaining quantity >0) I could set up the ItemID's AfterUpdate event to open a pop-up form for selecting one of this item's entries, but I don't know what to do next.
I would appreciate any tips/advice you could give me.
Please keep in mind that I'm still a beginner
Thanks!
