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:
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)
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
No comments:
Post a Comment