Clong overflow in VB6
Hi, I'm having an overflow error in VB 6.0 when using the Clong datatype because of really big values. How to overcome this? Is there anything else available higher than the Clong datatype? ...
vb6
aligning the corresponding rows in a recordSet
Hi, I ve two recordsets which have the same primary key: combination of two columns called 'item_no' and 'Order_id'..... Both recordsets have this primary key(combination) and rest other different columns... Now, I want to order the(those) rows in two recordsets such that the position of the records(with same primary key values) should ...
How do I change a DCOM's guid in vb6?
I have a windows service that is instantiating a dcom object with a certain guid A. I need to replace that dcom object with a new version. When I create and compile my replacement dcom object it is created with a guid B. How do I change the replacement dcom object's guid from guid B to guidA? ...
GetObject and VB6 ActiveX exe
The VB6 help on GetObject says "You can't use GetObject to obtain a reference to a class created with Visual Basic" (the very last sentence!). My VB6 GUI exposes objects as an ActiveX exe, for other components to manipulate. I want the other components to connect to the GUI that's already running, rather than start a new instance of the ...
Visual Basic 6 data structures
What are all the build in data structures for VB6 (Microsoft Access) ? I know there are arrays, but are there other more modern data structures? ...
MSBuild ASP.NET VB6 DLL Interop
We have a C# ASP.NET 3.5 project with VS 2008. We also have a VB6 DLL that we call via Interop (yuck...I know). We use a Web Deployment project with MsBuild and run a batch file to build the project on a build machine. My question is: Is there a way to modify the MSBuild project to have the VB6 DLL and interop files created and moved...
Non realbasic ActiveX controls in Realbasic projects
Realbasic allows you to include e.g an MS Flexgrid control in your Realbasic project and use it as though it were a native control. Does the end user need to have this control installed already and if not and realbasic includes it in the build are there licensing issues? I have vb6 and can distribute this control legally with a vb6 appli...
Can I do this in .Net and WPF?
Hi, We have a third party app that has VBA integrated into it. This all allow us to open a vb6 activeX Dll that contains a UI and we pass the apps instance to the vb6 dll. ' Instantiate the SMTree UI. Set oSMTree = CreateObject("SMTree.clsMain") ' Start it up. oSMTree.cMain Application Then in the VB6 app the main looks like: Publi...
Free VB6/VBA profiler and best Excel practices
We have a lot of reports that are generated via VBA & Excel. Only a small percentage of the reports are actual calculations - the majority of the work is sql calls and formatting/writing of cells. The longest of which takes several hours, the majority takes around 20-30 mins each. The VBA/Excel code plugs into a dll that the VB6 deskt...
How to SQL insert a raw/Binary field value from bytes/integer array using VBScript (orVB6)?
Does anyone know how to pass a several bytes into a Binary (or varbinary) field using SQL and ideally in ADO (classic) & VBScript (or Visual Basic 6)? I wish to encode 10-20 (maybe more) bytes of data and have this data stored in a SQL db field. (Its not MS-SQLSVR, but I'm hoping that a standard SQL supported format will work!) The byt...
How to set the InitDir property of a CommonDialog control to My Computer
My Google-Fu is weak today, hopefully this is a simple thing. I need to set the InitDir property of a VB6 CommonDialog control to start at [My] Computer. If I set InitDir to an empty string, it just defaults to the current directory from the last open dialog. My code: With MyCommonDialogControl .DialogTitle = "Choose Import File"...
What do the logical functions IMP and EQV do in VB6? Has anyone found a real world use for them?
AND, OR, XOR and NOT I understand. What I don't get are IMP and EQV. What do they mean? How'd they get in there? Is there any real use for them? ...
Log Parser Early Binding
Is it possible to use early binding with LogParser.dll on VB6/VBA? When I try to set a reference to it, it just disappears with no error. ...
How do I declare MAX_DOUBLE in VB6?
According to the MSDN help for VB6 Floating-point values can be expressed as mmmEeee or mmmDeee, in which mmm is the mantissa and eee is the exponent (a power of 10). The highest positive value of a Single data type is 3.402823E+38, or 3.4 times 10 to the 38th power; the highest positive value of a Double data type is 1.7976931348623...
Conversion of VB6 HTTP request to VB.Net 2.0
I'm attempting to update a legacy VB6 component (not written by me) to the .NET platform. There is one function which posts an XML string to a URL: Function PostToUrl(ByRef psUrl, ByRef psData, Byref psResponseText, ByRef psErrorMsg, ByRef psUsername, ByRef psPassword) On Error Resume Next Dim objWinHTTP PostToUrl = False psError...
How to call a com+ component?
Hi, I'm making some archeology, dealing with COM+ I managed to enlist a simple COM dll as a COM+ component, so far so good. So I've got this 'foobar' com+ component, with it's interface, and the method I'd like to call. My question is then rally simple: how am I supposed to make a call to this component? Any .NET or VB6 answer is ac...
Drawing an arrow on a line object in VB6
Using VB6, i have a line object that can be dragged around at its end points by the user, and i'd simply like an arrow in the middle of it to show the direction of the line. Is there a simple way to do this? ...
ODBC Command does not throw error
I'm working on a VB6 executable that uses ODBC to update a DB2 Table. When trying to update a row that does not exist the program does not throw an error as would be expected. Why would this happen? objAdoConn.Execute("Update T1234 Set A = 'X' Where B = 'y'"); ...
In VB6, how do I call a COM object requiring a pointer to an object?
Hi, I'm having trouble with a .NET Assembly that is com visible, and calling certain methods from VB6. What I have found is that if the parameters are well defined types, (e.g. string), calls work fine. If they are higher level objects, it raises a runtime error '438' suggesting that the property or method is not present. I suspect tha...
VB6 .NET interop issue in Vista
I wrote an assembly in C# and I needed to invoke a method on the DLL from a VB6.0 application. I made the DLL COM compliant and registered the DLL accordingly. From my VB application I would then instantiate the class in the .NET assembly using the VB6.0 CreateObject method. Set dotNetObj = CreateObject("Namespace.ClassName") I would ...