Recent content by CodeFish

vb6novice, To Create an ADO Connection to an Access DB there a many variations but a couple you can use are:- Dim oConn As ADODB.Connection 'Instantiate Connection Object Set oConn = New ADODB.Connection oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data...

vb6novice, Looking at some code I did some time ago has now shown me how to duplicate this error that I saw so Frequently. CCLNT is quite right that its not the password which is what I first thought of but an error in the connection string:- A connection string with DATA SOURCE spelt...

The error message "Couldn't find installable ISAM" often occurs on Access databases with passwords. Does the Access DB you are trying to open have a password? If so, do you include "Jet OLEDB:Database Password=" in the ADO connection string? Codefish

You Need to Enable "Initialiase and Script ActiveX Controls Not Marked as Safe" in your IE Security Settings. Tools >> Internet Options >> Security Codefish

Also try Windows Update for various fixes for VB

rodin, If you are creating an Object in ASP then the Server requires Word to be installed on it. Its my guess from the error message that its not installed. The Browser settings are irrelevant. OR/ If the code is within Script tags i.e. running on the Client and NOT ASP then you need to...

Why not use the Split Function (VB6):- StringOccurs = UBound(Split("1239821938127", "1")) Codefish

Oops, forgot that the Browser will render the HTML replacements. The Replace lines should use the following:- amp, lt, gt, apos, quot respectively. Codefish

pankajv, The Function I use is:- Public Function XMLFormat(sFieldData As Variant) As Variant '---------------------------------------------------------- ' Author: Codefish ' ' Date: 15/8/2001 ' ' History: ' ' Purpose: - Replaces Illegal Characters for their '...

lash, Create a Disconnected Recordset from your SQL database with code like below:- 'Declare Local Objects Dim oRec As ADODB.Recordset Dim oConn As ADODB.Connection 'Instantiate Objects Set oRec = New ADODB.Recordset Set oConn = New ADODB.Connection 'Open Connection oConn.Open...

fugly, Make sure ALL Object References have also been released. Regards, Codefish

Hi PFairhurst, You need to add some code to dsi's post to deal with Excel 7(95) bugs. An Open Version of Excel 7 doesn't get placed into the Running Object Table (ROT) by default, thus GetObject will not detect it until you have registered it to the ROT yourself see the Microsoft Articles...

Yes it is popssible see an example below:- NB/ Mortgages Table is in SQL Database Called Mortgages Companies Table is in SQL Database Called Misc View Created in Mortgages Database Code: CREATE VIEW dbo.[VW_Mortgages] AS /* Add Company Name to View - Standardised Display Name for Company*/...

Hi ror, I've used XML DOM in VB. Check out:-http://www.topxml.com/xml/articles/dom_xml_prog/Contents.asp Codefish

I read somewhere the Round Function behaves like it does by design. The reason being is to preserve the 'mean' when calculating it for groups of numbers. thread222-318384 Codefish