2 Button Questions

[SeaweedOPM]

I have a button on my form that I want to first insert the current date into the table "callData" and the column is "SaleDate". After this I want to export just the current record into an excel file.

(This would be a plus) if the excell file could be one single file and, if multiple sales were made for the same day the export would export the record to the x1down(or whatever) row.
Please help I've been searching everywhere and nothing that has relivence to this works for me.

 

[CautionMP]

If the table is linked to the form then you can set the value of SaleDate=Date() when the button is clicked.

Creating the Excel file is pretty easy. Create a query that has the data you want in the Excel file. Then use the TransferSpreadsheet method to create the Excel file.

The easiest way to implement TransferSpreadsheet is to creat a Macro and fill in all the appropriate arguments.

Hope this nudges you in the right direction.