爲什麽 數據庫不會更新顯示呢?每次錄入新數據后WLS哪一行還是空缺的,這個是爲什麽呢?但是數據庫里已經錄入了新數據。Private Sub Command4_Click()
Dim sc As Integer
If MainForm.Label1(14) = "" Or MainForm.Label1(15) = "" Then 'ÅДàÊÇ·ñÓДµ“þä›Èë
sc = MsgBox("Please capture WYKO data first.", vbOKOnly, "Warning : ")
Else
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim wls_l_num, wls_es_num As String
Dim wls_ls_min, wls_ls_max, wls_ls_ave, wls_ls_ran, wls_ls_sd, wls_mea_cou, wls_mea_wa, wls_wa_l, wls_w1m1, wls_w1m2, wls_w2m2, wavelen As Long
Dim wls_data, wls_time As Date
Dim str1, str2, str3 As String
'Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=" & App.Path & "\WYKOData.mdb";Persist Security Info=True
str1 = "Provider=Microsoft.Jet.OLEDB.4.0;"
str2 = "Data Source=" & App.Path & "\WYKOData.mdb;"
str3 = "Jet OLEDB:Database Password="
conn.Open str1 & str2 & str3
strSQL = "select * from WYKOData"
rs.Open strSQL, conn, 3, 3
rs.AddNew
rs!WLS = Text1(6).Text
rs.Update
rs.Close
conn.Close
MsgBox ("Data Saved.")
Adodc1.Refresh
MSHFG1.Refresh
End If
End Sub
Dim sc As Integer
If MainForm.Label1(14) = "" Or MainForm.Label1(15) = "" Then 'ÅДàÊÇ·ñÓДµ“þä›Èë
sc = MsgBox("Please capture WYKO data first.", vbOKOnly, "Warning : ")
Else
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim wls_l_num, wls_es_num As String
Dim wls_ls_min, wls_ls_max, wls_ls_ave, wls_ls_ran, wls_ls_sd, wls_mea_cou, wls_mea_wa, wls_wa_l, wls_w1m1, wls_w1m2, wls_w2m2, wavelen As Long
Dim wls_data, wls_time As Date
Dim str1, str2, str3 As String
'Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=" & App.Path & "\WYKOData.mdb";Persist Security Info=True
str1 = "Provider=Microsoft.Jet.OLEDB.4.0;"
str2 = "Data Source=" & App.Path & "\WYKOData.mdb;"
str3 = "Jet OLEDB:Database Password="
conn.Open str1 & str2 & str3
strSQL = "select * from WYKOData"
rs.Open strSQL, conn, 3, 3
rs.AddNew
rs!WLS = Text1(6).Text
rs.Update
rs.Close
conn.Close
MsgBox ("Data Saved.")
Adodc1.Refresh
MSHFG1.Refresh
End If
End Sub
解决方案 »
- 数据库中的返回值是如何获得的.
- 请问怎样实现对多张表作同时查询(主键相同)
- 各位大哥请请帮帮小弟!我加载一个data控件类,所报出来的错误小弟查了好多资料没法解决,请帮帮忙!!!!!
- 关于统计打印页数的问题
- 关于十万条左右记录用ado、filter时的查询效率。求助!!!!!!!!!!!!!!
- VB+sqlite
- 紧急求救!
- 我写了个歌词播放器,大家下载后评价一下好吗?谢谢了。
- 在线等候!!一个很简单的有关数据库SQL查询的问题!!高分相送!!!!!!!!
- 我把BorderStyle设为None,但任务栏里的长方条里只剩下了标题,而没了Icon,怎办?
- 求改代码:VB控制MIDI
- [求助]VB实现的ActiveX导致IE6崩溃的问题
補充一個問題:
表頭設置為了A B C 這樣帶空格的形式 請問在VB里怎麼往其中添加數據呢?謝謝。