SQL query returning EOF

Question

Editing a state data field.&nbsp; Hitting a table called "States".&nbsp; If i get a hit then data entry is good otherwise invalid entry.&nbsp; So only needs to return one record.&nbsp; When i hardcode the state ""KS"" it works fine.&nbsp; Use the string variable, EOF.&nbsp; &nbsp;Print the variable in immediate window value is KS.&nbsp; &nbsp;Stop execution and point at the variable value is, "KS" with the quotes, and throws EOF.&nbsp;&nbsp;The query runs executes perfectly in query designer.&nbsp; &nbsp;RecCount = -1.&nbsp; Very simple query.&nbsp; &nbsp;Very confused.&nbsp; Please help!!&nbsp;Set objRecordset = New ADODB.RecordsetobjRecordset.ActiveConnection = CurrentProject.Connection'objRecordset.Open SQLvalobjRecordset.Open "SELECT States.[State Abbreviation], States.State FROM States WHERE (((States.[State Abbreviation]) = [State]));"RecCount = objRecordset.RecordCountIf objRecordset.EOF = True Then

arnel_gp · Answer

dSilverDevil&nbsp;&nbsp;you can use DAO.Recordset also.your current query will not include Null (empty) for [State Abbreviation] Or [State].always test for both .BOF And .EOF.&nbsp;

silverdevil · Answer

arnel_gp&nbsp; &nbsp;Thanks for your response!&nbsp; &nbsp; I will convert this to DAO and see if it handles the query better.&nbsp; Will also check for both EOF and BOF.&nbsp; &nbsp;I hope this helps.&nbsp; I will be a couple days before i can get back to this.&nbsp; &nbsp;I will respond again.&nbsp; &nbsp;Again, thanks.

Forum Discussion

SQL query returning EOF

2 Replies

Resources