After hours of effort, system restore, register, unregister cycles and a night’s sleep I have managed to pinpoint the problem. It turns out that the project file contains the below line: Object={831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0; MSCOMCTL.OCX The version information “2.0” it seems was the reason of not loading. Changing it to “2.1” in notepad solved the problem: Object={831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.1#0; … Read more
After months of research I’ve come up with this. Public Function PrettyPrintXML(XML As String) As String Dim Reader As New SAXXMLReader60 Dim Writer As New MXXMLWriter60 Writer.indent = True Writer.standalone = False Writer.omitXMLDeclaration = False Writer.encoding = “utf-8” Set Reader.contentHandler = Writer Set Reader.dtdHandler = Writer Set Reader.errorHandler = Writer Call Reader.putProperty(“http://xml.org/sax/properties/declaration-handler”, _ Writer) Call … Read more
First of all, go get MZTools for Visual Basic 6, its free and invaluable. Second add a custom error handler on every function (yes, every function). The error handler we use looks something like this: On Error GoTo {PROCEDURE_NAME}_Error {PROCEDURE_BODY} On Error GoTo 0 Exit {PROCEDURE_TYPE} {PROCEDURE_NAME}_Error: LogError “Error ” & Err.Number & ” (” … Read more
Contrary to what others have said, it IS possible to get run-time type information for UDT’s in VB6 (although it is not a built-in language feature). Microsoft’s TypeLib Information Object Library (tlbinf32.dll) allows you to programmatically inspect COM type information at run-time. You should already have this component if you have Visual Studio installed: to … Read more
You can use “” to insert a quote into a string e.g: dim sometext as String = “Hello “”Frank”” how are you?” Which gives you Hello “Frank” how are you?
There are a number of special folders you can use, on XP/Vista/Windows 7: The CSIDL_APPDATA folder is the one you will likely be most interested in. Data stored here is available to roaming users at whatever machine they log in to. This is the best place to store simple configuration data. All users have write … Read more
Value is the default property of the Field object, so in VB6 there is no difference between rs(“bookingdate”) and rs(“bookingdate”).value when used without Set. I personally prefer not using default properties that don’t take parameters. It makes the code less confusing IMO. In VB.NET the default property must have a parameter, so this situation does … Read more
Depending on your situation adding #If False Then Dim CorrectCase #End If might help.
You may also want to try setting up Reg-Free COM for your project. There’s a freeware called Unattended Make My Manifest that will do most of the work for you.
Speaking from experience (I run VB6 almost every day in Windows 7 – 64 bit), there is no problem getting it running, in fact you do not have to run it in any kind of compatability mode. There are a couple of Caveats though: Use the installer from a recent (within 5 years) version of … Read more