Search results

I'm embarrassed I didn't think of that idea myself. Simpler is always better. :D That's within a hair's breadth of working. It doesn't look like ¬CR¬ is the line break character in the VBA editor's Find and Replace dialog unfortunately. Any idea what else it might be? I've tried searching...

Thanks for the quick reply at this hour! I'm aware that I don't *have* to add them to make the code run, but unfortunately they've documented several scenarios where their code gives various run-time errors (and god knows how many other failures still lie ahead that nobody has gotten to). So I...

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...

Hey Mark, sorry for the late reply on this. It did take a while, but I wanted to come back and say THANK YOU!!! I finally found another machine that re-created this error, and you were exactly right about the issue. Your idea did fix the error, and it also appeared to improve the performance as...

Thanks for your quick reply, jdraw. Here's a high-level description of the data process (feel free to skip this, if you want): 1. FileLoop sub goes through a specified directory and finds files with either a .txt or .dat file extension, and calls the ParseFile sub for each file 2. ParseFile...

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...

Thanks for your detailed replies (especially at this hour!) I was actually in the middle of replying to your first comment, but this one answers most of the questions I had. The only question I have left is - is there a way to let the user select the file name, rather than making it...

That's a great point, Cronk. We knew we were going to eventually run into this. I was hoping this code would already take care of that, but it looks like it might not. Is there anything about the code in my original post that you think I would need to change? I had thought that the original...

Thanks for replying, Mark. I won't be able to test this out on the other machine until tomorrow afternoon, but I'll let you know if this does it. I'm skeptical though, because I've been using that code block before without any issues. In another database, there's an export button that starts...

Thanks for your reply. However, we have already tried this. Neither of us have a MISSING reference - and neither of us have any kind of reference to Excel, for that matter. This is intentional, our code uses late binding, because we don't always know a priori what Excel library version our...

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...

I know I'm resurrecting an old thread here, but this post was the top result in my Google search on this issue. If you're trying to use the "&" symbol within a string (like AT&T for example), you would set the Caption value to "AT&&T" (without the quotes), as the posters above have described...

I actually got the same error when I tested it in your database, I was hoping that it was just something with my machine. I have tried searching for descriptions for that error message and I haven't found any. I'm afraid this one is above my pay grade. I would have to wait to see what somebody...

Try changing Column(0, b) to Column(1, b). Column 0 has your check-boxes, Column 1 is the one that actually has the ID value. Does that fix it for you?

Try this instead: Dim b As Long For b = 0 To Me.cboBeschikbaar.ListCount - 1 If Me.cboBeschikbaar.Column(0, b) = RijID Then Exit For Else End If Next b Me.cboBeschikbaar = Me.cboBeschikbaar.ItemData(b) Your last code didn't have b inside of the loop, so it was running the same check over and...

Alright, I finally got it figured out. It was a doozy, but it was fun to think through this and use some creative magic here! For anyone out there reading, here's what I ended up doing: SelectedIDs = "" SelectedTypes = "" MaxUpdateNumber = 0 Me.[SubformName].Form.Recordset.MoveFirst While...

Thanks for your quick reply again. This part has turned out to be pretty easy actually, I can construct the IN statement with the proper format. Now I need to tackle sorting it on the fly. Depending on the order of what they checked, it's possible that sSQL_IN could be: 'Start', 'Update 3'...

The other alternative is to make a static IN statement with an arbitrary number of update columns (the max number we would ever expect to see), and then once the spreadsheet is exported, use VBA to delete all the extra blank columns, but I haven't gotten that to work either. I've gotten it...

That's the main idea I had in mind, but I'm not sure how to build the IN statement programmatically with the proper format. Would you store the user's selections as a recordset, and then loop through the comment type field for each record, and tack it on to a string? If that would work, how...

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 |...