Search results for query: *

I know this thread goes some way back however if someone out there can help me, I would also like to know what is causing this problem, in my case, if you are actually trying to access a stored query in MSA2000 rather than passing an SQL string from VB6? I am using VB6 sp5, jet4.0 sp3. The code...

Thank you Acquiesce for you response. The query works when opened in Access and when code is run in VB, Rs(0), Rs(1), values etc, can be seen when in debug mode. Have I missed out some settings in the ADO Data Control? Tadez

I am attempting to populate an Adodc1 control on a form after accessing a stored MSAccess2000 query using the following codes; Dim conn As New ADODB.Connection Dim param1 As New ADODB.Parameter Dim Cmd As New ADODB.Command Dim Rs As New ADODB.Recordset ..... Private Sub...

Thanks. I am new and finding my way around a bit confusing. Thanks for the advice and will re-submit in the suggested forum.

Adodc1 is an ADO Data control on a form, hence the reference Me.Adodc1.Recordset. In the VB program I am building, I have named it "adcProdID". The code resides behind a button on the form and when it is pressed, the code should load the required data into a Datagrid binded to the ADO...

I am attempting to populate an Adodc1 after accessing a stored MSAccess2000 query using the following codes; Dim conn As New ADODB.Connection Dim param1 As New ADODB.Parameter Dim Cmd As New ADODB.Command Dim Rs As New ADODB.Recordset ..... Private Sub cmdGetQueryResult_Click() Set Rs = New...