Asumsi data awal sdh ada di tabel.
Form Recordsourcenya sbb:
Select * from tblData Order By NoUrut
Letakkan ini di even onclik command button.
NoSisipan=2
Data = "eee"
Currentdb.execute "UPDATE tblData Set NoUrut=NoUrut+1 Where NoUrut>=" &
NoSisipan
Currentdb.execute "INSERT INTO tblData(NoUrut,Data) Values (" & NoSisipan &
",'" & Data & "')"
Salam Hangat dan Jabat Erat
MBA-Murid Belajar Access
EdyWIYONO
_____
From: [email protected] [mailto:[email protected]]
On Behalf Of Fachrur Rozi Utomo
Sent: Wednesday, June 02, 2010 11:28
To: [email protected]
Subject: [belajar-access] menyisipkan nomor
Dear pakar access,
mau tanya bisakah di access mesnyisipkan data dari form
misalkan data awal kita:
1. aaa
2. bbb
3. ccc
4. ddd
trus jika kita ingin menyisipkan data di no. 2 (eee)
maka otomatis dari no.2-4 menjadi no.3-5
data yang diminta:
1. aaa
2. eee
3. bbb
4. ccc
5. ddd
mohon pencerahannya.... terimakasih
rgds,
tomo
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.819 / Virus Database: 271.1.1/2910 - Release Date: 06/02/10
01:25:00
