Search results

I will post the code at the end. I found some coding to save data from a query to a particular worksheet in a particular excel file. It was working fine, but I was trying to find a way to make it close the excel file and application after. Every time I tried to edit it, I ended up with the...

I've done some programming in other languages, but am a complete newbie when it comes to VBA. I needed to send a query to a specific sheet within excel (so it wouldn't save over the entire workbook each time) and found a module online to do so. As I cannot link the site, I will include the...

I have data linked from access into my excel workbook. There are other files that pull from this excel workbook, but not directly from access. I would like to ensure that whenever I update information in access, it automatically updates the information in excel without needing to open the...

I have information for various counties in a table. I want the report to show 11 specific counties. Originally, I wrote this into the criteria section of the query (countyname = "county1" OR "county2" OR ... OR "county11"). However, I also want to have a sum of the data in the report header...

I have a table with the following information: OrderID RequestRecieved PackageSent Department The data in the fields is as follows: OrderID: A numeric id number RequestReceived: Date PackageSent: Date Department: One or two character initial (There are 7 departments in total) I am...