Run a query on Access97 db

[rockies1]

I've never done much database work with VB, but I need to do the following:

Have users enter 2 numbers in text boxes. Then run a query on an access table where it returns all data between those 2 numbers.

Can someone point me in the right direction?

Thanks!!

------------------
Morgan
rockies1@gvi.net
My Web Page (http://members.xoom.com/Rockies1)

[chrisfricke]

You'll have to modify this code to suit your database, but here goes

have the two text boxes called text1 and text2.

Enter the following code in the event you are going to use to query the data base (eg a button click)

dim sql as string
dim mydatabase as database
dim myrecordset as recordset

set mydatabase = opendatabase("path to the database",false,false)

sql="Select * from mytable where myfield1>=" & val(text1.text) & " and myfield2>=" & val(text2.text)
set myrecordset = mydatabase.openrecordset(sql)

now just use the myrecordset object the same as a VB data control.

Remember that if you want to use the recordset outside of this procedure you'll have to publicly declare it at the top of the module or form

Cheers

Chris

[rockies1]

Thank you very much!!

------------------
Morgan
rockies1@gvi.net
My Web Page (http://members.xoom.com/Rockies1)