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?
Re: this is DAO, is that possible to do something like this 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
Re: this is DAO, is that possible to do something like this in ADODB?
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?