469,946 Members | 1,976 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

Searching Date filed, numeric field & tex field simulteneously

i have 4 fields in access database : rollno, name, date, fees

i am writing code in vb. i want to find rollno, name & date through vb (simultaneously) & i want to display respective fees.
Dec 13 '06 #1
3 1138
sashi
1,754 Expert 1GB
i have 4 fields in access database : rollno, name, date, fees

i am writing code in vb. i want to find rollno, name & date through vb (simultaneously) & i want to display respective fees.
Hi there,

Can you please make your question simple & clear as it would ease in providing solution in return. I assume you are talking about SQL query, right? Please provide details such the structure of the table as well as the table & field names invoved in the query, it's much easier to solve the puzzle in that way. Good luck & Take care.
Dec 13 '06 #2
i have 4 fields in access database : rollno, name, date, fees

i am writing code in vb. i want to find rollno, name & date through vb (simultaneously) & i want to display respective fees.
if i get your question right, this should work... using adodc

adodc1.commandtype=cmdtext
adodc1.recordsource="select * from [table name] where [table name].rollno= " & val(txt_rollno.text) &" and [table name].name=' " & txt_name.text &" ' and [table name].date=#" & txt_date.text & "#"
adodc1.recordset.requery
adodc1.refresh

just connect your datagrid to your adodc and you'll see the filtered records...
i hope it works..
best regards...
Dec 13 '06 #3
Killer42
8,435 Expert 8TB
...
Expand|Select|Wrap|Line Numbers
  1. ..." and [table name].name=' " & txt_name.text &" ' and ...
Gotta watch those spaces, Pete. :)
Dec 22 '06 #4

Post your reply

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

Similar topics

3 posts views Thread by Ivan V via DotNetMonster.com | last post: by
6 posts views Thread by yoshitha | last post: by
3 posts views Thread by John | last post: by
8 posts views Thread by saladinator | last post: by
3 posts views Thread by Savvas Tsitouridis | last post: by
3 posts views Thread by Ahmad Jalil Qarshi | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.