vahidnewtoon
شنبه 13 بهمن 1397, 23:38 عصر
سلام اشکال کد زیر چه که خطای ذیل رو نشون میده
Public Function fAppendDogNames(intOwnermob1 As Integer) As String
Dim intNoOfDogs As Integer, strNames As String
intNoOfDogs = DCount("*", "tblord", "[mob1]=" & intOwnermob1)
If intNoOfDogs = 1 Then
fAppendDogNames = DLookup("[CodProducts]", "tblord", "[mob1]=" & intOwnermob1)
Exit Function
Else
Dim MyDB As DAO.Database, MyRS As DAO.Recordset
Set MyDB = CurrentDb()
Set MyRS = MyDB.OpenRecordset("Select * From tblord Where [mob1]=" & intOwnermob1, dbOpenSnapshot)
MyRS.MoveFirst
Do While Not MyRS.EOF
If Len(strNames) = 0 Then
strNames = MyRS![CodProducts]
Else
strNames = strNames & " " & MyRS![CodProducts]
End If
MyRS.MoveNext
Loop
fAppendDogNames = strNames
End If
MyRS.Close
Set MyRS = Nothing
End Function
Public Function fAppendDogNames(intOwnermob1 As Integer) As String
Dim intNoOfDogs As Integer, strNames As String
intNoOfDogs = DCount("*", "tblord", "[mob1]=" & intOwnermob1)
If intNoOfDogs = 1 Then
fAppendDogNames = DLookup("[CodProducts]", "tblord", "[mob1]=" & intOwnermob1)
Exit Function
Else
Dim MyDB As DAO.Database, MyRS As DAO.Recordset
Set MyDB = CurrentDb()
Set MyRS = MyDB.OpenRecordset("Select * From tblord Where [mob1]=" & intOwnermob1, dbOpenSnapshot)
MyRS.MoveFirst
Do While Not MyRS.EOF
If Len(strNames) = 0 Then
strNames = MyRS![CodProducts]
Else
strNames = strNames & " " & MyRS![CodProducts]
End If
MyRS.MoveNext
Loop
fAppendDogNames = strNames
End If
MyRS.Close
Set MyRS = Nothing
End Function