468,121 Members | 1,445 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,121 developers. It's quick & easy.

Spreadsheet Input

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?

Nov 22 '06 #1
1 1464
32,030 Expert Mod 16PB
When you say a 'spreadsheet view' do you mean in tabular format with a grid of rows (records) and columns (fields)?
If so, you can have a form designed that way. It would need to have the 'Default View' property set to 'Continuous Forms'.
Also, you'd have to add all the fields you wanted from those in the Recordset source.
The wizard should help you do this.
Nov 22 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Fabio | last post: by
6 posts views Thread by Mark | last post: by
1 post views Thread by CDARS | last post: by
1 post views Thread by jquest | last post: by
2 posts views Thread by LeoKPorto | last post: by
3 posts views Thread by colo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.