embed spreadsheet to a form

[Veli Izzet]

Hi,

I want to embed a spreadsheet (excell or else) to make some calculations
in an access form.

I want to carry the result of this calculation to one field on the form.

I tried linking to an excell spreadsheet, but then the excell opens in
another window and I am thrown out of the form.

I saw the office spreadsheet object, but it is greyed out.

Thanks for answers,

 

[Joseph Meehan]

Hi,

I want to embed a spreadsheet (excell or else) to make some
calculations in an access form.

I want to carry the result of this calculation to one field on the
form.
I tried linking to an excell spreadsheet, but then the excell opens in
another window and I am thrown out of the form.

I saw the office spreadsheet object, but it is greyed out.

Thanks for answers,

I don't think you can do what you want in any automatic way.

Maybe if you can explain what you want all this to do, someone will know
how to best do it.

 

[Veli Izzet]

It is for some calculation purposes.

What I want is somewhat similar to an hyperlink, but I want the
spreadsheet application not to open full screen, but be as part of a
form like a subform.

 

[Joseph Meehan]

It is for some calculation purposes.

What I was trying to find out was what kind of calculations to determine
if it might be possible to provide the functionality you need within Access
without going to Excel.

 

[Veli Izzet]

Joseph,

I tried to solve the problem using access and could not reach a solution
after asking around here; anyhow the problem is:

---- Explanation of main problem:

I have a table of products. (Products)

Now I want to be able to calculate the cost of each product.

The problem is, for each product, the number and types of ingredients
are different.

The recipe may consist of 3 items, or 6-7-8 items.

I tried to put 24 different fields with each item for the products table
(I know this is clumsy) (8 items-name,amount,unit price) and do the
calculation on the forms and reports, but when a field is empty the
calculated fields on the forms did not work.

It seems that I need to have another table, "costs", and it must be
joined by a one-to-one relationship with the products table.

I tried to create this, but everytime I can only create one-to-many
links with the wizards.

The questions:
1-Am I in the right direction?
2-How do I create the one-to-one relationship?
------ End of main problem-----

 

[Joseph Meehan]

Joseph,

I tried to solve the problem using access and could not reach a
solution after asking around here; anyhow the problem is:

---- Explanation of main problem:

I have a table of products. (Products)

Now I want to be able to calculate the cost of each product.

The problem is, for each product, the number and types of ingredients
are different.

The recipe may consist of 3 items, or 6-7-8 items.

I tried to put 24 different fields with each item for the products
table (I know this is clumsy) (8 items-name,amount,unit price) and do
the calculation on the forms and reports, but when a field is empty
the calculated fields on the forms did not work.

It appears you are trying to use Access like a spreadsheet. Access is a
relational database. You have one product and a number of ingredients.
That calls not for a number of fields, but rather two tables. One for
Products and one for ingredients. I am going to guess you may well need an
additional table for formulas, but I still don't really understand what your
needs are.

Rather than explaining how your are trying to solve your problem, we
need to know what the problem is.

You have products, you have formulas and your have ingredients. I would
guess you also have cost of ingredients. You want to be able to compute the
cost.

How often does formulas change? Do ingredients change or their cost
change? Do you need a history of batches and what they cost when mixed or
do you just want to compute the instant cost of a specific batch?