I work for a food company where we design new food products. I have an Access Database where I keep track of all the ingredents we use in the company, and add new ones daily.
What I want to do is create a spreadsheet view where I can enter an ingredient inventory code into one field and then have it pull in from my ingredients table information about that ingredient, such as the ingredient description. I need the spreadsheet capability, because I want to design this to be a formulary (recipe) builder. I enter the inventory code and it pulls in the product description and whether or not it is a wet or dry ingredient. This is important because of the kind of measure you use (either weight ounces or fluid ounces, for example).
In the next field, I enter in the formula amount and the unit of measure.
The spreadsheet then calculates the batch amount and total weight of each ingredient (whether wet or dry, in pounds).
When I am done with the formula, I want to save the formula to a table and give it a unique formula number. I also want to be able to make a copy or template of it and use this to make a new or modified formula.
I want to do this using an Access Form(s) and not create an HTML type document view. Does anyone have a clue as to how I could create a spreadsheet view in an Access Form?
Thanks
What I want to do is create a spreadsheet view where I can enter an ingredient inventory code into one field and then have it pull in from my ingredients table information about that ingredient, such as the ingredient description. I need the spreadsheet capability, because I want to design this to be a formulary (recipe) builder. I enter the inventory code and it pulls in the product description and whether or not it is a wet or dry ingredient. This is important because of the kind of measure you use (either weight ounces or fluid ounces, for example).
In the next field, I enter in the formula amount and the unit of measure.
The spreadsheet then calculates the batch amount and total weight of each ingredient (whether wet or dry, in pounds).
When I am done with the formula, I want to save the formula to a table and give it a unique formula number. I also want to be able to make a copy or template of it and use this to make a new or modified formula.
I want to do this using an Access Form(s) and not create an HTML type document view. Does anyone have a clue as to how I could create a spreadsheet view in an Access Form?
Thanks
Comment