Search results

I did adjust that line to read: For Each oSheet In oBook.targetWorkbook But that still didn't correct my problem

I am stepping through it now. It doesn't seem like oSheet is being set to anything.

Here is what I want to accomplish: Output 2 different record sets to corresponding worksheets in an already created excel workbook. Here is the code that I have so far. It does not throw any errors, and when I look at the excel file it appears to have been modified as the "Date Modified"...

That does sound INCREDIBLY aggravating!! Its good to have curve balls, It forces me to troubleshoot. I think I might have to post another question. I'm in the second leg of this code. Outputting 2 different recordsets to two different tabs in the same workbook.

That was it

1 - When I make this change, I get a run time 13 error on the "Set rs = CurrentDb" line? 3 - How can I find out the error number that this will raise? In other words how can I force it to try to get an object that doesn't exist? This is all very helpful, and I appreciate you keeping in touch.

All valid points. I have eliminated the unnecessary variables. You are correct, these things are small enough to just concat. I have added the cleanup (closing rs, setting db to Nothing, dealing with Excel objects, etc.) to the line below the error resume point: Error_Handler_Exit: 'Close...

"no file extension" Excellent Observation. After I added the extension the data exported correctly! In addition I commented out the error handling and (so far) not errors. THANK YOU! And thank you to everyone who commented. Here is my final code: Private Sub Command47_Click() 'BOF checks...

Sorry, I should have wrote all of that. i do not get an error message, it just hangs. The code breaks if I open the file I am trying to write to. It probably should not take that long, as for testing purposes I have the second recordset filtered down to return 2 rows. I should say that I...

This is the next step in a questions that I was able to resolve on this forum. My goal is to iterate through a recordset, and inside that recordset, reference a second recordset and output the results to an existing excel file. Example: If the department is active (first recordset) output all...

Thank you both for your feedback. @Cronk, I have made the edits you spoke of, mainly declaring all the variables, and adjusting the xlx to excelApp. Here is what my updated code looks like: Private Sub Command46_Click() Dim dbs As DAO.Database Dim excelApp As Object Dim rsQuery As...

I have a piece of code that works the way I expect it too. On a form in my MS Access (2013) database there is a command button that will export an existing query out to a specific tab within an existing spreadsheet. What I am looking for is some validation that this code is efficient or...

The data starts life as an excel file, and then brought into Access. And it is untouched in MS access, so it has the same structure. It is not a crosstab query, And as I am working through this, the months are actual name, not dates. So not 1/1/2019, but "JANUARY" Im thinking I have to...

DSum Through Previous Month Good afternoon all, I have a query that has a spread of number broken down by month. Picture $12,000, broken down by month, so $1k each month. The current structure of the query is a department name, and each of the months. In addition, there is a calculated...

The problem is that the text boxes are unbound, and are not pointing back to a field in a query. They are calculations.

I'm confident on the names, I suppose I'm not confident on the syntax.

Ahhh, you know what?? One of the conditions (obvously) isnt being met. Im saying greater than 5000, but I also have to stipulate less than -5000. So here is what I am ultimately trying to do. On a budget report, I need to identify line items that are more than 5% (positive or negative) and...

I doesn't work as expected, for a value of -35, no formatting appears. However for any positive values it seems to work as expected. I.E. greater than 5 and greater than 5000, the formatting appears. This is a continuation of my previous thread. I didn't state the problem correctly in the...

I might be misunderstanding what your saying. 2 conditions have to be met. Greater than 5 OR less than -5 AND greater than 5000

Thank you, I actually dont need three conditions. Is just 2, greater than 5 OR less than -5 AND over 5000. And if those two conditions are met, just light up, no scale needed. Does that change how you look at the question? Thank you again for your time