http://www.songhaysystem.com/kb/subject/vb6 The Funky Knowledge Base at songhaysystem.com. The subject of this channel is Visual Studio 6.0. Tue, 24 Jul 2001 01:37:36 GMT http://songhaysystem.com/kb/number/2076071409/subject/vb6 Article Excerpt: If you should ever have the misfortune of opening an Access database from ADO you will run into problems that Microsoft recognizes as bugs and has even released fixes in response to them. The main problem is trying to use the LIKE predicate and wildcard c… Tue, 24 Jul 2001 01:37:36 GMT Bryan Wilhite http://songhaysystem.com/kb/number/2076071358/subject/vb6 Article Excerpt: One way to prevent "operand type clash" errors is to use a two-dimensional parameter array to pass parameters to the stored procedure. The stored procedure parameters should have default values (most likely NULL). Sun, 07 Jan 2001 20:25:33 GMT Bryan Wilhite http://songhaysystem.com/kb/number/2076071304/subject/vb6 Article Excerpt: Icons: C:\Program Files\Microsoft Visual Studio\VIntDev98\bin\vidisws.dll Confirm open after download Action > open Application used to perform action: "C:\Program Files\Microsoft Visual Studio\Common\IDE\IDE98\devenv.exe" "%1" Use DDE DDE Message: Op… Tue, 15 Aug 2000 07:28:00 GMT Bryan Wilhite http://songhaysystem.com/kb/number/745182366/subject/vb6 Article Excerpt: 'Since I am very untrusting of VB 6 Web Classes, 'I start IIS Applications with an ActiveX DLL Project. 'I have one Class (called WebApp) 'that talks directly to the server 'and the other Classes support the WebApp Class. 'This is the code that builds We… Wed, 12 Apr 2000 05:55:17 GMT Bryan Wilhite http://songhaysystem.com/kb/number/922575080/subject/vb6 Article Excerpt: When you are certain that your DLLs for your reference are installed (because, perhaps, you properly used REGSVR32.EXE) but they still show up as "MISSING..." in Project > References... list, try editing the .VBP file associated with the project. Close … Fri, 11 Feb 2000 07:36:04 GMT Bryan Wilhite http://songhaysystem.com/kb/number/566367175/subject/vb6 Article Excerpt: I use the Properties Collection of the Connection object to enter custom log information during a database connection. For example the sub LogSession is called (repeatedly) during the ConnectComplete Event: Private Sub pADOcnn_ConnectComplete(ByVal pErro… Thu, 10 Feb 2000 06:51:03 GMT Bryan Wilhite http://songhaysystem.com/kb/number/-1683864580/subject/vb6 Article Excerpt: In the same manner we can intercept certain error numbers for VBA errors we can do the same for ADO "data" errors. The trick is finding a list of the numbers. MS KB article Q168354 ("INFO: Underlying OLE and OLEDB Provider Errors Exposed via ADO") provide… Thu, 10 Feb 2000 06:52:09 GMT Bryan Wilhite http://songhaysystem.com/kb/number/932862797/subject/vb6 Article Excerpt: I can only see using an Asynchronous connection when implementing ADO for a desktop solution. For a stateless IIS Application there is no waiting. It seems very linear to me: get in and get out. For more information regarding this matter please see MS KB … Thu, 10 Feb 2000 06:54:30 GMT Bryan Wilhite http://songhaysystem.com/kb/number/950068669/subject/vb6 Article Excerpt: The New Keyword Use the New keyword to create objects associated with a Type Library. In short, if the VB Object Browser can show your object's classes and members then this object is associated with a Type Library. So, for example, Excel.Application is … Wed, 09 Feb 2000 03:59:50 GMT Bryan Wilhite http://songhaysystem.com/kb/number/-2025630760/subject/vb6 Article Excerpt: The Filter Property DAO Recordset objects have the Filter Property. I did not start using it until I started using ADO. Just a coincidence. I mention here for historical reasons. It's my history. Moving right along... Calling Stored Procedures with ODB… Fri, 04 Feb 2000 07:39:10 GMT Bryan Wilhite http://songhaysystem.com/kb/number/1746370806/subject/vb6 Article Excerpt: So far I am aware of and/or care about three ways of building IIS Applications. Each of these designs has an increasing dependency on COM objects (e.g. DLLs). The message here is, Choose a design that best fits your ability to make your own COM objects. … Wed, 02 Feb 2000 08:35:37 GMT Bryan Wilhite http://songhaysystem.com/kb/number/157075603/subject/vb6 Article Excerpt: Use vbNullString instead. Wed, 02 Feb 2000 08:27:49 GMT Bryan Wilhite http://songhaysystem.com/kb/number/927229048/subject/vb6 Article Excerpt: The version of VBA that comes with Visual Studio 6.0 has the Round() function. Previously rounding numbers was done with the Format() (or Format$()) function which produce non-numeric values. The Round() function returns numeric values. Fri, 21 May 1999 03:40:53 GMT Bryan Wilhite http://songhaysystem.com/kb/number/924941775/subject/vb6 Article Excerpt: Private Sub cmdFieldOrder_Click(Index As Integer) ' 'This sub responds to the click event of 'a two-button control array called cmdFieldOrder. 'It manipulates the items in the List Box lstFields. ' Dim strList As String Dim int… Sat, 24 Apr 1999 16:19:42 GMT Bryan Wilhite http://songhaysystem.com/kb/number/1779889301/subject/vb6 Article Excerpt: Public Sub basPopTV(tv As MSComctlLib.TreeView) ' 'This sub demonstrates the "hard code" way of 'populating a Microsoft TreeView Control. ' With tv .LabelEdit = tvwAutomatic .Style = tvwTreelinesPlusMinusText .L… Sat, 24 Apr 1999 16:59:42 GMT Bryan Wilhite http://songhaysystem.com/kb/number/924987497/subject/vb6 Article Excerpt: Public Sub basPopLstBox(ByRef LstBox As ListBox, _ ByVal vArrayOrCollection As Variant) ' 'This sub takes the Items in a Collection (or the 'elements in an array) and adds them to a ListBox 'control. Of course we assume that vArrayOrCo… Sun, 25 Apr 1999 05:01:59 GMT Bryan Wilhite http://songhaysystem.com/kb/number/1890260836/subject/vb6 Article Excerpt: Private Sub dgFields_Error(ByVal DataError As Integer, _ Response As Integer) ' 'This sub attemps to summarize the errors of the 'MS DataGrid Control. On many errors it simply reports 'that "Errors have ocurred." This sub is an attmept to … Sun, 25 Apr 1999 05:27:15 GMT Bryan Wilhite http://songhaysystem.com/kb/number/-93314486/subject/vb6 Article Excerpt: Crystal Web Reporting services have proven themselves to be somewhat "ok" in my Visual InterDev Solutions. My design uses an MTS package that provides data services to pass recordsets to Crystal Report objects. These objects are passed via very expensive … Fri, 23 Apr 1999 03:48:30 GMT Bryan Wilhite http://songhaysystem.com/kb/number/924809741/subject/vb6 Article Excerpt: Private Sub Form_Unload(Cancel As Integer) ' 'This sub makes sure the user really wants to quit. 'Note the use of the ProductName Property 'of the App object of the VB Library. ' Cancel = (VBA.MsgBox("Ar… Fri, 23 Apr 1999 03:40:49 GMT Bryan Wilhite http://songhaysystem.com/kb/number/907007523/subject/vb6 Article Excerpt: Internet Information Server Applications in VB6 is an "alternative" to Visual Interdev. Use relative paths; Deployment Wizard "sucks"; avoid the Session object and wcRetainInstance; use POST not GET; use generated URLs; do not store ADO Recorsets in Sessi… Thu, 22 Apr 1999 03:54:26 GMT Bryan Wilhite http://songhaysystem.com/kb/number/915821693/subject/vb6 Article Excerpt: From the Active Desktop by Internet Explorer 4.x-based systems, choose View > Folder Options > File Types > Edit... > Actions: > New... > New Action: Action: Edit with Visual Studio Application used to perform action: "C:\Program Files\Mic… Thu, 22 Apr 1999 03:56:21 GMT Bryan Wilhite http://songhaysystem.com/kb/number/91093392/subject/vb6 Article Excerpt: 'The following has been replaced with the StartUpPosition 'property where StartUpPosition = vbCenter can 'be set at design time or runtime: Public Sub basFrmCenter(ByRef Frm As Form) With Frm .Move (Screen.Width - .Width) / 2, _ … Sun, 04 Apr 1999 07:21:15 GMT Bryan Wilhite http://songhaysystem.com/kb/number/908495718/subject/vb6 Article Excerpt: ADO Objects are not found in a hierarchy; they logically lie side by side. For example, the Command, Connection and Recordset objects can open a connection to a database. It is up to the programmer to decide the "best" way to open the connection. There i… Sat, 27 Mar 1999 02:53:20 GMT Bryan Wilhite http://songhaysystem.com/kb/number/920325028/subject/vb6 Article Excerpt: In the rare case of a hard core VB Progammer actually having respect for the W3C's recommendations and publications, such a person will want to avoid the CSS GUI editor provided by Visual Interdev 6.0. It is useful to have the CSS files in InterDev Solut… Mon, 01 Mar 1999 22:08:05 GMT Bryan Wilhite http://songhaysystem.com/kb/number/907000936/subject/vb6 Article Excerpt: The ADO Data Control promises to actually be useful in VB 6.0. The control can connect to a database and retrieve or modify data without code. The control only needs ConnectionString and RecordSource properties specified to run. Several VB controls are "… Mon, 01 Mar 1999 21:48:06 GMT Bryan Wilhite http://songhaysystem.com/kb/number/715694788/subject/vb6 Article Excerpt: Public Function basGetString(KeyName As String, ColumnName As String) As String On Error GoTo basGetString_Err Set m_rsADO = New ADODB.Recordset m_rsADO.Open Source:="tblStrings", _ ActiveConnection:=m_cnnADO, _ Curso… Mon, 01 Mar 1999 21:35:47 GMT Bryan Wilhite http://songhaysystem.com/kb/number/910209711/subject/vb6 Article Excerpt: Public Function basDataConnection(Optional CloseConn = False) As Boolean On Error GoTo basDataConnection_Err If VBA.VarType(CloseConn) <> vbBoolean Then VBA.Err.Raise 450 If CloseConn Then If Not m_cnnADO Is Nothing Then… Mon, 01 Mar 1999 21:35:15 GMT Bryan Wilhite http://songhaysystem.com/kb/number/-1109101906/subject/vb6 Article Excerpt: Suppose that the form frmDialog is meant to be a custom dialog that is called from code. The form takes values (like a user name and a password) and returns them to the calling procedure. The problem is the calling procedure does not "wait" for the values… Mon, 01 Mar 1999 21:47:08 GMT Bryan Wilhite http://songhaysystem.com/kb/number/910298753/subject/vb6 Article Excerpt: Private Sub fsDevice_Change() 'fsDevice is the DriveListBox. 'fsRoot is the DirListBox. 'fsFile is the FileListBox. With Me .fsRoot.Path = fsDevice.List(.fsDevice.ListIndex) .fsFile.Path = .fsRoot.Path End With End Sub … Mon, 01 Mar 1999 21:47:44 GMT Bryan Wilhite