bantu dikit yaa..
proses yg saya pakai menggunakan adodb:
open koneksi dtbase dl, misal namanya cn.
set rs = new adodb.recordset
rs.CursorLocation = adUseClient
rs.Open "Select * from PurchRet_Total", cn, adOpenKeyset, adLockBatchOptimistic
rs.addnew
rs("PurchRet_Number") = Trim(txtKode.text)
rs("Store_ID") = txtstore.text
rs.Update
seharusnya sudah bisa simpan, klau byk record, bisa pake perulangan aja.
CMIIW..
(\__/)
(='.'=) Agus Sudana
(")_(")
----- Original Message ----
From: budi <[EMAIL PROTECTED]>
To: [email protected]
Sent: Wednesday, April 25, 2007 9:53:38 AM
Subject: Re: [indoprog-vb] Record tidak tersimpan
biasanya record gak ketangkep karena kita tidak buka open
transaksinya. ..
contoh
db-> connection database
saat mulai melakukan transaksi harus di mulaioleh sintak
db.begintrans
dan diakhiri oleh
db.committranas
----- Original Message -----
From: McBoenBoen
To: indoprog-vb@ yahoogroups. com ; Waroeng VB ; programmer-vb@ yahoogroups.
com
Sent: Tuesday, April 24, 2007 8:02 PM
Subject: [indoprog-vb] Record tidak tersimpan
Dear All VBers,
Mohon pencerahannya,
Kenapa program saya tidak bisa insert record pada tabel detail?
saya sudah coba tangkap mess errornya tapi tidak ada error...
saya pakai VB dan Acess 2003, apakah krn jumlah fieldnya terlalu banyak? ada
66 field
tp kenapa erronya ga ketauan?
mohon pencerahanya. ..
rgds,
mc=
------------ --------- --------- ---
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
