Why Recordcount equal to 0?

[joseprez]

I have the follow line in my code:

Set SN = DB.OpenRecordset("SELECT * FROM Sales WHERE ID LIKE " & ID_Temp, dbOpenSnapshot)

When Table Sales have 1 record, SN.Recordcount return 0 and my application send error 3021.

How solve this?

 

[zemp]

The way you have it set up now the 'Like' might as well be an '='. You will need to use some wildcard characters if you want to get the most out of the keyword 'Like'.

The wildcard character may depend on the database you are using so check the help files for examples. Thanks and Good Luck!

zemp

 

[essnrv]

Change you key type Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

 

[Killa]

I'm not 100% sure but are you saying that the real record count is 1 but when u use .recordcount it returns 0?????


I have seen that before When it happened to me i used .movelast then .recordcount and it returned the true record count


Or am i barking up the wrong tree

Killa

 

[zemp]

With error 3021 there are no records in the recordset. rs.movefirst will throw that error. Thanks and Good Luck!

zemp

 

[Acquiesce]

try changing the cursor location to useClient:

SN.cursorLocation = adUserClient

i think this may well be your problem

hope that helps