I am posting it again

[Lina229]

Slecting a field then retrieving the specified records. [U]

How i can search my database by entering some value in one of my controls ???


say forexample that i have 2 textboxes and 2 combo's and 5 listboxes

if i entered a value in one of these controls ... and when i press Find Command Button .. i should retrieve the specified record

this is one questin ...
actually i have alot of questions .... i will post the rest of my questions later on ...step by step ...

i know that i am asking too much these days
p.s1. i am using access database ...and i am not using adobconnection.
p.s2. and if i have several records that match the same criteria i had entered ... how i can manage/view these records ? using Next/Previous record ? Right ?

Have a nice day all ...

[E-Link]

if u use data control
in the event click command button u type this code:

data1.recordsource = "select * from table1 where field1 = " & text1.text
data1.referesh

to view all result , u can use data grid.

[Abu haider]

If you aren't using adodbconnection, what are you using then?

You'll have to use sql to retrieve the records. Construct the sql command on the fly, based on the values entered.

You got it.

[E-Link]

where is ur attachment ?

[Lina229]

i am using the datagrid ....
but that is not what i want

i want to (u can say filtering ) . as i had posted before ....

if i entered a value in one of these textboxes ... and when i press Find Command Button .. i should retrieve the specified record


take a look on my attachement below...i am using a datagrid to view my database .

P.s. How i can use Data Control ?

thnx

[E-Link]

where did you bind ur datagrid , to adodc or data control ?

[Lina229]

Originally posted by Abu haider


If you aren't using adodbconnection, what are you using then?

You'll have to use sql to retrieve the records. Construct the sql command on the fly, based on the values entered.

You got it.

Yes of course i got it ....

i have an access2000 database .... i am not using (adobconnection) i am not familiar with ADO Connection i am using DAO....

[Lina229]

Originally posted by E-Link
where did you bind ur datagrid , to adodc or data control ?

to DataControl

[E-Link]

so , what's the matter with my code , which i posted before ?

if change the datasource of datacontrol , the datagrid will automatically change the contain.

[Lina229]

so how i can set focus on the textbox i want to search by its value ?

[Abu haider]

The greatest advice on Database programming:
USE ADO INSTEAD OF DAO.

DAO is worth forgetting.

[Lina229]

Originally posted by Abu haider
The greatest advice on Database programming:
USE ADO INSTEAD OF DAO.

DAO is worth forgetting.

well.......
i am intending to do so .... actually i am thinking to switch to the ADO thing ..

Do u know some articles or some sites which can provide me with some information .....