|
发表于 2009-2-26 13:07:34
|
显示全部楼层
来自: 中国辽宁营口
以Access为例,在用户窗体放置一个adodc控件,在过程中写入如下代码- Const 百分比 = 0.4
1 Z5 Z7 ~+ d6 T x/ a% x. j - With UserForm1.Adodc1
" O% V" x0 A% y( W3 e0 W5 q$ q - .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"# U! x2 J3 y" Q( O# x
- .RecordSource = "表1"1 [; v0 Z- ` V5 v, l" T( |# N( @: G
- .Refresh# K0 n1 ~' P+ q4 l& \
- With .Recordset6 j% s! ?! J- O
- Do Until .EOF6 k$ L/ v1 e3 a- ]( _; J
- .Fields("税收") = .Fields("工资") * 百分比( B2 W$ V+ P/ B6 t0 l8 h' C: }
- .MoveNext
7 p$ r" z: a1 R3 ~- G) H3 H; e - Loop% ^4 ]5 _, ], I, [( w3 V# j* P7 f! @
- End With3 H7 x$ v, ? n: `9 y
- End With
复制代码 |
评分
-
查看全部评分
|