Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek or locate a record.
Message
De
02/02/2001 17:13:57
 
 
À
02/02/2001 16:41:25
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, États-Unis
Information générale
Forum:
Visual Basic
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00472006
Message ID:
00472022
Vues:
27
>I am using VB6 and Access97. I am using the data control object to move though the records on the form.
>
>However, if an ID is passed into the form, how can I SEEK or LOCATE that record and display that record in the form?
>
>Thanks,
>
>Jerryt

Jerry,
Assuming you are using ADO, the equivalent of Locate would be the Find method of the rs object. To use seek the provider needs to support indices, which I believe the jet provider does. The method would be Seek on the recordset object.

You can check if Seek is supported by the provider with Supports(adSeek) method of the recordset object. See exact syntax and examples on the ADO help in MSDN.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform