[belajar-access] Re: Manipulasi String Versi Web

masalahnya fasilitas macro masih terbatas.
Tapi saya belum tahu bagaimana cara menjalankan fungsi/sub ( dengan code vba ) di module. sepertinya tak bisa

'===

--- In belajar-access@yahoogroups.com, Aksan Kurdin <aksan.kurdin@...> wrote:
>
> berarti fungsi intrinsic bisa, pak dar.
> sekarang bisa gak ya modul / function vba di jalankan dari macro. kalau
> modul tab gak ada, di akali dengan reference ke access file lain kali.
> maju terus pak dar.
>
>
> aksan kurdin
>
> On 11/25/2010 11:33 AM, sudarsono wrote:
>
>
> > 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
> > <mailto:belajar-access%40yahoogroups.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
> > <mailto:belajar-access%40yahoogroups.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>
> > > > <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>
> > > > <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 PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/