Recent content by trackstar2786

I was thinking about doing the union prior to the running of 'summaryforrcs' so that the footnote would already be apart of that query. Then when each account is broken out, it reads that specific account and also pulls the footnote line.

What I'm trying to accomplish is to add constant footnote at the bottom of each output before it is exported in excel. My current SQL statement without the footnote is below. strSQL = "Select Account, Reseller, [AT&T],Comcast, DataXoom, [Spectrum-TWC], [T-Mobile],[Verizon Wireless], [Verizon...

I'm wondering if I can do some editing to an excel file either during one of my docmd modules or if this is something I have to do afterwards. Module 1: Docmd.outputto Runs query and outputs to excel (xlsx) with a specific file naming convention "AccountNumber_AccountName_Month_Year". In...

Pat, that was genius and worked great. Thank you.

Hello, I'm linking external excel files to an internal db but the external file has dynamic headers. Example. I always need to use Column R which is currently titled "September Activations" Next month Column R will read "October Activations". Is there a way that when i update the linked...

Thank you all for you help. I ended up going with two modules. One that runs the access query and exports to a new excel file and another module that runs a query and transfers it to a new tab in the first spreadsheet with the same corresponding file name. Just have some minor changes I...

Sorry, i typed that too fast... Set rs = .OpenRecordset("SELECT DISTINCT Account FROM DetailBreakout") is the direct copy/paste This is the only thing i changed prior to it running line by line just fine. Which I guess i could do, but it's a waste since it took about a hour to run 6...

I made the change to the rs = .OpenRecordset("SELECT DISTINCT Account FROM Detail Breakoutout") but now I get a run time error '3265' 'Item not found in this collection.

If I adjust the corrected VBA that I'm using for the Commission_Summary and point the VBA to run a breakout by account number my Detail query, it appears when running/exporting 1 account at a time (which I want) , it's going line by line vs moving to the next account group. Example. if Account...

The account number is a text but that is something that i can convert to a numeric field. After I made that change it worked. Thank you!! Now I have a detail transaction tab that I'll need to do the same breakout for, but there will be multiple transaction lines by account number. I'll need...

Brand new, so please excuse my inexperience. I'm trying to do two things. 1) Using the Code below, I'm attempting to create a new excel sheet that isolate each account number and exports that account's summary to an excel sheet. I'm currently stuck either in my SQL or vba statement how to have...