ACCESS FEED: Re: [belajar-access] Solusi mengenai pesan pemberitahuan stok

Mungkin harus diuraikan pada saat kapan user diberikan peringatan/pemberitahuan. Dari contoh yang dikirim, event dikaitkan setelah total2 di update oleh user. Padahal user tidak pernah mengupdate Total2. Karena total2 merupakan hasil jumlah dari field jumlah pada tab1d.

Misalkan, pemberitahuan muncul setelah user mengisi field qty, scriptnya harus diubah begini:

Private Sub qty_AfterUpdate()
Dim rs As Recordset
Dim ni As Double

ni = 0
Set rs = CurrentDb.OpenRecordset("select sum(jumlah) from tabl1d")
If Not rs.EOF Then
ni = rs.Fields(0)
End If

rs.Close
Set rs = Nothing

If ni > Me.qty Then
Me.keterangn = "Order stok berlebihan"
Else
Me.keterangn = "Order stok belum mencukupi"
End If

End Sub

Semoga bisa membantu dan memberi semangat.

Hariyanto (Surabaya)

--------------------------------------------
On Thu, 4/8/16, kotak_surat_mreal@yahoo.co.id [belajar-access] <belajar-access@yahoogroups.com> wrote:

Subject: [belajar-access] Solusi mengenai pesan pemberitahuan stok [1 Attachment]
To: belajar-access@yahoogroups.com
Date: Thursday, 4 August, 2016, 10:15 AM

[Attachment(s) from
kotak_surat_mreal@yahoo.co.id [belajar-access] included
below]

Dear All,
Assalamu'alaikum wr.
wb

Mas mau tanya solusi
lain soal pesan pemberitahuan jika stok over atau minus.
Langkah yang saya telah buat adalah,

ketika stok yang di input
melebihi stok dalam kontrak, maka textbox otomatis akan
memberi peringatan. misal
order berlebihan.
nah disini permasalahannya, ketika stok berlebih atau
kurang, textbox itu tidak berisi oleh peringatan yang
dibuat.
mohon petunjuk master
terimakasih

file terlampir.

Attachment(s)
from kotak_surat_mreal@yahoo.co.id [belajar-access] |
View
attachments on the web

1 of 1 File(s)

Database5.accdb

Posted by: kotak_surat_mreal@yahoo.co.id

Reply
via web post
•

Reply to sender
•

Reply to group
•
Start a New
Topic
•
Messages in this
topic
(1)

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

• Privacy • Unsubscribe • Terms of Use

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

#yiv9224183115 #yiv9224183115ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9224183115 #yiv9224183115ygrp-mkp #yiv9224183115hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9224183115 #yiv9224183115ygrp-mkp #yiv9224183115ads {
margin-bottom:10px;}

#yiv9224183115 #yiv9224183115ygrp-mkp .yiv9224183115ad {
padding:0 0;}

#yiv9224183115 #yiv9224183115ygrp-mkp .yiv9224183115ad p {
margin:0;}

#yiv9224183115 #yiv9224183115ygrp-mkp .yiv9224183115ad a {
color:#0000ff;text-decoration:none;}
#yiv9224183115 #yiv9224183115ygrp-sponsor
#yiv9224183115ygrp-lc {
font-family:Arial;}

#yiv9224183115 #yiv9224183115ygrp-sponsor
#yiv9224183115ygrp-lc #yiv9224183115hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9224183115 #yiv9224183115ygrp-sponsor
#yiv9224183115ygrp-lc .yiv9224183115ad {
margin-bottom:10px;padding:0 0;}

#yiv9224183115 #yiv9224183115actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv9224183115 #yiv9224183115activity span {
font-weight:700;}

#yiv9224183115 #yiv9224183115activity span:first-child {
text-transform:uppercase;}

#yiv9224183115 #yiv9224183115activity span a {
color:#5085b6;text-decoration:none;}

#yiv9224183115 #yiv9224183115activity span span {
color:#ff7900;}

#yiv9224183115 #yiv9224183115activity span
.yiv9224183115underline {
text-decoration:underline;}

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

#yiv9224183115 .yiv9224183115attach div a {
text-decoration:none;}

#yiv9224183115 .yiv9224183115attach img {
border:none;padding-right:5px;}

#yiv9224183115 .yiv9224183115attach label {
display:block;margin-bottom:5px;}

#yiv9224183115 .yiv9224183115attach label a {
text-decoration:none;}

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

#yiv9224183115 .yiv9224183115bold {

font-family:Arial;font-size:13px;font-weight:700;}

#yiv9224183115 .yiv9224183115bold a {
text-decoration:none;}

#yiv9224183115 dd.yiv9224183115last p a {
font-family:Verdana;font-weight:700;}

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

#yiv9224183115 dd.yiv9224183115last p
span.yiv9224183115yshortcuts {
margin-right:0;}

#yiv9224183115 div.yiv9224183115attach-table div div a {
text-decoration:none;}

#yiv9224183115 div.yiv9224183115attach-table {
width:400px;}

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

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

#yiv9224183115 div#yiv9224183115ygrp-mlmsg
#yiv9224183115ygrp-msg p a span.yiv9224183115yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9224183115 .yiv9224183115green {
color:#628c2a;}

#yiv9224183115 .yiv9224183115MsoNormal {
margin:0 0 0 0;}

#yiv9224183115 o {
font-size:0;}

#yiv9224183115 #yiv9224183115photos div {
float:left;width:72px;}

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

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

#yiv9224183115 #yiv9224183115reco-category {
font-size:77%;}

#yiv9224183115 #yiv9224183115reco-desc {
font-size:77%;}

#yiv9224183115 .yiv9224183115replbq {
margin:4px;}

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

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

#yiv9224183115 #yiv9224183115ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv9224183115 #yiv9224183115ygrp-mlmsg pre, #yiv9224183115
code {
font:115% monospace;}

#yiv9224183115 #yiv9224183115ygrp-mlmsg * {
line-height:1.22em;}

#yiv9224183115 #yiv9224183115ygrp-mlmsg #yiv9224183115logo {
padding-bottom:10px;}

#yiv9224183115 #yiv9224183115ygrp-msg p a {
font-family:Verdana;}

#yiv9224183115 #yiv9224183115ygrp-msg
p#yiv9224183115attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9224183115 #yiv9224183115ygrp-reco
#yiv9224183115reco-head {
color:#ff7900;font-weight:700;}

#yiv9224183115 #yiv9224183115ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9224183115 #yiv9224183115ygrp-sponsor #yiv9224183115ov
li a {
font-size:130%;text-decoration:none;}

#yiv9224183115 #yiv9224183115ygrp-sponsor #yiv9224183115ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9224183115 #yiv9224183115ygrp-sponsor #yiv9224183115ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9224183115 #yiv9224183115ygrp-text {
font-family:Georgia;}

#yiv9224183115 #yiv9224183115ygrp-text p {
margin:0 0 1em 0;}

#yiv9224183115 #yiv9224183115ygrp-text tt {
font-size:120%;}

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