Automating Excel Spreadsheet

[pdxSteve]

With Access 2007 the calculated cells are not showing formulas...

My Access program creates an order guide spreadsheet that is sent to the
customer... he fills in quanity (column 3) which needs to be extended by the
price (column 4) and put the result in the Extended (column 5). i also give
an order total at the bottom of the range.. (essentially column5 =
column4*column3)...

Can someone point me to a tutorial or tell me how to..

Thanks in advance,
Frozen like a popsicle in Portland..
sk

 

[John W. Vinson]

With Access 2007 the calculated cells are not showing formulas...

My Access program creates an order guide spreadsheet that is sent to the
customer... he fills in quanity (column 3) which needs to be extended by the
price (column 4) and put the result in the Extended (column 5). i also give
an order total at the bottom of the range.. (essentially column5 =
column4*column3)...

Can someone point me to a tutorial or tell me how to..

Thanks in advance,
Frozen like a popsicle in Portland..
sk

Excel is a spreadsheet program; Access is a relational database program.
You're treating Access as if it were Excel, and it simply isn't! Access
databases don't *have* spreadsheets, and Access tables don't store
calculations.

Instead, store the base data (quanitity and price) in your Table, and
dynamically calculate the extended price in a Query; display the total with a
calculated control on a Form (for onscreen use) or Report (for printing).
Neither the extended price nor the total should be stored in any table.

If what you're sending to the customer is in fact a .xls Excel spreadsheet
file, take a look at the VBA help for TransferSpreadsheet; you can export the
data in a Query into a spreadsheet.