embed spreadsheet to a form

V

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,
 
V

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.
 
V

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-----
 
Top