ACCESS FEED: Re: Bls: [belajar-access] Mencari Barang

Jumat, 22 Juli 2016

Re: Bls: [belajar-access] Mencari Barang

Salam Access,
Maaf mas Galih saya lihat emailnya via BB jadul dan tidak bisa buka attachmentnya.

Untuk mencari data pada form yang terbuka bisa menggunakan metode recordset findfirst referensinya :

https://msdn.microsoft.com/en-us/library/office/ff194787.aspx.

Atau

https://accessexperts.com/blog/2011/05/23/when-to-use-a-forms-recordset-and-when-to-use-recordsetclone/

Semoga bisa memberikan pencerahan.

~Roland

From: "GALIH PERSADHA galih_persadha@yahoo.co.id [belajar-access]" <belajar-access@yahoogroups.com>

Sender: belajar-access@yahoogroups.com

Date: Fri, 22 Jul 2016 08:39:50 +0000 (UTC)

To: <belajar-access@yahoogroups.com>

ReplyTo: belajar-access@yahoogroups.com

Subject: Bls: [belajar-access] Mencari Barang [1 Attachment]

saya coba menggunakan cara dengan mencari terlebih dahulu barang di q_identitasbarang, jika ada maka membuka formF_identitasbarang tetapi jika tidak ketemu maka msgbox "Data tidak ditemukan"
bisa dilihat di lampiran yng saya kirimkan.
semofga membantu.

salam kenal
--------------------------------------------
Pada Sen, 18/7/16, aq superman aqsuperman@yahoo.co.id [belajar-access] <belajar-access@yahoogroups.com> menulis:

Judul: [belajar-access] Mencari Barang [1 Attachment]
Kepada: belajar-access@yahoogroups.com
Tanggal: Senin, 18 Juli, 2016, 3:44 PM

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

Halo
Master,Saya
sedang mencari barang dengan form search (F_SearchBarang)
dan form sumber data (F_IdentitasBarang) yg berbeda tidak
dalam form yg sama. Saya ada melampirkan
samplenya.
Kesulitan
saya: jika diketik A1010,E1010,Y1010 dll hasilnya benar,
tp jika diketik asal-asalan hasilnya salah muncul form
F_IdentitasBarang, saya tidak ingin form itu muncul tetapi
message box "Tidak Ada Barang Tersebut" , Please
Try Again".
Boleh koq

dgn program yg lain, tp jgn dalam satu form yg sama
maksudnya textbox untuk mencari barang( F_SearchBarang) dgn
sumber data (F_IdentitasBarang) dalam 1 form, saya ingin
pisah.Mohon
bantuannya.

Terima
kasih

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

#yiv3006573438 #yiv3006573438ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3006573438 #yiv3006573438ygrp-mkp #yiv3006573438hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3006573438 #yiv3006573438ygrp-mkp #yiv3006573438ads {
margin-bottom:10px;}

#yiv3006573438 #yiv3006573438ygrp-mkp .yiv3006573438ad {
padding:0 0;}

#yiv3006573438 #yiv3006573438ygrp-mkp .yiv3006573438ad p {
margin:0;}

#yiv3006573438 #yiv3006573438ygrp-mkp .yiv3006573438ad a {
color:#0000ff;text-decoration:none;}
#yiv3006573438 #yiv3006573438ygrp-sponsor
#yiv3006573438ygrp-lc {
font-family:Arial;}

#yiv3006573438 #yiv3006573438ygrp-sponsor
#yiv3006573438ygrp-lc #yiv3006573438hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3006573438 #yiv3006573438ygrp-sponsor
#yiv3006573438ygrp-lc .yiv3006573438ad {
margin-bottom:10px;padding:0 0;}

#yiv3006573438 #yiv3006573438actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv3006573438 #yiv3006573438activity span {
font-weight:700;}

#yiv3006573438 #yiv3006573438activity span:first-child {
text-transform:uppercase;}

#yiv3006573438 #yiv3006573438activity span a {
color:#5085b6;text-decoration:none;}

#yiv3006573438 #yiv3006573438activity span span {
color:#ff7900;}

#yiv3006573438 #yiv3006573438activity span
.yiv3006573438underline {
text-decoration:underline;}

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

#yiv3006573438 .yiv3006573438attach div a {
text-decoration:none;}

#yiv3006573438 .yiv3006573438attach img {
border:none;padding-right:5px;}

#yiv3006573438 .yiv3006573438attach label {
display:block;margin-bottom:5px;}

#yiv3006573438 .yiv3006573438attach label a {
text-decoration:none;}

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

#yiv3006573438 .yiv3006573438bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3006573438 .yiv3006573438bold a {
text-decoration:none;}

#yiv3006573438 dd.yiv3006573438last p a {

font-family:Verdana;font-weight:700;}

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

#yiv3006573438 dd.yiv3006573438last p
span.yiv3006573438yshortcuts {
margin-right:0;}

#yiv3006573438 div.yiv3006573438attach-table div div a {
text-decoration:none;}

#yiv3006573438 div.yiv3006573438attach-table {
width:400px;}

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

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

#yiv3006573438 div#yiv3006573438ygrp-mlmsg
#yiv3006573438ygrp-msg p a span.yiv3006573438yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3006573438 .yiv3006573438green {
color:#628c2a;}

#yiv3006573438 .yiv3006573438MsoNormal {
margin:0 0 0 0;}

#yiv3006573438 o {
font-size:0;}

#yiv3006573438 #yiv3006573438photos div {
float:left;width:72px;}

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

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

#yiv3006573438 #yiv3006573438reco-category {
font-size:77%;}

#yiv3006573438 #yiv3006573438reco-desc {
font-size:77%;}

#yiv3006573438 .yiv3006573438replbq {
margin:4px;}

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

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

#yiv3006573438 #yiv3006573438ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv3006573438 #yiv3006573438ygrp-mlmsg pre, #yiv3006573438
code {
font:115% monospace;}

#yiv3006573438 #yiv3006573438ygrp-mlmsg * {
line-height:1.22em;}

#yiv3006573438 #yiv3006573438ygrp-mlmsg #yiv3006573438logo {
padding-bottom:10px;}

#yiv3006573438 #yiv3006573438ygrp-msg p a {
font-family:Verdana;}

#yiv3006573438 #yiv3006573438ygrp-msg
p#yiv3006573438attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3006573438 #yiv3006573438ygrp-reco
#yiv3006573438reco-head {
color:#ff7900;font-weight:700;}

#yiv3006573438 #yiv3006573438ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3006573438 #yiv3006573438ygrp-sponsor #yiv3006573438ov
li a {
font-size:130%;text-decoration:none;}

#yiv3006573438 #yiv3006573438ygrp-sponsor #yiv3006573438ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3006573438 #yiv3006573438ygrp-sponsor #yiv3006573438ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3006573438 #yiv3006573438ygrp-text {
font-family:Georgia;}

#yiv3006573438 #yiv3006573438ygrp-text p {
margin:0 0 1em 0;}

#yiv3006573438 #yiv3006573438ygrp-text tt {
font-size:120%;}

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