Search results for query: *

This is an example of executing a SP using DAO. Cheers Manish Sub DirectionX() Dim wrkMain As Workspace Dim conMain As Connection Dim qdfTemp As QueryDef Dim rstTemp As Recordset Dim strSQL As String Dim intLoop As Integer ' Create ODBC workspace and open a...

I would n't remember it completely now. There are two ways that I had tried. May not be the best, but worked. (1) There is an exe called "Kill.exe" available from Micorosoft. Just pass the Process ID (available in the Task Manager) or the Window Text (Form.Caption) , and that process...

CCLINT, My apologies, when I said ADO, I mean 'Jet.OLEDB'. I am using exactly the same connection string that you have posted. I would post the message again with bit more information. Please feel free to point out the areas the information is not clear enough. I have a big spreadsheet and I...

I remember I had used sndPlaySound() Wind32 API to play wave sound files in VB. It worked well and is very simple to use. Cheers Manish

I have a big spreadsheet and I have written some VB code that reads the spreadsheet using ADO. The range that I am reading, has numeric values. The cells in the first row have Numeric Format and the rest of the cells in the second row onwards, have a Custom Format of '[=0]"";0'...