Search results

Alright, sounds good I will try that!!!!!!!! Thanks:D

Ok thanks, Can you tell me if I copy the following statement and add it the module only changing the prefix_length = 3 instead of 4 after the same statement, will cause the query to catch more instances of space variations to correct and flip more names correctly?

Thanks Craig!!!!!!!!!!!!!!!!!!!!!!!!!:D

Ok, Thanks for explaining the difference between the private and public function. I see now that the reason why the script worked at home is because I imported a table into your db example which had the public function defined under the modules. Thanks!!!!

Ok Craig, I'm using Access 2003 @ home and work. The only reference that I have different from your is Microsoft Access 11.0 Object Library. I was told by some others in this forum that "flipname" is not a valid function of vba or sql??? I'm not sure how it works!!! The error that I rec'd...

Yea I was still in the waking mode!!! :o

Hello AJE, I was told by someone yesterday that flipname was a vba public function...yea I searched and couldn't find anything about it!!! Somehow the script worked at home, but not at the office. I will play with it some more and try to find an alternative function that will do what I need it...

Instr name flipping assistance!!!!! Hello, I need help tweaking the query below. InStr(UCase([shortname])," JR")>0 Or InStr(UCase([shortname])," II")>0 Or InStr(UCase([shortname])," III")>0,FlipName(UCase([shortname])),UCase([shortname] This is error message that I receive "undefined...

Craig, I was able to get this code to work at home but not at work. Is there a particular library that I need to reference in order for this to work? If so, which one? Thanks!

Brian...please disregard my last post. I was actually refering to another issue I'm having....Thanks again!

Brian! Question? I was able to get the query to work at home but not at work. Is there a particular library that I need to reference? If so, which one? Thanks!

Hey Craig, I tried your query...tweaked it alittle and it worked. Stills needs some tweaking because it didn't catch all of the JR's for some reason????? Thanks

I appreciate the input, it will be put use! Thanks Chris!

My apology Brian and AJE I was to get the code to work once I got home...I really appreciate your help!!!!!!!! ltr!:) Mate

Ok thanks Craig I'll try it out this out at home...since it seems I need home work today..lol!!! I'm leaving my office for the day!!!

Don't worry Brian I wasn't able to get his Update to work nor your Iif statement. I attempted the above code and I could not get it to run. Even if I could, I believe that I need and "instrrev" statement to first flip any dates that are in YYYYMMDD to MMDDYYYY and then add slashes MM/DD/YYYY to...

I attempted the above code and I could not get it to run. Even if I could, I believe that I need and instrrev statement to first flip any dates that are in YYYYMMDD to MMDDYYYY and then add slashes MM/DD/YYYY to get the result that I need

Unfortunately I can't pick the names up in components because there are too many. I'm dealing with very dirty tables that I have to correct the formatting for, so that it can be loaded into other systems for processing.

Thanks for the reply Brian. The only problem with what you just said is that I'm working with a very large table in which all dates in the field I need to manipulate are text values in which I need to keep them as text formatted. I just need to about half the fields are already in the MM/DD/YYYY...

No this isn't a re-post. I really appreciate your reply. I'm still attempting to get the Iif statement logic working in a query.