請問各位大鳥,我想要取出一個資料表里最后一條記錄的某一個欄位的值,為何這我樣寫,取出的卻是第一條記錄的值!
Dim dbs As Database
Dim strName As String
Dim rstArchivesExist As Recordset
Dim fidArchivesName As Field
Set dbs = CurrentDb
Set rstArchivesExist = dbs.OpenRecordset("tbl月檔情況", dbOpenSnapshot)
Set fidArchivesName = rstArchivesExist.Fields("月檔名稱")
rstArchivesExist.MoveLast
strName = fidArchivesName.Value另外哪里可以下載vb6.0繁休版的?
Dim dbs As Database
Dim strName As String
Dim rstArchivesExist As Recordset
Dim fidArchivesName As Field
Set dbs = CurrentDb
Set rstArchivesExist = dbs.OpenRecordset("tbl月檔情況", dbOpenSnapshot)
Set fidArchivesName = rstArchivesExist.Fields("月檔名稱")
rstArchivesExist.MoveLast
strName = fidArchivesName.Value另外哪里可以下載vb6.0繁休版的?
解决方案 »
- 水晶报表换行问题
- 求教关于程序退出码
- 已知日期"2006-10",我想往表里添加记录"2006-10-1"至"2006-10-31",请问怎么解决.
- inputbox函数简单问题(散10分)
- 一个根据TreeView写XML文档的问题,比较难,100分送出
- 四个三角了,散点分
- 怎样用Esc 键关闭一个窗口
- 如何用sendmessage向别的程序发快捷键
- 怎样才能得到TExt产生的SCROLL的Value数值呢
- 请问怎么样用VB向Access中为OLE型字段添加图片?还有怎么样可以再在VB中取出?
- 今天心情好, 升到五个三角形了, 偶来散点分, 顶者有份!
- 千秋网页餐饮管理系统,希望各位哥哥姐姐给点意见
Dim dbs As Database
Dim strName As String
Dim rstArchivesExist As Recordset
Dim fidArchivesName As Field
Set dbs = CurrentDb
Set rstArchivesExist = dbs.OpenRecordset("tbl月檔情況", dbOpenSnapshot)
rstArchivesExist.MoveLast
Set fidArchivesName = rstArchivesExist.Fields("月檔名稱")
strName = fidArchivesName.Value