Minggu, 23 Oktober 2011

Re: [belajar-access] Re: Unique Combo box field [1 Attachment]

 
[Attachment(s) from Hstudio Tmk included below]

Opps file nya ketinggalan..
tks


From: jkssbma <jkssbma@live.com>
To: belajar-access@yahoogroups.com
Sent: Friday, October 21, 2011 6:59 PM
Subject: [belajar-access] Re: Unique Combo box field

Data yang dicari harus memiliki korelasi dgn data yg ada pada combobox. Jadi yg mau diambil/dicari gabungan data field nama dan tgl.input ?
beberapa pertanyaan yg perlu dipertimbangkan :
1. data Combobox diambil dari tabel/query apa ?
2. Data yg ingin di cari memiliki field2 apa saja yg mungkin terkait dgn tabel/query sumber bagi combobox ?

Kalau tak mau pusing silakan file mdb/acdb disertakan pada attachment email yg anda kirim ke belajar-access@yahoogroups.com


--- In belajar-access@yahoogroups.com, "hstod" <hstudio7@...> wrote:
>
> query :
>
> nama-------- tgl.input ----- chek.in
>
> master------12/10/11--------13/10/11
> mister------16/10/11--------18/10/11
> master------18/10/11--------19/10/11
>
> search : by combobox di form dengan code :
> Dim rs As Object
> Set rs = Me.Recordset.Clone
> rs.FindFirst "[nama] = '" & Me![CBSearch] & "'"
> If Not rs.EOF Then Me.Bookmark = rs.Bookmark
>
> untuk nama yang beda record bisa di tampilkan dengan benar, namun jika nama sama maka record tidak akurat (mengikuti yg paling pertama di input).
>
> saya coba dengan mengambil dari data id autonumber namun tidak bisa. gmn cara nya untuk bisa menampilkan data di form walau nama sama? tapi untuk tgl input dan lainnya tetap beda! (jadi record di form tetap akurat berdasarkan tgl input)
>
> tks
>




------------------------------------

SPAM IS PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/belajar-access/join
    (Yahoo! ID required)

<*> To change settings via email:
    belajar-access-digest@yahoogroups.com
    belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/



__._,_.___

Attachment(s) from Hstudio Tmk

1 of 1 File(s)

Recent Activity:
SPAM IS PROHIBITED
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar