Option Explicit
Private rsUser As New ADODB.RecordsetPrivate Sub Form_Load()
If rsUser.State = adStateOpen Then rsUser.Close rsUser.Open "select top 1 use_no from Stock_users", CN, dOpenDynamic, adLockOptimistic
......
在這句出錯,不知為何? If rsUser.State = adStateOpen Then rsUser.Close
Error:
Run time 430
Class does not support Automation or does support expected interface 請幫忙
Private rsUser As New ADODB.RecordsetPrivate Sub Form_Load()
If rsUser.State = adStateOpen Then rsUser.Close rsUser.Open "select top 1 use_no from Stock_users", CN, dOpenDynamic, adLockOptimistic
......
在這句出錯,不知為何? If rsUser.State = adStateOpen Then rsUser.Close
Error:
Run time 430
Class does not support Automation or does support expected interface 請幫忙
Private rsUser As New ADODB.RecordsetPrivate Sub Form_Load()
set rsUser = New ADODB.Recordset
rsUser.Open "select top 1 use_no from Stock_users", CN, dOpenDynamic, adLockOptimistic
......