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

 

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: hari yanto <har_i20002000@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

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

.

__,_._,___