Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Pranali

    Passing Parameters to access subquery

    Hi, I have Qry1 which executes qry2 which in trun runs qry3.Now qry3 accepts 2 parameters.StartDate and EndDate to filter records from the database.How can I pass parameters to qry3 from Visual basic.I know how to pass it to qry1 but npt qry3. Please reply ASAP. Thanks, Pranali.
  2. Pranali

    Visual Basic and MTS

    Thanks a lot...It helped me a lot. I also tried using Disconnected recordset and its working fine.But I am also going to try XML strings... I changed the function from Public Function GetCriteria(ByVal strsql As String) As ADODB.RECORDSET to Public Function GetCriteria(ByVal strsql As...
  3. Pranali

    Visual Basic and MTS

    Thank You very much Chiph. Can you point me to an example of converting Recordset to XML string and string to Recordset. Thanks Again Pranali.
  4. Pranali

    Visual Basic and MTS

    This is my Com component cCriteria Option Explicit 'Implements iCriteria Private cn As ADODB.Connection Public Function GetCriteria(BYVAL strsql As String) As ADODB.Recordset On Error GoTo PROC_ERR Dim rs As ADODB.Recordset Dim cmd As ADODB.Command cn.CursorLocation =...

Part and Inventory Search

Back
Top