如何用vb读取access表中数据,并赋值给另一变量然后进行计算判断? 急!

2025-03-09 07:43:17
推荐回答(1个)
回答1:

PrivateSubCommand1_Click()Adodc1.RecordSource="selectsum(金额)asmoneyfromTABLE1"Adodc1.RefreshIfAdodc1.Recordset.EOFThenMsgBox"没有可用金额",,"错误提示"Elselable2.text=Adodc1.Recordset.Fields(0).valueEndIfEndSub