哪位能帮忙详细解释一下以下代码的含义?

来源:百度知道 编辑:UC知道 时间:2024/05/27 01:26:55
Option Compare Database

Function ChangeProperty(strPropName As String, varPropType As Variant, varPropvalue As Variant) As Integer

Dim dbs As Object, prp As Variant
Const conPropNotFoundError = 3270
Set dbs = CurrentDb
On Error GoTo Change_Err
dbs.Properties(strPropName) = varPropvalue
ChangeProperty = True
Change_Bye:
Exit Function
Change_Err:
If err = conPropNotFoundError Then ' Property not found.
Set prp = dbs.CreateProperty(strPropName, varPropType, varPropvalue)
dbs.Properties.Append prp
Resume Next
Else ' Unknown error.
ChangeProperty = False
Resume Change_Bye
End If
End Function

在数据库中查询strPropName的值,如果该值等于varPropvalue值返回True如果不等返回False而varPropType在该函数中没有意义。
厚道点,多给点分,我眼睛都看麻了!