/* */

Wednesday, December 2, 2015

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

 

 


From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com]
Sent: 01 Desember 2015 16:49
To: belajar-access@yahoogroups.com
Subject: 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)

1 of 1 File(s)


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.
simpan dua form.PNG


SPAM IS PROHIBITED

Visit Your Group

·                                 New Members 2



.


__,_._,___

No comments:

Post a Comment