Recent content by jesswoo

I need to know whats on hand whenever I decide to check it. In the morning, in the afternoon whenever. Thing is we are a pretty small company and we get jobs in at various times. There are orders that get put in and the parts for orders do have specific materials that go with it but sometimes in...

I know storing a calculated value is not advised but I need to know what we have in stock at any given time. I am sure I typed more than just those statements backwards I haven't had any real training in Access just a lot of google and youtube help to figure things out. For the last part of...

Hi all, I have a table called tblPackingMaterials and a table called tblMaterialQuantities TblPackingMaterial has a number field called StartingQTY tblMaterialQuantities has: IDMaterial (a one to one relationship with MaterialID in tblPackingMaterial) AdjustmentQTY QTYinShop From these 2...

I do not understand Allen Brownes description of how to do this and I cannot find a model on that one site that a lot of people send others to. All I want is for packing materials to be added and subtracted and to add or delete paint and see its usage by order. There is no financial...

Hello, I have a database that I use to put in orders for our shop and keep track of our part informations as well as paint and packing materials. Everything works good on this but I am trying to create a table for adjusting quantities on hand for packing material based on the part quantities...

I think the department should go into the Orders table because a part can be run on either the line or batch depending on how busy we are and the only thing it would be specific to is the order. If an order has multiple parts all of those parts are run in the same department.

Ok so I created a Part entry form based off of the parts table and put tblpartpacking as a subform on that so when I put a new part in I can just put the packing materials too. Does this sound right? I also created a form for each table. I am thinking, for order creations Can I make...

I do have 2 questions, How do I create a new order? I know i will create a form but from which table? Also, I wanted to be able to filter the orders by status and department. Before I just created lookup fields in the orders table and filtered the orders with a query that specified which orders...

Thank you so much! this is awesome and exactly what I needed. Thanks for taking the time to help me with this! I understand where I was going wrong with what I had and it was so frustrating, I have been working on this a month...

A. In the foam table that designates a huge roll, correct? And when you use it for a part you tear off part of that roll, the size of which depends on the part it is used for, correct? Yes, each part has a specific length for foam strips B. When one part is packaged can it use more than one...

Ok I took out table plugs. After talking to my boss he doesn't think it is necessary to keep an inventory of them. I put in some info for foam, bags, and paint. Thank you so much for all of this help I am seeing now that i was looking at this the wrong way!

I forgot here are the changes I made, I left Bag size in tblparts because I was not sure.

1. tblBags, tblPlug, tblFoam: Whats the difference, in purpose, between ID and ProductCode in all those tables? Where/how does product code get assigned? Can a Part have more than one Bag, more than one Foam or more than one Plug? The ID I just put in there because I thought I needed it, it has...

Ok here is what I got. I thought about adding quantity fields in the paint, bag, foam, and plug tables but honestly I do not know how that should be done... Also, should I have created an orders table?

For the most part. A part is going to either be bagged or stacked with foam, EVERY part will have one or the other. There are different sized bags and each part has a specific bag size but each bag size can be used on different parts. There are not a whole lot of parts that require masking...