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 TouchToneTommy 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: *

  • Users: chamira
  • Content: Threads
  • Order by date
  1. chamira

    Error Using SQL Statements in ADODC's

    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...
  2. chamira

    How to Create Excel Worksheets Using ADO

    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...
  3. chamira

    Problems Using VB to Transfer Data From Access to 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...
  4. chamira

    Closing an Excel 2000 Workbook Using VB6

    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...

Part and Inventory Search

Back
Top