By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,064 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

Spreadsheet Input

P: 3
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
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
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.