Re: [belajar-access] Simpan dari dua form ke satu tabel [2 Attachments]

 

[Attachment(s) from Darsono darsono72@yahoo.com [belajar-access] included below]

Hallo Satri,

Mencoba menjawab,

Coba gunakan modul,
caranya buat modul Public :

Option Compare Database

Public Sub simpan_data(data_nya As String)

Set db = CurrentDb

    SQL = "INSERT INTO Table1 (Field) Values('" & data_nya & "')"

    db.Execute SQL, False

db.Close

Set db = Nothing

    

End Sub

selanjutnya

buat event onclik pada tombol simpan (bukan menggunakan Macro) pada kedua form

Private Sub Command2_Click()

    Call simpan_data(Text0)

End Sub

selamat mencoba.

 

Darsono
Simpati - WA  : 0812-8670-1010
M3                  : 0856-878-1010
FB                   : Darsono Kroya
Twitter             : @darsono72

BB                   : 5570F542

On Tuesday, December 1, 2015 3:52 PM, "satriauad@yahoo.co.id [belajar-access]" <belajar-access@yahoogroups.com> wrote:

 

[Attachment(s) from satriauad@yahoo.co.id [belajar-access] included below]

Master...
Mohon bantuan, saya punya 2 form yang identik dan proses simpan keduanya sama ke 1 tabel (file saya sertakan).
Bagaimana ya caranya agar penulisan codenya/module nya cuma satu, biar proses editnya mudah, maaf dan terimakasih

__._,_.___

Attachment(s) from Darsono darsono72@yahoo.com [belajar-access] | View attachments on the web

1 of 1 Photo(s)

simpan dua form.PNG

1 of 1 File(s)

data_rambo.accdb

---

Posted by: Darsono <darsono72@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Check out the automatic photo album with 1 photo(s) from this topic.

---

SPAM IS PROHIBITED

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___