this is DAO, is that possible to do something like this in ADODB?

VB Code:

Dim qd As DAO.querydef
 
Set qd = CurrentDb.querydefs("yourquerynamehere")
qd.SQL = "selec t* from tblorders where tblorders.orderdate between '" & Me.begindate & "' and '" & Me.enddate & "'"
 
qd.close

like above code, is that possible to do something like that in ADODB?

almost identical, there are a few differences, connecting to the data base is a bit different, but you can do just about all the same things, just slightly different code

see this thread for more info

pete

oh man, perhaps i have present the problem stupidly :(

if u check the code above, the guy is modifying the QUERY which is already inside the MS ACCESS QUERY.

he picks the QUERY and modify the QUERY SQL statement,
so, how could i do something like this inside ADODB?