Unanswered: Export contents of 2 tables in single Excel spreadsheet
I've created a form that takes info from 2 tables which are joined. I'd like to export both the tables into a single excel sheet with some color coding. I want to accomplish the following:
Export the 2 tables into a single excel sheet and the exported sheet should have a color legend.
Have a look at Pootle's post in the code bank for exporting excel, with that you can do pretty much anything you want with an Excel sheet. If you need help developing the code for your "legend" then I would suggest using Excel to create a macro and then adapting that code to Access.