hi,
check out parameter passing.
Printable View
hi,
check out parameter passing.
In your VB Program do something like this...
sSql = "your query here"
Set Cn = CreateObject("ADODB.Connection")
Cn.CommandTimeout = 0
Cn.ConnectionTimeout = 0
Cn.Open sCon
Set Rst = CreateObject("ADODB.Recordset")
Rst.CursorLocation = adUseClient
Rst.Open sSql, Cn, adOpenStatic
Set DReport.DataSource = Rst
DReport.Sections("Section1").Controls("txtVOIDED").DataField = "VOIDED"
DReport.Sections("Section1").Controls("txtVENDORID").DataField = "VENDORID"
DReport.Sections("Section1").Controls("txtDOCNUMBR").DataField = "DOCNUMBR"
DReport.Sections("Section1").Controls("txtDOCAMNT").DataField = "DOCAMNT"
DReport.Sections("Section1").Controls("txtVCHRNMBR").DataField = "VCHRNMBR"
DReport.Show
'''And then on the DReport "Properties" change the DataSource to...."Rst" ''''
Any other questions please let me know!!!
:D