This one has really got me stumped....please help me..
I need to
Attach a button to a form in access (Called CarDetails, that displys individual data about each car) to transfer specific fields from the database (SUCarSales.mdb) to a spreadsheet (SUCarStickList.xls). The fields and references are as follows.
"RegNo" - Cells A7:A21 in excel
"StockNo" - Cells B7:B21
"Mileage" - Cells C7:C21
"Make" - Cells D7:D21
"Price" - E7:E21
I need to transfer the appropraite details from the database to the spread sheet. Also a button (in the spreadsheet) that transfers these details back to the database.
If it would be easier the files are located here:
(in the speadsheet, the markup is 9%)
I realise that this is a bit specialised, but there has to be someone who has had experience woth this. Thanks agian Rja