|
 |
access thread: Get First letter
Message #1 by "ivan matema" <ivanmatema@m...> on Wed, 20 Nov 2002 07:29:21
|
|
hie,
i need to get the first letter of a textbox entry and display it somewhere
else, like a label.
eg, to get the "I" in Ivan
anyone?
Message #2 by "Foote, Chris" <Chris.Foote@u...> on Wed, 20 Nov 2002 07:27:14 -0000
|
|
Morning Ivan!
Suggest you use the "Left" function.
Ie
Left(<Textbox>,1)
will give you first letter!
Regards!
Spike
> -----Original Message-----
> From: ivan matema [mailto:ivanmatema@m...]
> Sent: Wednesday, November 20, 2002 7:29 AM
> To: Access
> Subject: [access] Get First letter
>
>
> hie,
> i need to get the first letter of a textbox entry and display
> it somewhere
> else, like a label.
> eg, to get the "I" in Ivan
> anyone?
>
Message #3 by "ivan matema" <ivanmatema@m...> on Wed, 20 Nov 2002 08:08:58
|
|
THANX A MILL Spike...
> Morning Ivan!
Suggest you use the "Left" function.
Ie
Left(<Textbox>,1)
will give you first letter!
Regards!
Spike
> -----Original Message-----
> From: ivan matema [mailto:ivanmatema@m...]
> Sent: Wednesday, November 20, 2002 7:29 AM
> To: Access
> Subject: [access] Get First letter
>
>
> hie,
> i need to get the first letter of a textbox entry and display
> it somewhere
> else, like a label.
> eg, to get the "I" in Ivan
> anyone?
>
Message #4 by "Foote, Chris" <Chris.Foote@u...> on Wed, 20 Nov 2002 08:01:12 -0000
|
|
No problems Ivan!
If you have any more problems do not hesitate to 'mail me direct!
I've spent the last few days using text manipulation (or mutilation). Ok
this was in Excel, but there's a lot of commonality.
Regards!
Spike
> -----Original Message-----
> From: ivan matema [mailto:ivanmatema@m...]
> Sent: Wednesday, November 20, 2002 8:09 AM
> To: Access
> Subject: [access] RE: Get First letter
>
>
> THANX A MILL Spike...
Message #5 by joe.dunn@c... on Wed, 20 Nov 2002 09:04:06 +0000
|
|
Left(YourTextControl),1)
*************************************************************************
This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.
The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686 Internet http://www.cis.co.uk E-mail
cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
Message #6 by "Steve Klein" <Stephen@K...> on Wed, 20 Nov 2002 18:19:38 -0000
|
|
That one I knew - but what if I want the reverse? to exclude the first chunk
of a string?
I have a number of records which are
"Awaiting allocation Social Work"
"Awaiting allocation OT"
"Awaiting allocation Community Care Coordinator"
How can I strip these texts down to "Social Work, "OT" and "Community Care
Coordinator"
Steve K
-----Original Message-----
From: joe.dunn@c... [mailto:joe.dunn@c...]
Sent: 20 November 2002 09:04
To: Access
Subject: [access] Re: Get First letter
Left(YourTextControl),1)
*************************************************************************
This e-mail may contain confidential information or be privileged. It is
intended to be read and used only by the named recipient(s). If you are not
the intended recipient(s) please notify us immediately so that we can make
arrangements for its return: you should not disclose the contents of this
e-mail to any other person, or take any copies. Unless stated otherwise by
an authorised individual, nothing contained in this e-mail is intended to
create binding legal obligations between us and opinions expressed are those
of the individual author.
The CIS marketing group, which is regulated for Investment Business by the
Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R -
for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 -
for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL Telephone
0161-832-8686 Internet http://www.cis.co.uk E-mail cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The
Co-operative Bank p.l.c., registered in England and Wales number 990937,
P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS
Policyholder Services Limited as agent of the Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
****************************************************************************
****
Message #7 by "Carnley, Dave" <dcarnley@a...> on Wed, 20 Nov 2002 12:30:35 -0600
|
|
right(s, len(s) - (instr(s,w,1) + len(w))
where s is the whole string and w is the beginning piece to be ignored
this might be 1 character off so check it before you use it...
-----Original Message-----
From: Steve Klein [mailto:Stephen@K...]
Sent: Wednesday, November 20, 2002 12:20 PM
To: Access
Subject: [access] Re: Get First letter
That one I knew - but what if I want the reverse? to exclude the first chunk
of a string?
I have a number of records which are
"Awaiting allocation Social Work"
"Awaiting allocation OT"
"Awaiting allocation Community Care Coordinator"
How can I strip these texts down to "Social Work, "OT" and "Community Care
Coordinator"
Steve K
-----Original Message-----
From: joe.dunn@c... [mailto:joe.dunn@c...]
Sent: 20 November 2002 09:04
To: Access
Subject: [access] Re: Get First letter
Left(YourTextControl),1)
*************************************************************************
This e-mail may contain confidential information or be privileged. It is
intended to be read and used only by the named recipient(s). If you are not
the intended recipient(s) please notify us immediately so that we can make
arrangements for its return: you should not disclose the contents of this
e-mail to any other person, or take any copies. Unless stated otherwise by
an authorised individual, nothing contained in this e-mail is intended to
create binding legal obligations between us and opinions expressed are those
of the individual author.
The CIS marketing group, which is regulated for Investment Business by the
Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R -
for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 -
for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL Telephone
0161-832-8686 Internet http://www.cis.co.uk E-mail cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The
Co-operative Bank p.l.c., registered in England and Wales number 990937,
P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS
Policyholder Services Limited as agent of the Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
****************************************************************************
****
Message #8 by "John Pace" <jpace@h...> on Wed, 20 Nov 2002 12:41:09 -0600
|
|
Use the mid function. In this situation, it would be
Mid((YourControl), 19, len(YourControl))
This may be off one character so be sure to check it.
John
-----Original Message-----
From: Steve Klein [mailto:Stephen@K...]
Sent: Wednesday, November 20, 2002 12:20 PM
To: Access
Subject: [access] Re: Get First letter
That one I knew - but what if I want the reverse? to exclude the first
chunk
of a string?
I have a number of records which are
"Awaiting allocation Social Work"
"Awaiting allocation OT"
"Awaiting allocation Community Care Coordinator"
How can I strip these texts down to "Social Work, "OT" and "Community
Care
Coordinator"
Steve K
-----Original Message-----
From: joe.dunn@c... [mailto:joe.dunn@c...]
Sent: 20 November 2002 09:04
To: Access
Subject: [access] Re: Get First letter
Left(YourTextControl),1)
************************************************************************
*
This e-mail may contain confidential information or be privileged. It is
intended to be read and used only by the named recipient(s). If you are
not
the intended recipient(s) please notify us immediately so that we can
make
arrangements for its return: you should not disclose the contents of
this
e-mail to any other person, or take any copies. Unless stated otherwise
by
an authorised individual, nothing contained in this e-mail is intended
to
create binding legal obligations between us and opinions expressed are
those
of the individual author.
The CIS marketing group, which is regulated for Investment Business by
the
Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number
3615R -
for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965
-
for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL Telephone
0161-832-8686 Internet http://www.cis.co.uk E-mail cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The
Co-operative Bank p.l.c., registered in England and Wales number 990937,
P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by
CIS
Policyholder Services Limited as agent of the Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
************************************************************************
****
****
Message #9 by "Leo Scott" <leoscott@c...> on Wed, 20 Nov 2002 13:51:53 -0800
|
|
Dim str as string
str=Replace("Awaiting allocation Social Work","Awaiting allocation ","")
Replace(SourceString, StringtoFind, ReplacementString)
Replace will replace all occurances of StringtoFind with ReplacementString
in the SourceString.
This function was implemented in Office 2000 and above.
|-----Original Message-----
|From: Steve Klein [mailto:Stephen@K...]
|Sent: Wednesday, November 20, 2002 10:20 AM
|To: Access
|Subject: [access] Re: Get First letter
|
|
|That one I knew - but what if I want the reverse? to exclude the
|first chunk
|of a string?
|
|I have a number of records which are
|
|"Awaiting allocation Social Work"
|"Awaiting allocation OT"
|"Awaiting allocation Community Care Coordinator"
|
|How can I strip these texts down to "Social Work, "OT" and "Community Care
|Coordinator"
|
|
|
|Steve K
|
|
|-----Original Message-----
|From: joe.dunn@c... [mailto:joe.dunn@c...]
|Sent: 20 November 2002 09:04
|To: Access
|Subject: [access] Re: Get First letter
|
|
|
|Left(YourTextControl),1)
|
|*************************************************************************
|
|This e-mail may contain confidential information or be privileged. It is
|intended to be read and used only by the named recipient(s). If you are not
|the intended recipient(s) please notify us immediately so that we can make
|arrangements for its return: you should not disclose the contents of this
|e-mail to any other person, or take any copies. Unless stated otherwise by
|an authorised individual, nothing contained in this e-mail is intended to
|create binding legal obligations between us and opinions expressed
|are those
|of the individual author.
|
|The CIS marketing group, which is regulated for Investment Business by the
|Financial Services Authority, includes:
|Co-operative Insurance Society Limited Registered in England number 3615R -
|for life assurance and pensions
|CIS Unit Managers Limited Registered in England and Wales number 2369965 -
|for unit trusts and PEPs
|CIS Policyholder Services Limited Registered in England and Wales number
|3390839 - for ISAs and investment products bearing the CIS name
|Registered offices: Miller Street, Manchester M60 0AL Telephone
|0161-832-8686 Internet http://www.cis.co.uk E-mail cis@c...
|
|CIS Deposit and Instant Access Savings Accounts are held with The
|Co-operative Bank p.l.c., registered in England and Wales number 990937,
|P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS
|Policyholder Services Limited as agent of the Bank.
|
|CIS is a member of the General Insurance Standards Council
|
|CIS & the CIS logo (R) Co-operative Insurance Society Limited
|
|*******************************************************************
|*********
|****
|
|
|
|
|
|
|
View Cart
