Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. marduk813

    subqueries and/or multiple where clauses?

    Awesome! mrdenny's code works like a charm. Thank you very much! And thanks monksnake and r937 for your input too!
  2. marduk813

    subqueries and/or multiple where clauses?

    Thanks mrdenny! I will give this a shot and let you know how it works out. Jas
  3. marduk813

    subqueries and/or multiple where clauses?

    No, I will always need A and B specifically (for quantities), and I will always need A, B, and C for times. I just mentioned the possibility of more work types in case that would affect the query. There will more than likely be as many as 6 or 7 types, but I'm only concerned with A, B, and C.
  4. marduk813

    subqueries and/or multiple where clauses?

    This may be somewhat of a newbie question, but I'm having a hard time wrapping my head around it. I have a table that contains several columns including: Name, Type, Qty, Response_Time, and Complete_Time. Name is the name of the person, Type is a type of work "unit", Qty is the number of work...
  5. marduk813

    can worksheet names be seen without opening the workbook?

    Thanks Skip. I thought it might be faster to not open the workbook, but this will work. I disabled screen updating, so it all looks pretty seamless to the user. Thanks!
  6. marduk813

    can worksheet names be seen without opening the workbook?

    I have a small userform that prompts the user to select an existing workbook to be used as output for a macro. I also need the user to specify which sheet in the output file will be used. Is there a way to display a list of the worksheets in a workbook without actually opening the workbook? My...
  7. marduk813

    Kill statement not works

    Ok, so I figured out what was happening. I was opening the file for textstream reading and it wasn't closing it. Once I closed the textstream, I was able to Kill the file successfully. It's too bad I never got an error to give me some indication as to what was happening. Oh well. :)
  8. marduk813

    Kill statement not works

    Hi guys. I'm actually having a similar problem that's driving me nuts. When the Kill statement executes, nothing happens. I'm creating an HTML file in the root of C: for the purposes of copying its contents to an Outlook email. When I'm done, I wanted to delete the file just to clean it up, but...
  9. marduk813

    regex help

    Drederick, Thanks for the code sample. I wasn't able to get it to work like you have it here. The regex wouldn't return any matches. I was able to come up with another regex that gave me what I needed. I took the results, starting with "From:" and put them into an array. From there it was a...
  10. marduk813

    regex help

    bmgmzp, thanks for the info. I downloaded RegexBuddy and am toying with it now. I had Expresso, but RegexBuddy seems to have a few more options. Drederick, here's a sample header that I'm using: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding...
  11. marduk813

    regex help

    ...email addresses are in the "From" line, which are in the "To" line, and which are in the "CC" line) So far, I have this: (?i)(from:|to:|cc:).*([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3}) The email pattern was written by...
  12. marduk813

    question about referencing columns

    I've also just realized that I never needed to select the entire columns to begin with. Selecting just a row of cells in the range of columns does the same thing when I insert. I learn something new every day... :)
  13. marduk813

    question about referencing columns

    Skip, Thanks, that appears to have done the trick. I've seen your posts warning people to use Select as little as possible, though I'm not sure why. (Why?) I usually don't use it much, if at all, but I didn't know of any other way of inserting multiple columns at once without using a loop...
  14. marduk813

    question about referencing columns

    I'm trying to reference a group of columns based on an incrementing integer variable, and I'm having some trouble selecting them. I have a column counter variable called intColCounter, and I'm using the Columns property the way VBAJedi mentions here: thread707-730362. Columns(intColCounter + 2...
  15. marduk813

    FileExists question

    Well, formSub was modal, but I couldn't get it to call the particular sub when I closed formSub, but that was because the code was in the Open event of formMain. I moved all the code to a module and just directed all my calls to there. That took care of it. Thanks for the help PH! Jas
  16. marduk813

    FileExists question

    PH, That would work, except that I need something for a userform. I'm not sure where I could put the Application.OnTime method and have it constantly running while the userform is being used. I may not have been very clear earlier about what I needed. While the userform is loaded and visible, I...
  17. marduk813

    FileExists question

    firefytr, Using Dir() seems to have worked. I'm still not sure what was causing the problem with FileExists, but since this is working, I'm not going to worry about it. Now I just have to figure out how to get an event to run periodically on the form. Like a refresh event or something. Thanks!
  18. marduk813

    FileExists question

    The FileExists method. From the VBA help file:
  19. marduk813

    FileExists question

    I've got a userform set up to display a message if a particular file does not exist. The pathname and filename are stored in two different cells on my worksheet. When both the correct pathname and correct filename are present, FileExists returns True (as expected), however, even when I delete...
  20. marduk813

    cell border issue

    Thanks Zack. I had tried to manually create a border using the "none" line style (in the hopes that I could reproduce the effect), but it didn't work, so I had pretty much ruled it out. I changed my code so that instead of copying the entire row (including the formatting in the first cell), I...

Part and Inventory Search

Back
Top