I need to write a program that can sift through specially-formatted text files (essentially CSV files with a fixed set of column types that have different delimiters for some columns ... comma in most places, colons in others) to search for formatting errors. I figure regular expressions will be the way to go. The question: Is there a...
I am working in Visual Basic 6 and need to sort by multiple columns in a ListView. For example, sorting a list of music tracks by artist, then album, then track number. As far as I know, VB6 does not support this out of the box. Here are the suggestions I have already heard: Sort the data in a SQL table first and display the data in...
Friend of mine has a problem :). There is an application written in Visual Basic 6.0 (not by him). One of users reported that when it run on Windows 2000 and tried to scan folders on disk it raised box with message: Run-time error 1012 Error accessing application data directories We couldn't google anything about it and didn't find a...
How can you obtain the Type (the name as a string is sufficient) of an Object in VB6 at runtime? i.e. something like: If Typeof(foobar) = "CommandButton" Then ... /EDIT: to clarify, I need to check on Dynamically Typed objects. An example: Dim y As Object Set y = CreateObject("SomeType") Debug.Print( <The type name of> y) Where...
In particular, for the logical operators ...
I've got an old, legacy VB6 application that uses the DHTML editing control as an HTML editor. The Microsoft DHTML editing control, a.k.a. DHTMLEd, is probably nothing more than an IE control using IE's own native editing capability internally. I'd like to modify the app to implement smart quotes like Word. Specifically, " is replaced w...
I'm testing the VB function below that I got from a Google search. I plan to use it to generate hash codes for quick string comparison. However, there are occasions in which two different strings have the same hash code. For example, these strings "122Gen 1 heap size (.NET CLR Memory w3wp):mccsmtpteweb025.20833333333333E-02" "122Gen 2...
Has anybody attempted to pass a VBA (or VB6) function (via AddressOf ?) to the SQLite create a UDF function (http://www.sqlite.org/c3ref/create_function.html). How would the resulting callback arguments be handled by VBA? The function to be called would have the following signature... void (*xFunc)(sqlite3_context*,int,sqlite3_value...
Having spent time on Reddit and (gasp) Digg, I hear a lot of trash-talk on .NET and MS products, and a lot of interesting talk about other languages. As a (second gasp) Project Manager at a small software company utilizing VB/.NET extensively, I'm not sure what's so bad about it. Can someone tell me where it falls short, what would b...
This is an antique problem with VB6 DLL and COM objects but I still face it day to day. What is the best tool to see which DLL file or version another DLL is referencing to? Of course, this is from the OS point of view - compiled DLLs not from within VB6 IDE. It's DLL hell. ...
How do I declare "as any" in VB.NET, or what is the equivalent? ...
I have a method in .NET (C#) which returns string[][]. When using RegAsm or TlbExp (from the .NET 2.0 SDK) to create a COM type library for the containing assembly, I get the following warning: WARNING: There is no marshaling support for nested arrays. This warning results in the method in question not being exported into the gener...
In a VB6 application, I have a Dictionary whose keys are Strings and values are instances of a custom class. If I call RemoveAll() on the Dictionary, will it first free the custom objects? Or do I explicitly need to do this myself? Dim d as Scripting.Dictionary d("a") = New clsCustom d("b") = New clsCustom ' Are these two lines nece...
In how many languages is Null not equal to anything not even Null? ...
I've read in a couple of places that the desktop wallpaper can be set to an HTML document. Has anyone had any success changing it programmatically? The following snippet of VB6 helps me set things up for BMPs but when I try to use it for HTML, I get a nice blue background and nothing else. Dim reg As New StdRegistry Public Function C...
I can make a DAO recordset in VB6/Access do anything - add data, clean data, move data, get data dressed in the morning and take it to school. But I don't even know where to start in .NET. I'm not having any problems retrieving data from the database, but what do real people do when they need to edit data and put it back? What's the e...
Suppose I have a class module clsMyClass with an object as a member variable. Listed below are two complete implementations of this very simple class. Implementation 1: Dim oObj As New clsObject Implementation 2: Dim oObj As clsObject Private Sub Class_Initialize() Set oObj = New clsObject End Sub Private Sub Class_Terminate(...
I'm receiving feedback from a developer that "The only way visual basic (6) can deal with a UNC path is to map it to a drive." Is this accurate? And, if so, what's the underlying issue and are there any alternatives other than a mapped drive? ...
Need a function that takes a character as a parameter and returns true if it is a letter. ...
We are getting an error in a VB6 application that sends data back and forth over TCP sockets. We get a runtime error "out of string space". Has anyone seen this or have any thoughts on why this would happen? It seems like we are hitting some VB6 threshhold so any other thoughts would be helpful as well. thks, ak ...