Search results

That replaced every - in between every ECX29 and C7 (for this example) with a *. and then I used the used the code you suggested to add * before ECX29 and after C7 Thanks a lot! Your replies were VERY helpful!!

Ahhh! I just figured it out!! :D This is what I did and it worked: varCode = Replace(varCode, "-", "*") 'replace each - with *

A lot... That can't work. ECX29-C7 was just an example. So that line of code won't work...

Where u is equal to each value in the array that I'm searching for in table2. Did I confuse you yet?

I forgot to attach my code. Here it is: If DCount("Structure", "RoicStructure", "[Structure] Like '*" & u & "*'") > 0 Then

Okay. I tried this and it finds all fields that have ECX29-C7 at the beginning. But what about ECX29-D2-C7 ? It still has ECX29-C7 but with a D2 in between. How do I change the - to a * in order for it the database to search for the whole thing?

I'm not sure how to do that?...I just joined yesterday

Thank you! But When I try that it still doesn't go through the IF statement. Okay. Let me explain more clearly what I'm trying to do: 1)User inputs part number 2)Check user input (part number) exists in table1 3)If it does, take all associated values and put in array 4)Take each value in...

Yes. I'm sorry. It was my first time here and I wasn't sure how this works. Thank you for your reply.

Thanks! I'm trying to incorporate that into an If statement though... I'm probably really confusing right now. Let me explain, so what is supposed to happen is that the user enters in a part number..through the IF statement, the code detects if the user input even exists in the table. And if it...

Whoa! My bad. Relax. First time here. Posted in the wrong place. By the way thanks for the reply! Very helpful :)

Hi. I have a problem with my vba code and I would appreciate any help I can get! What my code is supposed to be doing is taking in a user input (example: 38A1018X002) searching Table1 for it's associated value (ECX29-C7) Then taking in that found value and looking it up in a different table. I...

Hi. I have a problem with my vba code and I would appreciate any help I can get! What my code is supposed to be doing is taking in a user input (example: 38A1018X002) searching Table1 for it's associated value (ECX29-C7) Then taking in that found value and looking it up in a different table. I...

Hi. I have a problem with my vba code and I would appreciate any help I can get! What my code is supposed to be doing is taking in a user input (example: 38A1018X002) searching Table1 for it's associated value (ECX29-C7) Then taking in that found value and looking it up in a different table. I...