Export Fields from Form/Sub Form to Excel cells

[Johnrg]

Hi Guys,

Can anyone advise if this is possible?

We have a standard order form/subform with customer and delivery details in the main form and specific order details in the subform.

I want the developer to include a command button that opens an EXCEL spreadsheet template and auto enters data from feilds in the form/subform into specific cells in Excel. For example the order number text field in the database main from would go to cell A12 in excel, the order item number field from the subform would go to cell D46 in excel.

The operator would save the excel file to there desktop if they want, or print and then on the close from excel they would automatically go back to the access form.

I thought this was totally possible in Access2010 and not to complicated at all to setup but have been told its very complicated and would need "tons of code".

Is this possible, It was an important part of my form design idea.

If its not that complicated is there anything I can pass onto the developer to point him in the right direction?

Note: Please don't say "why not just design a report in Access", we need it sent to excel to work in with an invoicing package we run.

Thanks

JohnG

 

[liddlem]

Heres an idea.
Make an ODBC connection from Excel to the access database.
Write formulae to select the correct record data. (ie user may need to type the invoice number and the formulae update the rest of the info?
If you need to keep a static record, record a macro that copies the result to a new worksheet and pastes values. (You will need a few additional lines of code here to create/rename the new worksheet.)

 

[DCrake]

This is very much achievable in Access and does not require tons of code, as you suggest. There are many examples on this forum. Do a search for solutions.