Search results for query: *

...End With Now you have created the Connection Object you can create an ADO Recordset. Dim oRec As ADODB.Recordset 'Instantiate ADO Recordset Object Set oRec = New ADODB.Recordset 'Create Recordset oRec.Open "SELECT * FROM TABLE1", oConn, 3, 3 Codefish

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

...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*/ SELECT MISC..[Companies].CompanyTitle, Mortgages.Rate .... /* Table Join:*/...

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

One other point to mention is when designing classes for COM components, for use in Web Applications, you would prefer the 1st method. This is because it only makes one server call as apposed to multiple server calls if you had Class Properties like in the second method. Secondly if you...

Hi bradshaw, Try this Code: In a Module place:- 'Windows 95,98 'Declare Function sndPlaySoundA Lib "c:\WINDOWS\SYSTEM\WINMM.DLL" (ByVal lpszSoundName$, ByVal ValueFlags As Long) As Long 'Windows 2000, NT 'Declare Function sndPlaySoundA Lib "C:\WINNT\system32\WINMM.DLL&quot...

Hi All, The reason for Property procedures are for enabling encapsulation of code. Use property procedures when: The property is read-only, or cannot be changed once it has been set. The property has a defined set of values or needs to be validated. Values outside a certain range — for...

Hi ayyapps, I use the Registry Access Functions Library (RegObj.dll) to do an EXE Application Search:- Public Function AppExists(sAppExe As String) As Boolean '---------------------------------------------------------- ' Author: Codefish ' ' Date: 22/05/2000 ' ' History: ' '...

Hi devnull69, If you Try:- Round(1.135, 2) you will get 1.14 This is because Microsft's Round Function Rounds Up for ODD Numbers (1.13) and Rounds Down for EVEN Numbers (1.12) in this Scenario. I believe its done be design to preserve the mean (average) when Round is applied to a collection...