Hi,
 
Seek can be use when you connect to a DB table, using the following method:
 
1.  rs.Index = "INDEX_NAME"
2.  rs.seek "=", COMPARE1, COMPARE2
 
3.  if rs.nomatch = TRUE then
 
4.  End if
 
Where:
 
1.  you have to specify the name of the INDEX (if already created, in the design mode 
of the DB)
2. Seek "=" is to search for the matching record, where COMPARE1 and COMPARE2 are the 
number of field  you use in your INDEX.  (In this case, your Index contains 2 fields)
 
3.  If rs.nomatch = False, it does not find any matches.
 
Hopes this helps  
 


Salman Fateh Ali <[EMAIL PROTECTED]> wrote:
Dear friends..

Any body tell me the real example other than msdn that
how to use SEEK Method.. 

Thanx...



[Non-text portions of this message have been removed]





'// =======================================================
    Rules : http://ReliableAnswers.com/List/Rules.asp
    Home  : http://groups.yahoo.com/group/vbHelp/
    =======================================================
    Post  : [EMAIL PROTECTED]
    Join  : [EMAIL PROTECTED]
    Leave : [EMAIL PROTECTED]
'// =======================================================



Yahoo! Groups SponsorADVERTISEMENT


---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
  
   To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
  
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


                
---------------------------------
Do you Yahoo!?
Friends.  Fun. Try the all-new Yahoo! Messenger

[Non-text portions of this message have been removed]




------------------------ Yahoo! Groups Sponsor --------------------~--> 
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~-> 


'// =======================================================
    Rules : http://ReliableAnswers.com/List/Rules.asp
    Home  : http://groups.yahoo.com/group/vbHelp/
    =======================================================
    Post  : [EMAIL PROTECTED]
    Join  : [EMAIL PROTECTED]
    Leave : [EMAIL PROTECTED]
'// =======================================================
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/vbhelp/

<*> To unsubscribe from this group, send an email to:
     [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/
 

Reply via email to