|
发表于 2009-2-26 13:07:34
|
显示全部楼层
来自: 中国辽宁营口
以Access为例,在用户窗体放置一个adodc控件,在过程中写入如下代码- Const 百分比 = 0.4
1 D( `3 C5 A" E. p - With UserForm1.Adodc1
* L% f: @! y6 Y4 e( m - .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"
, a- j: y; R+ x7 i; ?& Z, A+ `$ k - .RecordSource = "表1"
# j9 R1 X* V8 x0 Y. D0 q( S3 _ - .Refresh. X* I; d: S5 v
- With .Recordset
# E" \- Y: X6 a( m6 y7 B - Do Until .EOF& x7 ~9 l; `2 h& C1 l
- .Fields("税收") = .Fields("工资") * 百分比& Z1 K, g" _+ I, a) M9 r- G5 b5 F" \
- .MoveNext) ?% {" d) g$ w7 R$ e
- Loop/ X. K8 N7 i" M( K
- End With
5 c- B9 R3 I2 U - End With
复制代码 |
评分
-
查看全部评分
|