MadhiContributor15 years agoADO Connection DBInstance = "3db60a7a-6443-45ff-8ae6-d05d0d05e007" Set AConnection = ADO.CreateADOConnection AConnection = .CreateADOConnection AConnection.ConnectionString = "Provider=SQLOLEDB.1;Integra...Show More
tristaanogreEsteemed Contributor15 years agoThe reason being is that you are getting 1 record back from your query consistint of the count... what you need to do is, instead of using record count, get the value from the record present of the first column.
Related ContentADO Connection is not workingADO: Connection to the database still exists, after calling connection.close (Oracle)Cannot Connect to New Database Server using ADOSQL Server does not exist or access denied- ADO Connectionado recordsets wrong with datatype text
Recent DiscussionsAccess a child in a tree Structure through Keyword StrokesTurn off all Edge messageboxesHow to verify data from another application, the data which keeps changingAudit and Reporting purposesTextbox values disappear after adding Year value from Date Picker