Search results

My database is built using Access 97. I have the following table and 2 queries: Table: “Materials Master Sheet” field: “Material” field: “Re-Order Level” field: “Re-Order Quantity” Query (crosstab): “Most Recent Count Numbers” field: “Material Name” (joined to table’s “Material”) field...

I figured it out. From a main counts screen button click, I started by running a query that pulls the materials for the category that I want to count. This query information was then appended into a temporary table that I setup (any leftover information in the temporary table was first deleted...

Thought I had it all setup correctly, but upon minor adjustment of the bound column number, the whole thing works perfectly without having to change the .Value. Thanks.

Believe me, I wish we were ready for the complete inventory system. That I think I could handle! Unfortunately, my boss wants me to put something together for right now. It may be several months until we are able to totally implement a real inventory system (hopefully sooner if I have my...

I have a form that uses an unbound combo box to choose a material to receive. The material is choosen from a master list. Each material on the master list has it's own material ID which is set up as the primary key. The form also has unbound text boxes for the date and quantity of the...

I have seen this link on several occassions, but I'm not sure what information in the link is supposed to help me. I did forget to mention that we do not currently have a way to monitor "disposals" from our inventory stock. The only inputs are counts, orders, and receipts. I realize that this...

I am trying to incorporate inventory counts into my database. Inventory counts are conducted once a week on most of our materials. I want to create a Count Entry Form that will allow the numbers to be entered and then stored in one large table that is then used for reporting on the materials...