/* */

Tuesday, May 26, 2015

Fwd: Re: [belajar-access] Tanya mennggunakan rumus yang sdh kita siapkan dikolom tertentu? [1 Attachment]

---------- Forwarded message ----------
From: "hari yanto har_i20002000@yahoo.com [belajar-access]" <belajar-access@yahoogroups.com>
Date: May 17, 2015 8:47 PM
Subject: Re: [belajar-access] Tanya mennggunakan rumus yang sdh kita siapkan dikolom tertentu? [1 Attachment]
To: <belajar-access@yahoogroups.com>
Cc:

 
[Attachment(s) from hari yanto har_i20002000@yahoo.com [belajar-access] included below]

Nurhasim Hasan ....,

Kita bisa memanfaatkan fungsi eval yang sudah build in di Ms Access. Hanya saja, sebelum eval dieksekusi harus ada penanda untuk eksekusi yang dilakukan oleh user. Misal tanda =, lalu eksekusi.

Contohnya kongkretnya sebagaimana terlampir...

Semoga bisa membantu dan memberi manfaat.

Hariyanto (Surabaya)

--------------------------------------------
On Sat, 16/5/15, 'Nurhasim Hasan' hasimnurhsm@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> wrote:

Subject: [belajar-access] Tanya mennggunakan rumus yang sdh kita siapkan dikolom tertentu?
To: belajar-access@yahoogroups.com
Date: Saturday, 16 May, 2015, 2:48 PM


 









Dear Access
Lovers  Bagaimana caranya
menggunakan rumus yang kita siapkan contoh seperti dibawah
ini:  Misal kolom A berisi
rumus: baris ke satu
      200/(10*2)baris ke
dua        200+(10*2)  bagaimana caranya
supaya di kolom B secara otomatis menampilkan hasil dari
rumus yang tersimpan dikolom A:  misal hasil di kolom
B sbb:  baris ke satu
      10baris ke
dua        220  Tujuannya untuk
membuat rumus yang dinamis yang bisa diedit melalui form
tanpa harus masuk ke code program atau sql
query  Atas bantuannya saya
ucapkan terimakasih  Salam    Nurhasim                  
 









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

#yiv7575397036 #yiv7575397036ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv7575397036 #yiv7575397036ygrp-mkp #yiv7575397036hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv7575397036 #yiv7575397036ygrp-mkp #yiv7575397036ads {
margin-bottom:10px;}

#yiv7575397036 #yiv7575397036ygrp-mkp .yiv7575397036ad {
padding:0 0;}

#yiv7575397036 #yiv7575397036ygrp-mkp .yiv7575397036ad p {
margin:0;}

#yiv7575397036 #yiv7575397036ygrp-mkp .yiv7575397036ad a {
color:#0000ff;text-decoration:none;}
#yiv7575397036 #yiv7575397036ygrp-sponsor
#yiv7575397036ygrp-lc {
font-family:Arial;}

#yiv7575397036 #yiv7575397036ygrp-sponsor
#yiv7575397036ygrp-lc #yiv7575397036hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv7575397036 #yiv7575397036ygrp-sponsor
#yiv7575397036ygrp-lc .yiv7575397036ad {
margin-bottom:10px;padding:0 0;}

#yiv7575397036 #yiv7575397036actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv7575397036 #yiv7575397036activity span {
font-weight:700;}

#yiv7575397036 #yiv7575397036activity span:first-child {
text-transform:uppercase;}

#yiv7575397036 #yiv7575397036activity span a {
color:#5085b6;text-decoration:none;}

#yiv7575397036 #yiv7575397036activity span span {
color:#ff7900;}

#yiv7575397036 #yiv7575397036activity span
.yiv7575397036underline {
text-decoration:underline;}

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

#yiv7575397036 .yiv7575397036attach div a {
text-decoration:none;}

#yiv7575397036 .yiv7575397036attach img {
border:none;padding-right:5px;}

#yiv7575397036 .yiv7575397036attach label {
display:block;margin-bottom:5px;}

#yiv7575397036 .yiv7575397036attach label a {
text-decoration:none;}

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

#yiv7575397036 .yiv7575397036bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv7575397036 .yiv7575397036bold a {
text-decoration:none;}

#yiv7575397036 dd.yiv7575397036last p a {
font-family:Verdana;font-weight:700;}

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

#yiv7575397036 dd.yiv7575397036last p
span.yiv7575397036yshortcuts {
margin-right:0;}

#yiv7575397036 div.yiv7575397036attach-table div div a {
text-decoration:none;}

#yiv7575397036 div.yiv7575397036attach-table {
width:400px;}

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

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

#yiv7575397036 div#yiv7575397036ygrp-mlmsg
#yiv7575397036ygrp-msg p a span.yiv7575397036yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv7575397036 .yiv7575397036green {
color:#628c2a;}

#yiv7575397036 .yiv7575397036MsoNormal {
margin:0 0 0 0;}

#yiv7575397036 o {
font-size:0;}

#yiv7575397036 #yiv7575397036photos div {
float:left;width:72px;}

#yiv7575397036 #yiv7575397036photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

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

#yiv7575397036 #yiv7575397036reco-category {
font-size:77%;}

#yiv7575397036 #yiv7575397036reco-desc {
font-size:77%;}

#yiv7575397036 .yiv7575397036replbq {
margin:4px;}

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

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


#yiv7575397036 #yiv7575397036ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv7575397036 #yiv7575397036ygrp-mlmsg pre, #yiv7575397036
code {
font:115% monospace;}

#yiv7575397036 #yiv7575397036ygrp-mlmsg * {
line-height:1.22em;}

#yiv7575397036 #yiv7575397036ygrp-mlmsg #yiv7575397036logo {
padding-bottom:10px;}


#yiv7575397036 #yiv7575397036ygrp-msg p a {
font-family:Verdana;}

#yiv7575397036 #yiv7575397036ygrp-msg
p#yiv7575397036attach-count span {
color:#1E66AE;font-weight:700;}

#yiv7575397036 #yiv7575397036ygrp-reco
#yiv7575397036reco-head {
color:#ff7900;font-weight:700;}

#yiv7575397036 #yiv7575397036ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv7575397036 #yiv7575397036ygrp-sponsor #yiv7575397036ov
li a {
font-size:130%;text-decoration:none;}

#yiv7575397036 #yiv7575397036ygrp-sponsor #yiv7575397036ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv7575397036 #yiv7575397036ygrp-sponsor #yiv7575397036ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv7575397036 #yiv7575397036ygrp-text {
font-family:Georgia;}

#yiv7575397036 #yiv7575397036ygrp-text p {
margin:0 0 1em 0;}

#yiv7575397036 #yiv7575397036ygrp-text tt {
font-size:120%;}

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

__._,_.___

Attachment(s) from hari yanto har_i20002000@yahoo.com [belajar-access] | View attachments on the web

1 of 1 File(s)


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 (4)
SPAM IS PROHIBITED

.

__,_._,___

No comments:

Post a Comment