Hi Guys
I have the following code:
For some reason the instr functions dont seem to be working correctly. Are they correctly coded?Please Login or Register to view this content.
many thanks
Hi Guys
I have the following code:
For some reason the instr functions dont seem to be working correctly. Are they correctly coded?Please Login or Register to view this content.
many thanks
Last edited by JBeaucaire; 05-22-2015 at 08:46 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
well from what I know they are "coded" correctly...but probably not doing what you want....
InStr() returns a number. The where the first occurrance of the string you are looking for in the string you are searching. Next you are using a "&" which is a concatenation not an AND statement.
So, if you are trying say something like If this string is in this string AND this string is in this string, then this might work better
basically this says if the first Instr() returns something greater than 0, it found the string AND if the second Instr() returns something greater than 0, it found something, continue into the IF statement...hopefully this makes sense and I explained somewhat clearly...Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Howdy....just checking to see if this helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks