|
附件中,我画好了窗体,窗体值生成数组函数也写好了,就是有一个控件option button的问题不知道该如何解决,求大神帮助- Sub 窗体控件写入数据库()
- Dim chuangti As UserForm
- Dim strtable As String
- Dim k%, m%, i%, arr(), arr1()
- Dim ctr As Control
-
- Set chuangti = Me
- '窗体写入数组
- For Each ctr In chuangti.Controls
- '将窗体控件的名称和值分别写入数组,以便于后续SQL写入数据库
- If TypeName(ctr) = "TextBox" Or TypeName(ctr) = "ComboBox" Then
- k = k + 1
- m = m + 1
- ReDim Preserve arr(1 To k)
- ReDim Preserve arr1(1 To m)
- arr(k) = ctr.Name
- arr1(m) = ctr
- End If
- Next
-
- Dim SQL As String
- Dim cnn As Object
- Set cnn = CreateObject("adodb.connection")
- With cnn
- .Provider = "microsoft.ace.oledb.12.0"
- .ConnectionString = ThisWorkbook.Path & "\丰润财税.accdb"
- .Open
- End With
- strtable = "订单明细表"
- 'For i = 1 To UBound(arr)
- 'insert into 表名(列1,列2)values(值1,值2,值3)
- SQL = "INSERT into " & strtable & " (" & arr & ") values " & "('" & arr1 & "')"
- cnn.Execute (SQL)
- 'Next
- '释放空间变量
- cnn.Close '关闭连接
- Set cnn = Nothing '释放空间
-
- MsgBox "写入成功"
- End Sub
复制代码
|
|