Hi, I am a copy and paste existing code to get what I need person. I can't write code and can barely understand the basics of it. I prefer to use the old fashion macro's in access - the Macro button -(I am using the way back 2003 version). I can create queries, tables, command buttons but that's about it. Like I said, I try and copy exiting VB code when it needs to be replicated.
My problem is that no current code exists for my issue here at work. I need 1 macro to create an excel workbook (this I have done and it works) but I need it to drop those 3 queries to separate tab (with query name) in that 1 workbook.
Query is set and criteria won't change - I can edit it when/if needed.
Query 1 - Agency Checklist
Query 2 - Producer Report
Query 3 - License Report
Each query has separate field names. That seemed to be a question asked often..
Right now I am using 3 separate macros to run each report independently, copying the data from the Producer Report spreadsheet and License Report spreadsheet and pasting the data into the Agency Checklist Workbook. While it works, I know there is a way to have the macro drop each query into 1 excel workbook.
Any assistance you can offer is greatly appreciated. -- side note, I searched the forum and found some questions pertaining to this but I don't think the code was what I was needing...it may be but I may not know enough to realize it as well.
Please go easy on my brain, you could consider me a child when it comes to access vb code.
Kristy