Bila untuk entry atau edit data, source data sebaiknya tidak dari query. Kalaupun terpaksa dari query, dalam kasus Sampeyan, hilangkan proses grouping record.
Caranya, di query klik view --> terlihat tanda totals diberi centang. Klik, total tersebut sehingga tidak dilakukan grouping atas record.
Semoga bisa membantu dan memberi semangat.
Hariyanto (Surabaya)
--------------------------------------------
On Tue, 9/9/14, dedy heru susanto d3dy_h3rus@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> wrote:
Subject: Re: [belajar-access] Mohon Bantuan fungsi DSUM
To: belajar-access@yahoogroups.com
Date: Tuesday, 9 September, 2014, 11:26 AM
Maaf pak mau tanya
lagiKenapa
form Fakturnya tidak bisa di input dan
edit?Mohon
bantuannya Terima
kasih
On Monday, August 25, 2014 5:21 AM, "hari
yanto har_i20002000@yahoo.com [belajar-access]"
<belajar-access@yahoogroups.com> wrote:
[Attachment(s)
from hari yanto har_i20002000@yahoo.com [belajar-access]
included below]
dedy heru susanto...,
Terlampir adalah perbaikan yang telah saya lakukan. Saya
buat module baru untuk mendefinisikan nilai saldo.
Function saldo_p(ByVal RecordID As Variant, nmtabel As
Variant _
, fi_db As Variant, n_id As Variant, jn As Variant, id_toko
As Variant _
, n_id_toko As Variant) As Double
Dim hs As Double
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("Select sum("
& fi_db & ") From " _
& nmtabel & " where " & n_id &
"<=" & RecordID & " and "
_
& jn & "=1" & " and "
& id_toko & "=" & n_id_toko)
If Not rs.EOF Then
hs = Nz(rs.Fields(0), 0)
Else
hs = 0
End If
rs.Close
Set rs = Nothing
Set rs = CurrentDb.OpenRecordset("Select sum("
& fi_db & ") From " _
& nmtabel & " where " & n_id &
"<=" & RecordID & " and "
_
& jn & "<>1" & " and
" & id_toko & "=" & n_id_toko)
If Not rs.EOF Then
hs = hs - Nz(rs.Fields(0), 0)
Else
hs = hs - 0
End If
rs.Close
Set rs = Nothing
saldo_p = hs
End Function
Query yang ada saya edit di a. Report source saya ubah juga
menjadi query a.
Semoga sesuai harapan.
Hariyanto (Surabaya)
--------------------------------------------
On Mon, 25/8/14, dedy heru susanto d3dy_h3rus@yahoo.com
[belajar-access] <belajar-access@yahoogroups.com>
wrote:
Subject: Re: [belajar-access] Mohon Bantuan fungsi DSUM [1
Attachment]
To: belajar-access@yahoogroups.com
Date: Monday, 25 August, 2014, 1:27 PM
[Attachment(s) from dedy heru susanto
d3dy_h3rus@yahoo.com [belajar-access] included below]
1. waktu cetak report saldo
per item produk nilainya kok tidak sesuai
keinginan2. saldo akhirnya sudah ketemu
pakbagaimana caranya di report rekapan transaksi
tiap-tiap toko field saldo per item nilainya
benarsaya lampirkan print screen
masalahnya.terima kasih bantuannya
On Sunday, August
24, 2014 10:54 PM, "hari yanto
har_i20002000@yahoo.com
[belajar-access]"
<belajar-access@yahoogroups.com> wrote:
dedy heru susanto...,
Bisa diuraikan lebih lanjut soal:
Apakah benar yang dimaksud
1. Saldo per item produk per hari transaksi (per baris
per
item produk)
2. Saldo akhir per item produk(jml seluruh hari per item
produk)
3. Apakah rumus saldo: nilai bayar-nilai return-nilai
biaya?
Hariyanto (Surabaya)
--------------------------------------------
On Mon, 25/8/14, dedy heru susanto d3dy_h3rus@yahoo.com
[belajar-access] <belajar-access@yahoogroups.com>
wrote:
Subject: [belajar-access] Mohon Bantuan fungsi DSUM [1
Attachment]
To: belajar-access@yahoogroups.com
Date: Monday, 25 August, 2014, 7:52 AM
[Attachment(s) from dedy heru susanto
d3dy_h3rus@yahoo.com [belajar-access] included below]
Dear Allsaya
punya masalah tentang penggunaan fungsi DSUM untuk
menghitung sisa saldo pada query &
reportnyaTerlampir aplikasi Atas
bantuannya saya ucapkan terima kasih
#yiv2938439816 #yiv2938439816 --
#yiv2938439816ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv2938439816 #yiv2938439816ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv2938439816 #yiv2938439816ygrp-mkp #yiv2938439816hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv2938439816 #yiv2938439816ygrp-mkp #yiv2938439816ads {
margin-bottom:10px;}
#yiv2938439816 #yiv2938439816ygrp-mkp .yiv2938439816ad {
padding:0 0;}
#yiv2938439816 #yiv2938439816ygrp-mkp .yiv2938439816ad p {
margin:0;}
#yiv2938439816 #yiv2938439816ygrp-mkp .yiv2938439816ad a {
color:#0000ff;text-decoration:none;}
#yiv2938439816 #yiv2938439816ygrp-sponsor
#yiv2938439816ygrp-lc {
font-family:Arial;}
#yiv2938439816 #yiv2938439816ygrp-sponsor
#yiv2938439816ygrp-lc #yiv2938439816hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv2938439816 #yiv2938439816ygrp-sponsor
#yiv2938439816ygrp-lc .yiv2938439816ad {
margin-bottom:10px;padding:0 0;}
#yiv2938439816 #yiv2938439816actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv2938439816 #yiv2938439816activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv2938439816 #yiv2938439816activity span {
font-weight:700;}
#yiv2938439816 #yiv2938439816activity span:first-child {
text-transform:uppercase;}
#yiv2938439816 #yiv2938439816activity span a {
color:#5085b6;text-decoration:none;}
#yiv2938439816 #yiv2938439816activity span span {
color:#ff7900;}
#yiv2938439816 #yiv2938439816activity span
.yiv2938439816underline {
text-decoration:underline;}
#yiv2938439816 .yiv2938439816attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv2938439816 .yiv2938439816attach div a {
text-decoration:none;}
#yiv2938439816 .yiv2938439816attach img {
border:none;padding-right:5px;}
#yiv2938439816 .yiv2938439816attach label {
display:block;margin-bottom:5px;}
#yiv2938439816 .yiv2938439816attach label a {
text-decoration:none;}
#yiv2938439816 blockquote {
margin:0 0 0 4px;}
#yiv2938439816 .yiv2938439816bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv2938439816 .yiv2938439816bold a {
text-decoration:none;}
#yiv2938439816 dd.yiv2938439816last p a {
font-family:Verdana;font-weight:700;}
#yiv2938439816 dd.yiv2938439816last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv2938439816 dd.yiv2938439816last p
span.yiv2938439816yshortcuts {
margin-right:0;}
#yiv2938439816 div.yiv2938439816attach-table div div a {
text-decoration:none;}
#yiv2938439816 div.yiv2938439816attach-table {
width:400px;}
#yiv2938439816 div.yiv2938439816file-title a, #yiv2938439816
div.yiv2938439816file-title a:active, #yiv2938439816
div.yiv2938439816file-title a:hover, #yiv2938439816
div.yiv2938439816file-title a:visited {
text-decoration:none;}
#yiv2938439816 div.yiv2938439816photo-title a,
#yiv2938439816 div.yiv2938439816photo-title a:active,
#yiv2938439816 div.yiv2938439816photo-title a:hover,
#yiv2938439816 div.yiv2938439816photo-title a:visited {
text-decoration:none;}
#yiv2938439816 div#yiv2938439816ygrp-mlmsg
#yiv2938439816ygrp-msg p a span.yiv2938439816yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv2938439816 .yiv2938439816green {
color:#628c2a;}
#yiv2938439816 .yiv2938439816MsoNormal {
margin:0 0 0 0;}
#yiv2938439816 o {
font-size:0;}
#yiv2938439816 #yiv2938439816photos div {
float:left;width:72px;}
#yiv2938439816 #yiv2938439816photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv2938439816 #yiv2938439816photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv2938439816 #yiv2938439816reco-category {
font-size:77%;}
#yiv2938439816 #yiv2938439816reco-desc {
font-size:77%;}
#yiv2938439816 .yiv2938439816replbq {
margin:4px;}
#yiv2938439816 #yiv2938439816ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv2938439816 #yiv2938439816ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv2938439816 #yiv2938439816ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv2938439816 #yiv2938439816ygrp-mlmsg select,
#yiv2938439816 input, #yiv2938439816 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv2938439816 #yiv2938439816ygrp-mlmsg pre, #yiv2938439816
code {
font:115% monospace;}
#yiv2938439816 #yiv2938439816ygrp-mlmsg * {
line-height:1.22em;}
#yiv2938439816 #yiv2938439816ygrp-mlmsg #yiv2938439816logo {
padding-bottom:10px;}
#yiv2938439816 #yiv2938439816ygrp-msg p a {
font-family:Verdana;}
#yiv2938439816 #yiv2938439816ygrp-msg
p#yiv2938439816attach-count span {
color:#1E66AE;font-weight:700;}
#yiv2938439816 #yiv2938439816ygrp-reco
#yiv2938439816reco-head {
color:#ff7900;font-weight:700;}
#yiv2938439816 #yiv2938439816ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv2938439816 #yiv2938439816ygrp-sponsor #yiv2938439816ov
li a {
font-size:130%;text-decoration:none;}
#yiv2938439816 #yiv2938439816ygrp-sponsor #yiv2938439816ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv2938439816 #yiv2938439816ygrp-sponsor #yiv2938439816ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv2938439816 #yiv2938439816ygrp-text {
font-family:Georgia;}
#yiv2938439816 #yiv2938439816ygrp-text p {
margin:0 0 1em 0;}
#yiv2938439816 #yiv2938439816ygrp-text tt {
font-size:120%;}
#yiv2938439816 #yiv2938439816ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv2938439816
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 (6) |
Tidak ada komentar:
Posting Komentar