同上
解决方案 »
- 删除access数据
- 急!100分奖励如何用API waveoutwrite函数播放wav文件
- 如何做hotmail.com的邮箱注册,用webbrowers做自动注册,提示错误,地址是https://signup.live.com/newuser.aspx?mkt=ZH-CN&revipc=CN&ts=4277070&sh=iz5d&ru=http
- 如何让文件选择对话框只先目录即可
- 巨难问题!
- 遇到难题了?解决立马给分!
- 知道月份,怎样确定月末是几号?
- 急。。。怎样计算一个在长方形中最多可划分出多少个小长方形
- vb升级.net 问题: 数组元素的值得长度怎么改写?
- 7:30之前一定要交。。。。急。。。。!!!!
- 还差303分到10000,散分纪念一下
- 据说今天是七夕,光棍们都进来接分吧
--------------
Public Function ValidateIDIsOnly(flxName As MSHFlexGrid, strID As String, Optional strID2 As String, Optional strID3 As String, Optional CurrentRow As Integer = -1, Optional ValidateColumn As Integer = 1) As Boolean
' 主要功能:驗證ID是否是唯一
On Error GoTo ErrEnd
Dim i As Integer
Dim flag2 As Boolean
Dim flag3 As Boolean
Dim Pos As Integer
If CurrentRow = -1 Then
Pos = flxName.Row
Else
Pos = CurrentRow
End If
For i = 1 To flxName.Rows - 1
If flxName.TextMatrix(i, ValidateColumn) = "" Then Exit For
If flxName.TextMatrix(i, ValidateColumn) <> "" And i <> Pos Then
If strID2 <> "" Then
flag2 = IIf(flxName.TextMatrix(i, 2) = strID2, True, False)
Else
flag2 = True
End If
If strID3 <> "" Then
flag3 = IIf(flxName.TextMatrix(i, 3) = strID3, True, False)
Else: flag3 = True
End If
If flxName.TextMatrix(i, 1) = strID And flag2 And flag3 Then
ValidateIDIsOnly = False
Exit Function
End If
End If
Next
ValidateIDIsOnly = True
ErrEnd:
End Function
------------www.vicmiao.com
努力就有美好时光!