Hus Keren Bos

 

Memang Benar, Tapi mau Tanya Di Kode 

Stlink ="[po_suplyer_id]='S", S di sini maksutnya apa y?

 

Yokanan Wahyono

 

  _____  

From: [email protected] [mailto:[email protected]]
On Behalf Of MBA
Sent: Friday, March 19, 2010 11:39 AM
To: [email protected]
Subject: RE: [belajar-access] Membuka Forms dengan Criteria

 

  

Bapak, saya rasa bapak tidak teliti ketika menuliskan kriteria yaitu dengan
mengikutkan forms![fd_outstanding_po]!

Cukup dimasukkan kolom yang sesuai di form yang akan di filter, dengan
kriterianya.

 

Private Sub Command18_Click()

Dim stlink As String

 

stlink = "[po_suplyer_id]= 'S" & Me.Suplyer_ID.Value & "'"

DoCmd.OpenForm "fd_outstanding_po", acFormDS, , stlink, acFormReadOnly

End Sub

 

 

Salam hangat dan jabat erat,

MBA

 

  _____  

From: [email protected] [mailto:[email protected]]
On Behalf Of yokananwahyono
Sent: Thursday, 18 March, 2010 13:38
To: [email protected]
Subject: [belajar-access] Membuka Forms dengan Criteria [1 Attachment]

 

[Attachment(s) from yokananwahyono included below] 





Dear Para Master

 

Saya coba buka forms dengan Criteria tertentu kok tidak bisa jalan y?

Data harusnya keluar tapi tidak keluar

Berikut kodenya

 

Dim stlink As String

 

stlink = "forms![fd_outstanding_po]![po_suplyer_id]= '" &
Me.Suplyer_ID.Value & "'"

DoCmd.OpenForm "fd_outstanding_po", acFormDS, , stlink, acFormReadOnly

 

 

Salam

 

Yokanan

 

 

 

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.791 / Virus Database: 271.1.1/2753 - Release Date: 03/18/10
02:33:00



Kirim email ke