Biar lebih jelas dan mohon bantuan dari para fakar terutama bang Aksan
nich.
saya punya tabel
10000 ! kas ! Eqv IDR
!IDR ! 1,000,000
!USD ! 500,000
20000 ! Penempatan!
!IDR ! 2,000,000
!USD ! 1,500,000
saya ingin rubah menjadi
10000 ! kas ! Eqv IDR
10000 !IDR ! 1,000,000
10000 !USD ! 500,000
20000 ! Penempatan!
20000 !IDR ! 2,000,000
20000!USD ! 1,500,000
kalo dixcel kita tinggal record macro kemudian edit vbnya menjadi copy
perulangan, kalo di acces bagaimana untuk kasus seperti ini ya?pake query
,atau macro rasanya ngga bisa atau mungkin ada yg bisa? paling pakai modul
vb mungkin ya?
Terima kasih atas bantuannya
Re: cara belajar vb dalam Acces?
> <http://groups.yahoo.com/group/belajar-access/message/17045;_ylc=X3oDMTJybGRjcjJvBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzE3MDQ1BHNlYwNkbXNnBHNsawN2bXNnBHN0aW1lAzExOTU3MzM5NTc->
> Posted
> by: "aksan kurdin" [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> aksankurdin
> <http://profiles.yahoo.com/aksankurdin> Thu Nov 22, 2007 2:44 am (PST) Nggak
> ada,
> terpaksa anda harus melatih sendiri .... :)
>
> Aksan Kurdin
>
> On 11/22/07, ryan <[EMAIL PROTECTED] <yayan45%40gmail.com>> wrote:
> >
> > Kalo di excel biasanya saya pake record macro terlebih dahulu baru
> > kemudian kita edit hasil record tersebut.Cuman kalo di acces recordnya
> > dimana ya?
> > misal copy kolom dan baris ini ke baris dan kolom lain di excel kan
> > gampang tinggal select.(row,coloumn).value trus copy dst. Pas saya
> > coba di acces kok ngga mau ya mungkin instruksinya lain kaliya?
> > maaf hehe bila terlalu awam maklum new bie di VB acces
> >
>
> Recent Activity
>
> - 15
> New
> Members<http://groups.yahoo.com/group/belajar-access/members;_ylc=X3oDMTJmM2E4ODNmBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzExOTU3MzM5NTc->
>
> Visit Your Group
> <http://groups.yahoo.com/group/belajar-access;_ylc=X3oDMTJlMG12ZjBoBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTE5NTczMzk1Nw-->
> Yahoo! News
>
> Fashion
> News<http://us.ard.yahoo.com/SIG=12j48a34b/M=493064.10729659.12153716.8674578/D=groups/S=1705115370:NC/Y=YAHOO/EXP=1195741157/A=3848621/R=0/SIG=12u6o6g3h/*http://news.yahoo.com/i/1597;_ylt=A9FJqa5Gxa5E2jgAYQKVEhkF;_ylu=X3oDMTA2MnU4czRtBHNlYwNzbg-->
>
> What's the word on
>
> fashion and style?
> Search Ads
>
> Get new
> customers.<http://us.ard.yahoo.com/SIG=12jg7a5si/M=493064.10729656.11333347.8674578/D=groups/S=1705115370:NC/Y=YAHOO/EXP=1195741157/A=3848641/R=0/SIG=1312g85fq/*http://searchmarketing.yahoo.com/arp/srchv2.php?o=US2003&cmp=Yahoo&ctv=Groups2&s=Y&s2=&s3=&b=50>
>
> List your web site
>
> in Yahoo! Search.
> Women of Curves
>
> on Yahoo!
> Groups<http://us.ard.yahoo.com/SIG=12klto0e1/M=493064.11674772.12153082.11322765/D=groups/S=1705115370:NC/Y=YAHOO/EXP=1195741157/A=4990222/R=0/SIG=11odsb6gn/*http://new.groups.yahoo.com/Women_Of_Curves_Everywhere>
>
> see how women are
>
> changing their lives.
> Need to Reply?
>
> Click one of the "Reply" links to respond to a specific message in the
> Daily Digest.
> Create New Topic
> <http://groups.yahoo.com/group/belajar-access/post;_ylc=X3oDMTJla2RsZzUyBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTE5NTczMzk1Nw-->|
> Visit
> Your Group on the
> Web<http://groups.yahoo.com/group/belajar-access;_ylc=X3oDMTJjdWdzMHAwBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2hwBHN0aW1lAzExOTU3MzM5NTc->
>
> Messages<http://groups.yahoo.com/group/belajar-access/messages;_ylc=X3oDMTJlODJwMDEzBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA21zZ3MEc3RpbWUDMTE5NTczMzk1Nw-->|
> Files<http://groups.yahoo.com/group/belajar-access/files;_ylc=X3oDMTJmdTdqajJqBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2ZpbGVzBHN0aW1lAzExOTU3MzM5NTc->|
> Photos<http://groups.yahoo.com/group/belajar-access/photos;_ylc=X3oDMTJlZnQxN29zBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA3Bob3QEc3RpbWUDMTE5NTczMzk1Nw-->|
> Links<http://groups.yahoo.com/group/belajar-access/links;_ylc=X3oDMTJmMHN0NGxuBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2xpbmtzBHN0aW1lAzExOTU3MzM5NTc->|
> Polls<http://groups.yahoo.com/group/belajar-access/polls;_ylc=X3oDMTJmcXZjcWVsBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA3BvbGxzBHN0aW1lAzExOTU3MzM5NTc->
> SPAM IS PROHIBITED
> [image: Yahoo!
> Groups]<http://groups.yahoo.com/;_ylc=X3oDMTJkdmkwNjEzBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMTk1NzMzOTU3>
> Change settings via the
> Web<http://groups.yahoo.com/group/belajar-access/join;_ylc=X3oDMTJmaWo2MnJmBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzExOTU3MzM5NTc->(Yahoo!
> ID required)
> Change settings via email: Switch delivery to Individual<[EMAIL
> PROTECTED]:+Indiviual+Email>| Switch
> format to Traditional<[EMAIL PROTECTED]:+Traditional>
> Visit Your Group
> <http://groups.yahoo.com/group/belajar-access;_ylc=X3oDMTJkMmRsNTljBF9TAzk3MzU5NzE1BGdycElkAzMzMzE2NTgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMTk1NzMzOTU3>|
> Yahoo!
> Groups Terms of Use <http://docs.yahoo.com/info/terms/> | Unsubscribe
> <[EMAIL PROTECTED]>
>
