Search results for query: *

Thanks, I thought that you could bind the datagrid directly to a recordset created in code. The advice you gave worked. Many Thanks.

Hi, I'm having some problems binding a DataGrid control to a ADODB.RecordSet. Here's my code: Private Sub Form_Load() Dim dbConnection As New ADODB.Connection Set rsResults = New ADODB.Recordset strQuery = "SELECT * FROM tblCategory INNER JOIN tblInventory ON...

I having problems seting the Report.DataSource to a ADODB.RS at runtime. I've created a new Blank report using Application.NewReport and am trying to set the datasource to a ADODB.RS. It gives me a subscript out of range error. here is my code: Dim dbConnection As New ADODB.Connection...

2 suggestions. Make sure the path to the database is correct and make sure you have the latest CR database drivers.

I'm trying to create a vb app which dynamically creates a report. The user is able to select desired fields from a database at runtime to add to a report. Is there anyway to adding fields at runtime to a report? Or any othe way to accomplish this goal? Many Thanks.

Thanks for the help! It worked.

Thanks for the reply. Couple of questions though. It looks like the code fills in the combo box and listview with the table & column names. But not sure if or how the code retrieves the table names and column names from the database. Also not sure what the dbEditor is. It looks like this...

I'm trying to create a vb app that allows a user to specify an Access dbase at runtime and to select the desired fields (and tables) to add to a report. How do you look up the available tables and columns in an Access dbase with code or sql?