Search results

I finally got it... figured out what I was doing wrong. In my query, I had the "Smartcase" and "Correctname" switched for first and last name. Once I made both using "Correctname" worked great. I also added this to correct the letter after the "Mac" if it should be capitalized. So if anyone...

I did the same thing, put exactly what you did. Created a form just to test the last names and it works fine. Don't know why it will not show in the test query. Now here's another one for you. Suppose you have a last name that is Macion or Mack or something that the letter after the C is...

This Smartcase-Function: Smartcase([LastName]) with the Rtrim in a qeury field for the lastname.

Boblarson: How about using a RTrim and something else on the same field in a query?

I see, if you are joining items you must use the & ", " &. I was trying the + and just the &. Thanks

TrimmedLastName: RTrim([LastName]) Could that be added with another function in the same field in a query. Two functions in one field?

There will be times I will import data from an excel spreadsheet and others, I have techs entering names that sometimes don't care how they type the names. Blank spaces, all upper, all lower, mixed. They can't seem to follow one simple rule of Proper naming with upper and lower case. Thus me...

Because this portion of that module: 'Look for and fix "Mac" If InStr(1, strName, "Mac") Then strName = Left(strName, InStr(1, strName, "Mac") - 1) & "Mac" & _ StrConv(Mid(strName, InStr(1, strName, "Mac") + 3), vbUpperCase) End If Is not working for me. Was wondering if there was another way...

http://www.access-programmers.co.uk/forums/showthread.php?t=55235&highlight=CorrectName Towards the bottom... I found it in two seconds searching on "CorrectName"

Its in the "Modules & VBA" discussion side. Search for "Case conversion" and it posted by "billyr".

This is what I obtained from this forum: Public Function CorrectName(ByVal strName As String) As String On Error GoTo err_CorrectName Dim intCounter As Integer strName = StrConv(strName, vbProperCase) renameMac = StrConv(strName, vbProperCase) 'Look for and fix "Mc" If InStr(1, strName, "Mc")...

Can you give me an example used in each... Query, Form field. Careless about the macro. Trying to stay away from that. Use field "LastName"

That is my guess, there is an IF/Then/EndIF for each one (Mc, Mac, O', and -). My guess it is hitting the first IF which is the "Mc" and crapping out on the rest. But then again, the "-" function is working if the user has two last names. No irish names to verify if the "O'" is working unless...

can this be put in the table or query? or is it only available to the form fields?

Here is what I put.... 'Look for and fix "Mac" If InStr(1, strName, "Mac") Then strName = Left(strName, InStr(1, strName, "Mac") - 1) & "Mac" & _ StrConv(Mid(strName, InStr(1, strName, "Mac") + 3), vbProperCase) End If CorrectName = strName CorrectName being the function name... Still not...

Not working for me..... Is there a way to fix the names in the table itself vice the forms? I have this in a simple query and it works fine less the "Mac" part. Smartcase-Function: Smartcase([LastName]) If there was a way to get around all this and fix it in the table itself, that...

Having problems getting this portion of the module to work. 'Look for and fix "Mac" If InStr(1, strName, "Mac") Then strName = Left(strName, InStr(1, strName, "Mac") - 1) & "Mac" & _ StrConv(Mid(strName, InStr(1, strName, "Mac") + 2), vbProperCase) End If No matter what you type, it will not...

Do you have winzip? that is the best way to zip it and attach it here.

do you know how to make a zip file? once you do, then where you reply back, just attach it there using the paperclip at the top where the toolbar is.

can you zip ur DB and send to me to take a look?