This is the code I use to add a new reocrd. Now my database has number of different tables and in order to put two tables on one FORM I needed to create a Secelt Statement in the record source to show all fields in both tables : SELECT COARSE.*, GRAD.* FROM COARSE INNER JOIN GRAD ON...
I have tried that before, but this method exports the whole table into the excel. I only would like to export a selected number of fields from a selected (bookmarked) record into excel.
How do I export Access record (in DAO) into an Excel worksheet?
Does anyone have an sample code for exporting a record into a Excel worksheet? I have no idea how to do this. Can anyone help?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.