Selasa, 14 Juni 2016

RE: [MS_AccessPros] Extracting Initial From Fist Name - OOOPS

 

And here I thought I was the only one around who remembers how cold and stormy it was on Day1 of the MS calendar. 8->)

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, June 14, 2016 7:44 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Extracting Initial From Fist Name - OOOPS

 

 

you went to high school in the 1800's? wow, Bill ~ no wonder you know so much :)

"... help me with my math homework which she knew nothing about. Talking it out ..."
... blog?

warm regards,
crystal

~ have an awesome day ~

On 6/13/2016 1:28 PM, wrmosca@comcast.net [MS_Access_Professionals] wrote:

I'm the only one in our department who codes VBA so I'm stuck figuring out a lot of stuff on my own, but I find if I walk through the code with someone and explain what is going on I jog my brain enough to figure out the problem.

 

When I was in high school (yes they had high schools in the 1800's) my mom would try to help me with my math homework which she knew nothing about. Talking it out with her usually got me over what I was stuck on.

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 

 



---In MS_Access_Professionals@yahoogroups.com, <argeedblu@gmail.com> wrote :

I have frequently had the same experience. My take on the phenomenon is that the limitations of email as a communication medium force us to think about and explain our concern to a much greater depth than would be the case if we weren't hoping to engage someone else in seeking a solution. More succinctly, writing the problem gets it out of our heads.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, June 13, 2016 10:52 AM
To: 'MS_Access_Professionals@yahoogroups.com' <MS_Access_Professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] Extracting Initial From Fist Name - OOOPS

 

 

One of the many things I love about this group is that I have sometimes found my error while typing out my problem for the forum, then deleted my email, and went on to the work.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Sunday, June 12, 2016 11:35 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Extracting Initial From Fist Name - OOOPS

 




I had missed the fact that Robin's first post used an "=" while the second correctly used ":".  I was looking at the expression and couldn't find a difference in the posts.

 

Duane Hookom, MVP
MS Access


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 13 Jun 2016 16:12:19 +1000
Subject: Re: [MS_AccessPros] Extracting Initial From Fist Name - OOOPS




Thanks Crystal

Yes all is well, The error was mine!  Again!!!

Cheers,

Robin

At 13/06/2016 01:41 PM, you wrote:

 

Hi Robin,

so you're good?

if not, please check your field name in the table design ... and ensure there is no field called Initial in the source of the query

thanks

warm regards,
crystal

~ have an awesome day ~

On 6/12/2016 7:07 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] wrote:


The "OOOPS" message confirmed that I had corrected my mistake. It showed the original message and the corrected version.

Thanks for the support.

Regards,

Robin Chapple

At 13/06/2016 01:54 AM, you wrote:

 

What do you mean by "failed miserably"?

Based on your values, your expression should have worked. I think we are missing part of the puzzle.

Duane Hookom, MVP
MS Access

Get Outlook for iOS




On Sun, Jun 12, 2016 at 1:56 PM +0200, "Robin Chapple robinski@westnet.com.au [MS_Access_Professionals]" < MS_Access_Professionals@yahoogroups.com> wrote:



Duane,

A sample is below.

Regards,

Robin



Wilma
Vickie
Val
Val
Trisha
Trial Stay
Thelma
Susan
Susan
Shirley
Shirley
Shirley
Shirley
Shirley
Sarah
Rosie
Rosemay
Rita
Rene
Phillipa
Peggy
Peg
Pearl
Pauline
Patricia
Patricia
Pat
Pat
Pat
Pam
Norma
Norma
Norma
Nancy
Nancy
Nancy
Nadia
Mona
Molly
Millie
Michele
McDonald
Maureen
Maureen
Mary
Mary
Mary
Marie
Margo
Margery
Margaret
Margaret
Marg
Luciana



At 12/06/2016 04:39 PM, you wrote:

 

Robin,
Could you provide a variety of actual first name values?

Duane Hookom, MVP
MS Access

Get Outlook for iOS




On Sun, Jun 12, 2016 at 3:38 AM +0200, "Robin Chapple robinski@westnet.com.au [MS_Access_Professionals]" < MS_Access_Professionals@yahoogroups.com> wrote:



OOOPS!


Initial:Left([mFirstName],1)

That's better.

Cheers,

Robin



At 12/06/2016 11:13 AM, you wrote:

 


I need to extract the initial from the first names in a member directory.

I tried using this in a query - Initial=Left([mFirstName],1) and
failed miserably.

What have I missed?

Many thanks,

Robin Chapple

 

 

 






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

 

__._,_.___

Posted by: "Glenn Lloyd" <argeedblu@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (14)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Poskan Komentar