Dicoba rowsorce nya diganti secara programatikal, misal: tSQL = "SELECT * FROM nama tabel WHERE nama field='" & text1.text & "'" list.rowsource = tSQL list.requery
Mudah-mudahan bisa membantu Regard, andhit --- In [email protected], Nur Ubaidi <[EMAIL PROTECTED]> wrote: > > Syukron mas ara, saya mau nanya lagi neh, gimana cara filter listbox lewat teks di satu form? syukron b4 > > ----- Original Message ---- > From: ara Firmansyah <[EMAIL PROTECTED]> > To: [email protected] > Sent: Thursday, April 17, 2008 7:56:02 AM > Subject: Re: [belajar-access] membuat report di word .dot (lanjutan) > > Mas coba pake contoh, solusi ini dari Mas Bobby > Sy Attach, sebelumnya di reference tambahkan file MSWORD.OLB. > Silahkan di coba aja semoga sesuai dengan keinginan. > > FileWord.zip di exstract ke C:\ > > > > Nur Ubaidi <[EMAIL PROTECTED] com> wrote: > > kemaren pak aksan nulis: > pls try this: > http://en.allexpert s.com/q/Using- MS-Access- 1440/report- Output-word- template. htm > > tp saya coba belum bisa.syukron atas bimbingannya > > ----- Original Message ---- > From: aksan kurdin <aksan.kurdin@ gmail.com> > To: belajar-access@ yahoogroups. com > Sent: Wednesday, April 16, 2008 9:04:02 AM > Subject: Re: [belajar-access] membuat report di word .dot (lanjutan) > > kode yang mana ya ? > bisa di kirimkan kembali ? > > aksan kurdin > > 2008/4/15 Nur Ubaidi <[EMAIL PROTECTED] com>: > > > > > > > > > > > > > > > > Assalamu'alaikum pak ahsan dan access mania... > > saya pernah nanya ttg kode mail merge ke ekstensi dot. kode yang pak ahsan > > tunjukkan kok ga bisa ya? mohon penjelasan lanjutan kode apa saja harus saya > > tulis? kalo perlu ada contoh mdbnya :), syukron akh.. > > > > between 0000-00-00 and 9999-99-99 > > -- > Aksan Kurdin > > > > > > > > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. > > > > > > > > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. > > > <!-- > > #ygrp-mkp{ > border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;} > #ygrp-mkp hr{ > border:1px solid #d8d8d8;} > #ygrp-mkp #hd{ > color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;} > #ygrp-mkp #ads{ > margin-bottom:10px;} > #ygrp-mkp .ad{ > padding:0 0;} > #ygrp-mkp .ad a{ > color:#0000ff;text-decoration:none;} > --> > > <!-- > > #ygrp-sponsor #ygrp-lc{ > font-family:Arial;} > #ygrp-sponsor #ygrp-lc #hd{ > margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;} > #ygrp-sponsor #ygrp-lc .ad{ > margin-bottom:10px;padding:0 0;} > --> > > <!-- > > #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} > #ygrp-mlmsg table {font-size:inherit;font:100%;} > #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} > #ygrp-mlmsg pre, code {font:115% monospace;} > #ygrp-mlmsg * {line-height:1.22em;} > #ygrp-text{ > font-family:Georgia; > } > #ygrp-text p{ > margin:0 0 1em 0;} > #ygrp-tpmsgs{ > font-family:Arial; > clear:both;} > #ygrp-vitnav{ > padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} > #ygrp-vitnav a{ > padding:0 1px;} > #ygrp-actbar{ > clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;} > #ygrp-actbar .left{ > float:left;white-space:nowrap;} > ..bld{font-weight:bold;} > #ygrp-grft{ > font-family:Verdana;font-size:77%;padding:15px 0;} > #ygrp-ft{ > font-family:verdana;font-size:77%;border-top:1px solid #666; > padding:5px 0; > } > #ygrp-mlmsg #logo{ > padding-bottom:10px;} > > #ygrp-reco { > margin-bottom:20px;padding:0px;} > #ygrp-reco #reco-head { > font-weight:bold;color:#ff7900;} > > #reco-grpname{ > font-weight:bold;margin-top:10px;} > #reco-category{ > font-size:77%;} > #reco-desc{ > font-size:77%;} > > #ygrp-vital{ > background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} > #ygrp-vital #vithd{ > font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;} > #ygrp-vital ul{ > padding:0;margin:2px 0;} > #ygrp-vital ul li{ > list-style-type:none;clear:both;border:1px solid #e0ecee; > } > #ygrp-vital ul li .ct{ > font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;} > #ygrp-vital ul li .cat{ > font-weight:bold;} > #ygrp-vital a{ > text-decoration:none;} > > #ygrp-vital a:hover{ > text-decoration:underline;} > > #ygrp-sponsor #hd{ > color:#999;font-size:77%;} > #ygrp-sponsor #ov{ > padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} > #ygrp-sponsor #ov ul{ > padding:0 0 0 8px;margin:0;} > #ygrp-sponsor #ov li{ > list-style-type:square;padding:6px 0;font-size:77%;} > #ygrp-sponsor #ov li a{ > text-decoration:none;font-size:130%;} > #ygrp-sponsor #nc{ > background-color:#eee;margin-bottom:20px;padding:0 8px;} > #ygrp-sponsor .ad{ > padding:8px 0;} > #ygrp-sponsor .ad #hd1{ > font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;} > #ygrp-sponsor .ad a{ > text-decoration:none;} > #ygrp-sponsor .ad a:hover{ > text-decoration:underline;} > #ygrp-sponsor .ad p{ > margin:0;} > o{font-size:0;} > ..MsoNormal{ > margin:0 0 0 0;} > #ygrp-text tt{ > font-size:120%;} > blockquote{margin:0 0 0 4px;} > ..replbq{margin:4;} > --> > > > > > > > ____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ >
