Cara Update dan Delete di Listbox VBA Excel || Gratis File

[@MohamedHamada052]

How to populate userform from access database same way

[@ardia-7089]

mas ada pertanyaan, ni
mengenai multipage, misal
saya punya userform1 dan userform2, pada userform1 ada multipage dan pada userform2 ada frame input data kemudian userform1 adalah sebagai tempat tampil data dari userform2 tadi, terima kasih atas jawabannya,salam

[@bukittutorial7799]

maksutnya kayak ini kah bang :
th-cam.com/video/BzKDLJs4VOg/w-d-xo.html

[@ardia-7089]

@@bukittutorial7799 Alhamdulillah ya, benar mas,... terima kasih atas jawabannya, nanti saya coba,...maaf agak telat buka email

[@MohamedHamada052]

Hi bro i asked you before how can i do this from access database not excel sheet

[@bukittutorial7799]

OK, you have to use a connection to the Ecces database, here is an example of the connection:
Public SQL As String
Public cn As ADODB.Connection
Public rs As ADODB.Recordset
Public rss As ADODB.Recordset
Sub Connect()
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
With cn
.Provider="Microsoft.ACE.OLEDB.12.0"
.ConnectionString = "Data Source = " & ThisWorkbook.Path & "\FolderName\DatabaseName.accdb"
.Open cn
EndWith
End Sub
Sub Disconnect()
Set cn = Nothing
Set rs = Nothing
End Sub

[@MohamedHamada052]

@@bukittutorial7799You don’t understand me , in your video you created list view with column buttons i know but you used excel sheet as database i want this form in excel populate from access database Not how I connect excel with access

[@dragonhunter8608]

Klw boleh minta no hpnya bang hehehe

[@rezakesuma7494]

kok , file nya gak mau di run ya bos

[@bukittutorial7799]

kalo ndak bisa langsung di run ...filenya cobak di save as lagi dulu dikasih nama baru biasanya gitu disettingannya macro nya kang