terima kasih atas tangapannya....
tapi kho gak bisa yach....
padahal saya sudah buat module sbb :

Public WJet As Workspace
Public dbGen As Database
Public rsPO As Recordset
Public rsTemp As Recordset
Public rsSD As Recordset

Public Sub DtLoad()
  Set dbGen = WJet.OpenDatabase(vgen, False, False, ";pwd=default")
 Set rsPO = dbGen.OpenRecordset("PO", dbOpenTable)
 Set rsTemp = dbGen.OpenRecordset("TEMP", dbOpenTable)
 Set rsSD = dbGen.OpenRecordset("DESCRIPTION", dbOpenTable)
  
End Sub
 
tapi waktu saya panggil di form_load() muncul error "object variable or with 
block variable not set"
 
With rsTemp     ...."muncul error disini"
   While Not .EOF
     .......
     ........
   .MoveNext
     Wend
   End With
 
terima kasih
vank

 
Eko Heri Susanto <[EMAIL PROTECTED]> wrote:

> Bagaimana caranya jika data tsb. bisa digunakan di semua form 
(module) ???
> (saya juga menggunakan index untuk seek data)

Coba deklarasi Dim anda rubah menjadi Public, contoh:
Public WJet As Workspace
Public dbGen As Database
Public rsPO As Recordset
Public rsTemp as Recordset
Public rsSD as Recordset





Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]

Ikuti juga forum diskusi VB.net dengan 
mengirim email kosong ke [EMAIL PROTECTED]




---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-vb/
  
   To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
  
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


                
---------------------------------
Do you Yahoo!?
 Plan great trips with Yahoo! Travel: Now over 17,000 guides!

[Non-text portions of this message have been removed]



Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]

Ikuti juga forum diskusi VB.net dengan 
mengirim email kosong ke [EMAIL PROTECTED]
 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

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



Kirim email ke