Copy an excel spreadsheet with working formulas into a Form

[johnjmcnaughton]

Hi!



Not sure if this can be done.... But I want a form that works like a spreadsheet. The Spreadsheet has a Quantity, price, and total column. With Formulas calculating the total cost of each item. Can I get this to work in a form? I tried Paste Special, which I have sucessfully used in Word, But it is not functional in Access. Any Suggestions would be appreciated!!

[alansidman]

Import your excel spreadsheet into a table using the Import Wizard. Build your form using the fields you want from the table. Set the default view of the form as datasheet. You will need to understand that forms and tables in Access do not operate like spreadsheets. Here is a good read on the difference between Access and Excel.

http://forums.aspfree.com/microsoft-...el-349267.html
and then this
http://forums.aspfree.com/microsoft-...es-208217.html

[johnjmcnaughton]

Thanks for the info. I ended up creating a subform and put the expressions there. I had problems using the expressions builder, but eventually I was able to type out what I needed for expressions.