Search results for query: *

Hi Doug, thanks for your reply. I did try changing the single quotes to double quotes, but that didn't work. However, I was able to solve the problem. The problem was in the sql statement - I had to specify the table name in the WHERE clause: RecordSource: SELECT * FROM Customers WHERE...

I am trying to display data from an Access database using ADO Data Controls and the DataCombo + DataGrid controls. In the ADODC properties box, I setup up the following: ConnectionString: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\anyDB.mdb; RecordSource: SELECT * FROM Customers WHERE...

Does anyone know how to set the number of worksheets in an Excel spreadsheet after connecting to it using ADO. This is how I've setup the connection: Dim xlConn As New ADODB.Connection xlConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\anyFile.xls;Extended Properties=Excel...

I'm using VB to extract data from an Access database and create a spreadsheet using that data. I wrote the code and tried to run it. It starts to extract the data, but about half way through, it stalls. I have to press Ctrl+Alt+Del to quit out of it, and it stalls all my other programs that I'm...

Thanks for your help! I tried it again, and the reason it wasn´t working before was that I had the code for closing the connection in a different procedure, which for some reason wasn´t being called. I had them in the Form_Unload procedure, but for some reason, it doesn´t run when I click on...

I'm trying to manipulate Excel 2000 workbooks using little executables I'm creating in VB6. I can open, manipulate and save the spreadsheets with out any problems, but I cannot seem to close Excel, even after I've written the code to close out of Excel. I know this because when I press...