Re: [belajar-access] Re: bagaimana code vba mengexport dengan format nama ke excel

 

Hello cak Har, apa khabar?

Good trick, walau mungkin agak sulit diikuti oleh yang belum biasa.

Cuman lumayan lama juga kalau banyak yang harus diexport, dan data sizenya besar, karena diload ke memory.

Anyway, progress bar nya cakep :)

Khas programmer.

Thanks,

HAER

Haer Talib

RumahAccess Indonesia

Tempatnya Belajar Microsoft Access

Artikel | Forum | Milis | Download | Training | Links | Blog | Event

On Thu, Jul 28, 2016 at 10:00 AM, hari yanto har_i20002000@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> wrote:

 

Menambahkan....

Monggo klik tentang ekspor import excel-Ms Access ini Yahoo! Groups

				Yahoo! Groups On Fri, 20/5/16, dedy heru susanto d3dy_h3rus@... [belajar-access] <belajar-access@yahoogroups.com> wrote: Subject: [belajar-access] Ekspor import access - excel ...
				View on groups.yahoo.com	Preview by Yahoo

Kembangkan pula ke pembuatan tabel temporer di Ms Access untuk kebutuhan yang lebih spesifik

Semoga bisa membantu dan memberi semangat.

Hariyanto (Surabaya)

--------------------------------------------
On Wed, 27/7/16, 'Roland' rolandtambunan@gmail.com [belajar-access] <belajar-access@yahoogroups.com> wrote:

Subject: Re: [belajar-access] Re: bagaimana code vba mengexport dengan format nama ke excel
To: belajar-access@yahoogroups.com
Date: Wednesday, 27 July, 2016, 11:29 PM


 



 


   
     
     
     











 


Untuk format angka selalu 7 digit bisa
menggunakan vba

Format(1234, "0000000")
Hasilnya ->  0001234

Untuk mengembalikan datanya ke value
Val("0001234")


~Roland
Powered by Telkomsel
BlackBerry®From:  "leo

adityos2003@yahoo.com [belajar-access]"
<belajar-access@yahoogroups.com>
Sender:  belajar-access@yahoogroups.com
Date: Wed, 27 Jul 2016 11:00:21 +0000
(UTC)To:
<belajar-access@yahoogroups.com>ReplyTo:
  belajar-access@yahoogroups.com
Subject:
[belajar-access] Re: bagaimana code vba mengexport
dengan format nama ke excel

 



   
     
     
      hallo
master
mau
  tanya nih bagaimana caranya vba coding vba dengan format
nama di dalam
data table/query dari vba, ? atau keyword di google,

contoh
nama dr data : a) faktur_paijo_apotekjakarta_0100050,
                               
b) faktur_sukiyem_apotekberkat_0200500, dll

terimakasih
gann


 
 best
regards,

Leonardus Adityo
T.P

http://pujanggamu.wordpress.com

"alon-alon asal
kelakon"



  On Wednesday, 27 July 2016, 17:17,
leo <adityos2003@yahoo.com> wrote:
 

  hallo
master
mau
tanya nih bagaimana caranya vba coding vba dengan format
nama di dalam table/query dari vba, ? atau keyword di
google,  trims
 best
regards,

Leonardus Adityo
T.P

http://pujanggamu.wordpress.com

"alon-alon asal
kelakon"

     

   
     

   










   
     

   
   

#yiv2981647309 #yiv2981647309 --
  #yiv2981647309ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv2981647309 #yiv2981647309ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv2981647309 #yiv2981647309ygrp-mkp #yiv2981647309hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv2981647309 #yiv2981647309ygrp-mkp #yiv2981647309ads {
margin-bottom:10px;}

#yiv2981647309 #yiv2981647309ygrp-mkp .yiv2981647309ad {
padding:0 0;}

#yiv2981647309 #yiv2981647309ygrp-mkp .yiv2981647309ad p {
margin:0;}

#yiv2981647309 #yiv2981647309ygrp-mkp .yiv2981647309ad a {
color:#0000ff;text-decoration:none;}
#yiv2981647309 #yiv2981647309ygrp-sponsor
#yiv2981647309ygrp-lc {
font-family:Arial;}

#yiv2981647309 #yiv2981647309ygrp-sponsor
#yiv2981647309ygrp-lc #yiv2981647309hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv2981647309 #yiv2981647309ygrp-sponsor
#yiv2981647309ygrp-lc .yiv2981647309ad {
margin-bottom:10px;padding:0 0;}

#yiv2981647309 #yiv2981647309actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv2981647309 #yiv2981647309activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv2981647309 #yiv2981647309activity span {
font-weight:700;}

#yiv2981647309 #yiv2981647309activity span:first-child {
text-transform:uppercase;}

#yiv2981647309 #yiv2981647309activity span a {
color:#5085b6;text-decoration:none;}

#yiv2981647309 #yiv2981647309activity span span {
color:#ff7900;}

#yiv2981647309 #yiv2981647309activity span
.yiv2981647309underline {
text-decoration:underline;}

#yiv2981647309 .yiv2981647309attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv2981647309 .yiv2981647309attach div a {
text-decoration:none;}

#yiv2981647309 .yiv2981647309attach img {
border:none;padding-right:5px;}

#yiv2981647309 .yiv2981647309attach label {
display:block;margin-bottom:5px;}

#yiv2981647309 .yiv2981647309attach label a {
text-decoration:none;}

#yiv2981647309 blockquote {
margin:0 0 0 4px;}

#yiv2981647309 .yiv2981647309bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv2981647309 .yiv2981647309bold a {
text-decoration:none;}

#yiv2981647309 dd.yiv2981647309last p a {
font-family:Verdana;font-weight:700;}

#yiv2981647309 dd.yiv2981647309last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv2981647309 dd.yiv2981647309last p
span.yiv2981647309yshortcuts {
margin-right:0;}

#yiv2981647309 div.yiv2981647309attach-table div div a {
text-decoration:none;}

#yiv2981647309 div.yiv2981647309attach-table {
width:400px;}

#yiv2981647309 div.yiv2981647309file-title a, #yiv2981647309
div.yiv2981647309file-title a:active, #yiv2981647309
div.yiv2981647309file-title a:hover, #yiv2981647309
div.yiv2981647309file-title a:visited {
text-decoration:none;}

#yiv2981647309 div.yiv2981647309photo-title a,
#yiv2981647309 div.yiv2981647309photo-title a:active,
#yiv2981647309 div.yiv2981647309photo-title a:hover,
#yiv2981647309 div.yiv2981647309photo-title a:visited {
text-decoration:none;}

#yiv2981647309 div#yiv2981647309ygrp-mlmsg
#yiv2981647309ygrp-msg p a span.yiv2981647309yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv2981647309 .yiv2981647309green {
color:#628c2a;}

#yiv2981647309 .yiv2981647309MsoNormal {
margin:0 0 0 0;}

#yiv2981647309 o {
font-size:0;}

#yiv2981647309 #yiv2981647309photos div {
float:left;width:72px;}

#yiv2981647309 #yiv2981647309photos div div {
border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}

#yiv2981647309 #yiv2981647309photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv2981647309 #yiv2981647309reco-category {
font-size:77%;}

#yiv2981647309 #yiv2981647309reco-desc {
font-size:77%;}

#yiv2981647309 .yiv2981647309replbq {
margin:4px;}

#yiv2981647309 #yiv2981647309ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv2981647309 #yiv2981647309ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv2981647309 #yiv2981647309ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv2981647309 #yiv2981647309ygrp-mlmsg select,
#yiv2981647309 input, #yiv2981647309 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv2981647309 #yiv2981647309ygrp-mlmsg pre, #yiv2981647309
code {
font:115% monospace;}

#yiv2981647309 #yiv2981647309ygrp-mlmsg * {
line-height:1.22em;}

#yiv2981647309 #yiv2981647309ygrp-mlmsg #yiv2981647309logo {
padding-bottom:10px;}


#yiv2981647309 #yiv2981647309ygrp-msg p a {
font-family:Verdana;}

#yiv2981647309 #yiv2981647309ygrp-msg
p#yiv2981647309attach-count span {
color:#1E66AE;font-weight:700;}

#yiv2981647309 #yiv2981647309ygrp-reco
#yiv2981647309reco-head {
color:#ff7900;font-weight:700;}

#yiv2981647309 #yiv2981647309ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv2981647309 #yiv2981647309ygrp-sponsor #yiv2981647309ov
li a {
font-size:130%;text-decoration:none;}

#yiv2981647309 #yiv2981647309ygrp-sponsor #yiv2981647309ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv2981647309 #yiv2981647309ygrp-sponsor #yiv2981647309ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv2981647309 #yiv2981647309ygrp-text {
font-family:Georgia;}

#yiv2981647309 #yiv2981647309ygrp-text p {
margin:0 0 1em 0;}

#yiv2981647309 #yiv2981647309ygrp-text tt {
font-size:120%;}

#yiv2981647309 #yiv2981647309ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv2981647309

__._,_.___

---

Posted by: Haer Talib <haertalib@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

Save time and get your email on the go with the Yahoo Mail app

Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. 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.

---

SPAM IS PROHIBITED

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___