Information générale
Catégorie:
Codage, syntaxe et commandes
How to filter out those CustID having blank data in the SELECT statement?
.Open "SELECT * FROM Customer ORDER BY CustID.....
>Hi,
>Try to include the sort in your SELECT statment like this :
>
>.Open "SELECT * FROM Customer ORDER BY CustID",cnn1,adOpenKeyset,adLockOptimistic
>
>Hope this help
>Rgrds
>
>
>>I tried to sort the Recordset but it doesn't display correctly.
>>Anything when wrong with my codes as follows:
>>
>>Set rsCustLookup = New ADODB.Recordset
>>With rsCustLookup
>> .CursorLocation = adUseClient
>> .Open "SELECT * FROM Customer",cnn1,adOpenKeyset,adLockOptimistic
>> .Sort = CustID
>> .Requery
>>End With
>>
>>Set dcCustIDList.RowSource = rsCustLookup
>>dcCustIDList.ListField = "CustID"
>>dcCustIDList.Refresh
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement