Recent content by imaquad

Thank you for your speed at replies. if I come across a name like McDonald and the conversion yields Mcdonald, I want the next letter after the MC to be upper case. This would apply to Mcdaniel, mcspadden, Mcgibbons, etc. Each name needs the next letter after "Mc to be upper case

I have tried to figure out what it means in the formula above "then do this..." I opened a new module and placed the formula in the module but I have researched these few words and keep coming up blank.

I have worked the "front door" of this database for 15+ years but never the "back door" with modules, expressions, etc. I had this idea because I would usually convert my mailing list query to Excel then make these letter case adjustments. Then, I had the notion that I could send the "correct "...

where is this function added? For the "proper" conversion, I created a query

I am assuming by "set up a validation" it is something done in a query. the Conv did make them proper. How is this done?

not to be picky, but it does not convert the "Mcclain" to McClain" ex. This will unprofessional in a mailing. I had to manually change them in Excel before importing them back to access Also PO Box is coming out as Po Box. If I corrected each of them, it would take a long time. there are over...

i wanted to change the case in my linked tables. i exported each table in Excel and did work on each table to make the case from caps to proper. I then imported each excel file back into my Access database. As each file imported, I was asked about the primary key. Knowing my linked tables relied...