By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,806 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,806 IT Pros & Developers. It's quick & easy.

About searching records

P: 1
I want to search a record when user enter a primary key domain value.
I am using ADODC control. I want the coading and the logic behind thiplease send me this argent
Mar 28 '07 #1
Share this Question
Share on Google+
2 Replies


P: 16
I want to search a record when user enter a primary key domain value.
I am using ADODC control. I want the coading and the logic behind thiplease send me this argent
DO it like this,

ADODC1 is the name of the ADODC control.

Expand|Select|Wrap|Line Numbers
  1. with ADODC1.Recordset
  2.         if .recordcount = 0 then
  3.              msgbox "Empty Recordset"
  4.              exit sub
  5.         end if
  6.         .movefirst
  7.         .find = "idno = '" & txtidno.text & "'"
  8.         if .EOF then
  9.               msgbox "No match found"
  10.               .movefirst
  11.         else
  12.               msgbox "Match Found"
  13.               txtlastname.text = .fields("lastname")
  14.               txtfirstname.text = .fields("firstname")
  15.         end if
  16. end with
Mar 29 '07 #2

vijaydiwakar
100+
P: 579
I want to search a record when user enter a primary key domain value.
I am using ADODC control. I want the coading and the logic behind thiplease send me this argent
try to avoid the use of ADODC ctrl
use ADODB
and user recordsets filter property to do so
Mar 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.