i have a access database called Company, with a table called Customers.
and i also have a excel document called Accounts.
i have created a form which gets its information from Customers, how do i export the current record - ONLY First Name and Last Name into the Accounts spreadsheet, into the next available row?
when i try to export it, it exports everything from the form into excel
The reason for this is somebody else created the spreadsheet and when a name is added to the list they will open an account for them, normally it is typied in, but to save time i thought if access had a button to click and export the current records name and place it at the bottom of the list would be faster.
Thanks
-DreamOn