Recent content by mulch17

  1. M

    Can you add Option Explicit or Error Handling to several modules at one time?

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

    Can you add Option Explicit or Error Handling to several modules at one time?

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

    Can you add Option Explicit or Error Handling to several modules at one time?

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

    Intermittent 429 ActiveX Component Error - machine-specific issue?

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

    Trying to Improve Performance Time/File Size of Modules

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

    Trying to Improve Performance Time/File Size of Modules

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

    Intermittent 429 ActiveX Component Error - machine-specific issue?

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

    Intermittent 429 ActiveX Component Error - machine-specific issue?

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

    Intermittent 429 ActiveX Component Error - machine-specific issue?

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

    Intermittent 429 ActiveX Component Error - machine-specific issue?

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

    Intermittent 429 ActiveX Component Error - machine-specific issue?

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

    Using Ampersand On Label

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

    scroll to item in listbox VBA

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

    scroll to item in listbox VBA

    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?
  15. M

    scroll to item in listbox VBA

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