ACCESS FEED: Bls: [belajar-access] Filter Combo Box [1 Attachment]

Jumat, 22 April 2016

Bls: [belajar-access] Filter Combo Box [1 Attachment]

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

salam kenal.
gak tau permasalahan ini apakah sudah teratasi atau belum.
saya mencoba untuk ikutan beri solusi.

pada combo nama_spare_part tambahkan sepert dibawah ini.

Private Sub nama_spare_part_AfterUpdate()
Me.type_spare_part.RowSource = "select type_spare_part from type_spare_part where nama_spare_part ='" & Me.nama_spare_part.Column(0) & "'"
End Sub

semoga bisa membantu.
saya lampirkan juga yg sudah saya edit.

--------------------------------------------
Pada Sen, 11/4/16, agungraziqi@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> menulis:

Judul: [belajar-access] Filter Combo Box [1 Attachment]
Kepada: belajar-access@yahoogroups.com
Tanggal: Senin, 11 April, 2016, 4:55 PM

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

Dear para master mohon

pencerahan,saya punya sebuah database,
saya ada masalah untuk form, saya ingin pada saat mengisi
form transaksi pada kolom nama spare part maka pada pada
kolom type sspare part secara automatis memfilter hanya type
yang ada pada nama spare part yang saya masukkan saja yang
keluar sehingga memudahkan dalam pencarian (tidak terlalu
banyak pilihan)demikian masalah saya,
semoga para master bisa memberikan
masuka,

BRs

Agung

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

#yiv4799202451 #yiv4799202451ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv4799202451 #yiv4799202451ygrp-mkp #yiv4799202451hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

0;}

#yiv4799202451 #yiv4799202451ygrp-mkp #yiv4799202451ads {
margin-bottom:10px;}

#yiv4799202451 #yiv4799202451ygrp-mkp .yiv4799202451ad {
padding:0 0;}

#yiv4799202451 #yiv4799202451ygrp-mkp .yiv4799202451ad p {

margin:0;}

#yiv4799202451 #yiv4799202451ygrp-mkp .yiv4799202451ad a {
color:#0000ff;text-decoration:none;}
#yiv4799202451 #yiv4799202451ygrp-sponsor
#yiv4799202451ygrp-lc {
font-family:Arial;}

#yiv4799202451 #yiv4799202451ygrp-sponsor
#yiv4799202451ygrp-lc #yiv4799202451hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv4799202451 #yiv4799202451ygrp-sponsor
#yiv4799202451ygrp-lc .yiv4799202451ad {
margin-bottom:10px;padding:0 0;}

#yiv4799202451 #yiv4799202451actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv4799202451 #yiv4799202451activity span {
font-weight:700;}

#yiv4799202451 #yiv4799202451activity span:first-child {
text-transform:uppercase;}

#yiv4799202451 #yiv4799202451activity span a {
color:#5085b6;text-decoration:none;}

#yiv4799202451 #yiv4799202451activity span span {
color:#ff7900;}

#yiv4799202451 #yiv4799202451activity span
.yiv4799202451underline {
text-decoration:underline;}

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

#yiv4799202451 .yiv4799202451attach div a {
text-decoration:none;}

#yiv4799202451 .yiv4799202451attach img {
border:none;padding-right:5px;}

#yiv4799202451 .yiv4799202451attach label {
display:block;margin-bottom:5px;}

#yiv4799202451 .yiv4799202451attach label a {
text-decoration:none;}

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

#yiv4799202451 .yiv4799202451bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv4799202451 .yiv4799202451bold a {
text-decoration:none;}

#yiv4799202451 dd.yiv4799202451last p a {
font-family:Verdana;font-weight:700;}

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

#yiv4799202451 dd.yiv4799202451last p
span.yiv4799202451yshortcuts {
margin-right:0;}

#yiv4799202451 div.yiv4799202451attach-table div div a {
text-decoration:none;}

#yiv4799202451 div.yiv4799202451attach-table {
width:400px;}

#yiv4799202451 div.yiv4799202451file-title a, #yiv4799202451

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

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

#yiv4799202451 div#yiv4799202451ygrp-mlmsg
#yiv4799202451ygrp-msg p a span.yiv4799202451yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv4799202451 .yiv4799202451green {
color:#628c2a;}

#yiv4799202451 .yiv4799202451MsoNormal {

margin:0 0 0 0;}

#yiv4799202451 o {
font-size:0;}

#yiv4799202451 #yiv4799202451photos div {
float:left;width:72px;}

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

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

#yiv4799202451 #yiv4799202451reco-category {
font-size:77%;}

#yiv4799202451 #yiv4799202451reco-desc {
font-size:77%;}

#yiv4799202451 .yiv4799202451replbq {
margin:4px;}

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

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

#yiv4799202451 #yiv4799202451ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv4799202451 #yiv4799202451ygrp-mlmsg pre, #yiv4799202451
code {
font:115% monospace;}

#yiv4799202451 #yiv4799202451ygrp-mlmsg * {
line-height:1.22em;}

#yiv4799202451 #yiv4799202451ygrp-mlmsg #yiv4799202451logo {
padding-bottom:10px;}

#yiv4799202451 #yiv4799202451ygrp-msg p a {
font-family:Verdana;}

#yiv4799202451 #yiv4799202451ygrp-msg
p#yiv4799202451attach-count span {
color:#1E66AE;font-weight:700;}

#yiv4799202451 #yiv4799202451ygrp-reco
#yiv4799202451reco-head {
color:#ff7900;font-weight:700;}

#yiv4799202451 #yiv4799202451ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv4799202451 #yiv4799202451ygrp-sponsor #yiv4799202451ov
li a {
font-size:130%;text-decoration:none;}

#yiv4799202451 #yiv4799202451ygrp-sponsor #yiv4799202451ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv4799202451 #yiv4799202451ygrp-sponsor #yiv4799202451ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv4799202451 #yiv4799202451ygrp-text {
font-family:Georgia;}

#yiv4799202451 #yiv4799202451ygrp-text p {
margin:0 0 1em 0;}

#yiv4799202451 #yiv4799202451ygrp-text tt {
font-size:120%;}

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