I am posting it again

Printable View

Nov 25th, 2001, 02:48 AM
Lina229

I am posting it again

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 ...
Nov 25th, 2001, 02:54 AM
E-Link

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

Code:

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

to view all result , u can use data grid.

:D
Nov 25th, 2001, 02:59 AM
Abu haider

You seem very experienced with Database programming

:)

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.

:D
Nov 25th, 2001, 03:12 AM
E-Link

where is ur attachment ?

:confused:
Nov 25th, 2001, 03:15 AM
Lina229

1 Attachment(s)

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
Nov 25th, 2001, 03:19 AM
E-Link

where did you bind ur datagrid , to adodc or data control ?
:(
Nov 25th, 2001, 03:25 AM
Lina229

Re: You seem very experienced with Database programming

Quote:

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.

:D

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....
Nov 25th, 2001, 03:27 AM
Lina229

Quote:

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

to DataControl
Nov 25th, 2001, 03:37 AM
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.
Nov 25th, 2001, 06:08 AM
Lina229

so how i can set focus on the textbox i want to search by its value ?
Nov 25th, 2001, 09:36 PM
Abu haider

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

DAO is worth forgetting.
Nov 26th, 2001, 12:54 AM
Lina229

Quote:

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 .....