Search results

I've been tasked with adding features to a database that I recently inherited from another company. The reason I'm taking over is because that company has been "relieved" by our customer. Once I opened this file for the first time, let's just say it didn't take me 2 minutes to start forming the...

Hello all, I have a module that imports/parses text files, and inserts their contents into various tables/fields, using a wide variety of logic. The code does what it's intended to do, without any errors. The problem is that it takes a long time to run the code, and my file size grows out of...

Hello everyone, I have a very weird situation to deal with, and I'm absolutely stumped here. Didn't find anything through searching either. My team has been tasked with testing some code that exports a query to Excel, and then creates a chart and does some more formatting. On my machine, the...

Hello everyone, I am running into an issue with a Crosstab Query that I need to export to Excel. Here's the situation. The crosstab query has an ID# for the row headings, Comment Type for the column headings, and the actual comment as the value. I would like to have this as the output: ID |...

Hello everyone, I'm wondering if someone could give advice on a problem I'm having, to see if I'm going completely in the wrong direction before I start with this. I have a query that runs in Access that I would like to export to Excel. My exporting code works fine, but I would like to change...

Hello everyone! I've got a question that is much harder than I anticipated. I was thinking this would be very easy, but I have been mistaken so far. Hopefully it's something obvious that I'm overthinking! I'm happy to provide many more details as necessary, but I'll try to keep it brief for the...

Got a quick question about error handling in VBA, specifically pertaining to a module that exports results from Access queries, into an Excel file. My current module is working fine for the most part, but during negative testing, I've found a few specific places where the customer would receive...