Hi & Thanx for your reply & help. But the problem is when i am using DSN it errors that record set doesn't support index property.
What should i do when i want to use seek on SQL Server database. Thanx & Best regards. >From: Dave Nguyen <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: Re: [vbhelp] About Seek Method >Date: Tue, 8 Jun 2004 16:46:15 -0700 (PDT) > >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] > > _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
