Query Filter Problem

[nirdle_phogi]

---

Mga bro, unsa man codes paghimo ug criteria or kana bang "filtering" sa VB ngad2 sa MSAccess Database (Access 97 Format) ?

Hehe. Thesis jud na namo.. Tagam kay pa-tuga ug skuwela programming dili man diay kabalo.. Waaaahahaha

[spookey]

bro, can you simplify your question further?

[spikes]

you can use SQL aron makuha ka og data from you database which is access.

[ComputerTech]

Mga bro, unsa man codes paghimo ug criteria or kana bang "filtering" sa VB ngad2 sa MSAccess Database (Access 97 Format) ?
Hehe. Thesis jud na namo.. Tagam kay pa-tuga ug skuwela programming dili man diay kabalo.. Waaaahahaha

i think you need to set up a connectionstring from vb to access. there are tons of examples found @ www.planetsourcecode.com just query the ADO examples. Im assuming ur using vb6 as ur front-end and access as ur back-end. ayt

[Seducer]

Please see below....I hope you can get something....


Public Server_Connect As String
Public ConnectString As String
Public RecSet As New ADODB.Recordset
Public ConnectMe As New ADODB.Connection

private sub connectdata

Server_Connect = "Provider=MSDASQL.1;Persist Security Info=False;Data Source="
Server_Connect=Server_Connect+"YOURDATABASE"
Server_Connect=Server_Connect+";User ID=MY_USER_ID"
Server_Connect=Server_Connect+";Password=MY_USER_P ASSWORD"
Server_Connect=Server_Connect+";Data Source=MYDATASOURCE"

If ConnectMe.State = 1 Then ConnectMe.Close

ConnectMe.Open Server_Connect

Set RecSet = ConnectMe.Execute("SELECT * from YOURTABBLE where COLUMNTOBEFILLTER='" & mm & "'")

if not RecSet.EOF then

.
.
. Put your code here if you need
.
.

end if

set RecSet=nothing

end sub