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...
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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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...
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
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...
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...
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
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"))...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.