Untuk no. 2 hanya menulis di design table di formatnya untuk AutoNumber dengan tulisan "PG00"00. Untuk no. 1 saya biasanya pakai query.
regards, Tio "safety_zone1" <[email protected]> Sent by: [email protected] 12/10/2009 01:27 PM Please respond to belajar-access To: [email protected] cc: Subject: [belajar-access] DDL dan Generate otomatis ID Selamat siang Pak, maw tanya nih. 1.Kalo di access kalau maw membuat syntax ddl seperti insert, update dan delete lewat coding Vb-nya bagaimana yha? Jadi selain lewat macro... 2.Kalo dalam access misalkan sy punya id_pegawai PG001, nah untuk pendaftaran pegawai berikutnya apakah id_pegawai bisa digenerate secara otomatis? misal langsung PG002. Kalo lewat programming vb non access mudah, tapi klo di access bagaimana? Terima kasih banyak. Fajar ITS-Surabaya. =========================================================================== This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. The Trakindo Group of Companies do not accept liability for damage caused by this email and may monitor email traffic. Unless expressly stated, any opinions are the sender's and are not approved by the Tiara Marga Trakindo Group of Companies and this email is not an offer, solicitation, recommendation or agreement of any kind. ===========================================================================
