When I compile the following Access 2003 project, I get this error on the "Rs!" portion of the "rs!.NextID". The error is:
Type declaration character does not match declared data type
I want to point out that NextId in the testTable is defined as an Int
The code portion is:
Dim intNextTransId As Integer
Set rs = New ADODB.Recordset
rs.Open " SELECT * FROM dbo.testTable WHERE FunctionID = 'AR'", GetAdoConnectString("AR"), adOpenStatic, adLockOptimistic, adCmdText
If rs.EOF Then
intNextTransId = 1
Else
intNextTransId = rs!.NextID
End If
rs.Close
Type declaration character does not match declared data type
I want to point out that NextId in the testTable is defined as an Int
The code portion is:
Dim intNextTransId As Integer
Set rs = New ADODB.Recordset
rs.Open " SELECT * FROM dbo.testTable WHERE FunctionID = 'AR'", GetAdoConnectString("AR"), adOpenStatic, adLockOptimistic, adCmdText
If rs.EOF Then
intNextTransId = 1
Else
intNextTransId = rs!.NextID
End If
rs.Close
