Buat macro dari menu create , pilih Macro
disana ada beberapa combobox dan textbox.
setLocalVar
Name : locContoh
Expression = "ABC kecap yang mantap"
MessageBox
Message : =[LocalVars]![locContoh]
SetLocalVar
Name : locposisi
Expression = InStr(1,[LocalVars]![locContoh]," ",1)
SetLocalVar
Name : lochasil
Expression = Mid([LocalVars]![locContoh],[LocalVars]![locposisi]+1,Len([LocalVars]![locContoh])-[LocalVars]![locposisi]) & " " & Left([LocalVars]![locContoh],[LocalVars]![locposisi]-1)
MessageBox
Message : =[LocalVars]![lochasil]
'=============
Saya ingin sertakan screen shoot , di [Files] [jkssbma] [cobasolusi] [web Macro] dengan nama [Buatmacro.pdf]
--- In belajar-access@yahoogroups.com, Aksan Kurdin <aksan.kurdin@...> wrote:
>
> Terus, caranya gimana di access web ?
> Bagi dong ?
>
> aksan kurdin
>
>
>
> On 11/24/2010 8:44 PM, Arief Noorshiam wrote:
> > Alhamdulillah, sudah bisa
> >
> > Sorry kalau agak telat balesnya, jarang online sih ^_^
> > Terkadang masalah sepele, tapi kalau nggak konsen ya begini nih jadinya.
> > Anyway, busway.... makasih semuanya atas pencerahan yang diberikan
> >
> > Salam
> > Arief Noorshiam
> >
> > ----------------------------------------------------------
> > *From:* aksankurdin <aksan.kurdin@...>
> > *To:* belajar-access@yahoogroups.com
> > *Sent:* Fri, November 19, 2010 6:07:35 PM
> > *Subject:* [belajar-access] Re: Manipulasi String
> >
> > Aku belum bisa :(
> >
> > aksan kurdin
> >
> > --- In belajar-access@yahoogroups.com
> > <mailto:belajar-access%40yahoogroups.com>, privat access
> > <les.access@> wrote:
> > >
> > > masa sih di versi web ga bs???? :D
> > > pastinya bs dunk kang... kan ga harus slalu di vba kan??? ;)
> > >
> > >
> > >
> > > Pada 18 November 2010 11.31, Bambang Hartoko
> > <bambanghartoko@>menulis:
> > >
> > > >
> > > >
> > > > mid(string,5) & " " & left(string,3)
> > > >
> > > > Salam,
> > > >
> > > > *Bambang Hartoko*
> > > >
> > > > --- On *Thu, 11/18/10, noorshiam <noorshiam@>* wrote:
> > > >
> > > >
> > > > From: noorshiam <noorshiam@>
> > > > Subject: [belajar-access] Manipulasi String
> > > > To: belajar-access@yahoogroups.com
> > <mailto:belajar-access%40yahoogroups.com>
> > > > Date: Thursday, November 18, 2010, 10:39 AM
> > > >
> > > >
> > > >
> > > >
> > > > Dear All My Best Friend At Belajar-Access ^_^
> > > >
> > > > To the point aja, misal saya punya string berikut :
> > > >
> > > > ABC Mentimun Jepang
> > > > ABC Labu Siyem
> > > > BCD Kangkung Lombok
> > > > DEF Cabe Rawit
> > > >
> > > > Nah, bagaimana cara memanipulasi string diatas sehingga menjadi :
> > > >
> > > > Mentimun Jepang ABC
> > > > Labu Siyem ABC
> > > > Kangkung Lombok BCD
> > > > Cabe Rawit DEF
> > > >
> > > > Atas bantuan dan pencerahan rekan-rekan yang baik, saya haturkan
> > > > banyak-banyak terima kasih.
> > > >
> > > > Salam
> > > >
> > > > Arief Noorshiam
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
>
__._,_.___
SPAM IS PROHIBITED
Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
No comments:
Post a Comment