Re: [Programmer-VB] tolong donk ada yang bisa ga..urgent banget ne

Mon, 02 Jan 2006 22:11:30 -0800

aku ada solusi nih,coba aja :
 
strcls = "select NamaCustomer,AlamatCutomer from Customer order by NamaCustomer"
Set Obj_Rec = New ADODB.Recordset
Obj_Rec.Open strcls, m_Conn, adOpenKeyset, adLockReadOnly
If Not (Obj_Rec.BOF Or Obj_Rec.EOF) Then
  Do Until Obj_Rec.EOF
          CboAccountComp.AddItem Trim(Obj_Rec![namaCustomer]) & Space(3) & Trim(Obj_Rec![alamatCustomer])
          Obj_Rec.MoveNext
       Loop
    End If
    Obj_Rec.Close
    Set Obj_Rec = Nothing
 
 
 
 


BONY IRAWAN <[EMAIL PROTECTED]> wrote:
mungkin ini juga bisa :

select NamaCustomer || ',  ' || AlamatCustomer from
(select NamaCustomer,AlamatCutomer from Customer order by NamaCustomer)

tapi sintak query itu biasa di oracle, kalau di VB tinggal disesuaikan.

semoga membantu

Asral Sukma <[EMAIL PROTECTED]> wrote:
coba bantu ya..
 
combo1=rs!a & rs!b
 
lakukan setelah query
 
ok
 
--aL--

jeffrey_ananta <[EMAIL PROTECTED]> wrote:
saya lagi ada problem dengan combo box ni...
dalam 1 combo box bisa gak nampilin 2 field?
misalnya:
dalam combo box NamaCustomer ada dua data..
yang pertama nama customer, disebelahnya alamat customer
kalo di access bisa..dan kantor saya mau yang kayak gitu..

kalo dengan access bisa langsung dengan query:
select NamaCustomer,AlamatCutomer from Customer order by NamaCustomer
di combo box access dia langsung nongol

jeffrey    Kebon Jeruk
Didin      Kemayoran

ada saran? atau ada cara mengakalinya?
saya pake vb6 dan database access

thanks atas jawabannya
jeffrey




Yahoo! Shopping
Find Great Deals on Holiday Gifts at Yahoo! Shopping

Yahoo! DSL Something to write home about. Just $16.99/mo. or less

Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.

Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]



SPONSORED LINKS
Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language

YAHOO! GROUPS LINKS



Kirim email ke