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!

  • Congratulations Mike Lewis 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. PugnaxX

    Many to Many With Privacy/Security (without a combo box)

    This particular form will be used to add new customers to the database. So the flow will be: 1. 1st Individual enters his/her information in individual table. 2. Subsequent individuals enter his/her information in individual table. 3. A "master" account is created for the "set" of individuals...
  2. PugnaxX

    Many to Many With Privacy/Security (without a combo box)

    My apologies, it looks like I double posted this thread by accident
  3. PugnaxX

    Many to Many With Privacy/Security (without a combo box)

    Hi All! I'm building a database that a customer would be updating via a form. This is for a pet sitting service, so I may have 1 or many co-owners of a pet, therefore one or many individuals for each Customer Account. Also, each individual may have 1 or many customer accounts. I have the...
  4. PugnaxX

    Adobe Photoshop CS3 Locked File will not open

    thread229-1476031 We had a similar issue here. Here's the setup and situation: We have Windows XP Pro SP3 with two Administrators and one user. The computer has two HDDs, 1 partitioned into two drives (125gb each, 1 holds the OS and programs, the other is network shared for user uploads) and...
  5. PugnaxX

    Excel List of Duplicates and Cell Addresses within Workbook

    Thanks Skip, I'll do some research and figure out how to pivot and filter counts of 1 out and see what I can come up with. It's been revealed to me that it's not all the data on all the worksheets I need to be worrying about so, my objective has now changed a bit. I need to check all...
  6. PugnaxX

    Excel List of Duplicates and Cell Addresses within Workbook

    Right, Case "Summary" appears in FindWord and BuildList to exclude the Summary worksheet which is the only worksheet that I don't want included in the list of duplicates. I understand that BuildList creates basically a source range of all values for the Main sub to pick duplicates from and I...
  7. PugnaxX

    Excel List of Duplicates and Cell Addresses within Workbook

    Hey Skip, I've been working with it, just testing it out and with that last bit of code you posted it's almost working! My test was to list the values 1,2,3,4 & 5 down column A on worksheet 1 and then 1,2,3,4 down the column A on worksheet 2. After I run BuildList, I have all unique values...
  8. PugnaxX

    Excel List of Duplicates and Cell Addresses within Workbook

    The former is the desired behavior, "procedure will start with the first cell on the first sheet, search for duplicates, then the second cell, search for duplicates... until all the cells on the first sheet have been used, then preceed to the second sheet" and when it checks for duplicates for a...
  9. PugnaxX

    Excel List of Duplicates and Cell Addresses within Workbook

    Hey Skip, I've tried out the code and can't seem to get it to work for me. I created the worksheet "Summary" and ran the code (Sub Main). It gave me a list of Sheets and Ranges, but no values for the duplicates. The sheets and ranges that it gives seem random and refer to cells that are...
  10. PugnaxX

    Excel List of Duplicates and Cell Addresses within Workbook

    Hi All, I have several workbooks that are 100 worksheets or so and I would like to be able to have a macro that searches for duplicate data across worksheets and generates a list of the offending data values, along with their cell addresses. I have the following code from thread707-1379708...
  11. PugnaxX

    Excel Search / Find Function Hide All That Do Not Match

    Anybody have any more advice? I'm on my last day! Regardless of any more advice you may be able to spare, I do want to thank you, Skip and PHV for your help thus far though. I really appreciate the time you've taken to try to help me! Sincerely, PugnaxX
  12. PugnaxX

    Excel Search / Find Function Hide All That Do Not Match

    Hey PHV, I just tried it, it looks like the search works fine still with that reordering, but still no message when not found. I stepped through the code for the search and when "Not r Is Nothing" is not true (string not found), it skips over the else statement that contains the message box...
  13. PugnaxX

    Excel Search / Find Function Hide All That Do Not Match

    Anybody have any ideas? I'm in kind of a bunch, tomorrow is my last day here at work for a while and I need to have this working for release? I still can't seem to get the message box to pop up, it's as if it skips the Else code that contains the Entry Not Found Message Box altogether. Any...
  14. PugnaxX

    Excel Search / Find Function Hide All That Do Not Match

    The search part now works GREAT! However, the only thing wrong with it is when something is not found it does NOT display the MsgBox "Entry Not Found". If something is not found the macro just ends. Any thoughts? SOOO close to having this DONE! Thanks again for all of your help! PugnaxX
  15. PugnaxX

    Excel Search / Find Function Hide All That Do Not Match

    There are a couple issues with the new code. These are the results that you get using the following code variations: Loop While lPrevRow < r.Row >NO Hanging when criteria NOT FOUND (this is great!) >DOES NOT FIND ALL instances of partial search string (ex: "2" instead of full part number...
  16. PugnaxX

    Excel Search / Find Function Hide All That Do Not Match

    What I've found is, if no match is found, the code runs on forever. I was thinking if I could limit the range that it searches to only the range of rows that contain data, then it would result in 1) Quicker Searches & 2) Elimination of the Hanging problem. If there is another solution, I am...
  17. PugnaxX

    VB Macro Error

    If it turns out it is a worksheet protection issue, you could record a macro while you unprotect and protect the worksheet. Then just place them respectively, at the beginning and end of the macro code. Unprotect Code <Your Code Here> Protect Code -PugnaxX
  18. PugnaxX

    Run Macro On Keystroke &quot;ENTER&quot; in Textbox

    THANKS bdmangum!!!!!! That did do the job, it works great! -PugnaxX
  19. PugnaxX

    Excel Search / Find Function Hide All That Do Not Match

    I am having trouble with the following section of code (full code available above): ============================================================ 'The following searches all hidden cells for a match to the value in cell A2 Dim r As Range, lPrevRow As Long Set r = Cells.Find(Range("A2"))...

Part and Inventory Search

Back
Top