Do you know any style guide for VB6?
I code with Vb6 everyday using my own convention and i'm starting to feel guilty about that. Do you know any style guides for VB6 like naming convention, code techniques and best practices? ...
vb6
What's the most efficient way for accessing a single record in an ADO recordset?
I want to access individual records in a classic ADO recordset without enumerating over the entire recordset using .MoveNext. I'm aware of using AbsolutePosition as well as .Filter =. What's the best way? More Details: I'm likely going to be accessing the recordset several times pulling out individual records that match a list of reco...
InputBox Cancel
I have created an Inputbox to get the username entered but stuck with the cancel button Private Sub Form_Load() fsUserName = UCase(InputBox("Please Enter your name.", "User Name", _ "dc")) If fsUserName = "" Then MsgBox "No name Entered." & Chr(13) & Chr(13) & _ "You must enter a name.", vbExclamation, "ERROR" Form_Load ElseIf VarType(...
Reading and writing with the same Access '97 table: Thread safety problems?
I am maintaining a program that reads records from a Access '97 table using a Timer. A different program outside my control writes records to this table. So the reading and writing is not synchronized. I am wondering if this could occasionally lead to data corruption. Writing a testing environment is difficult for several reasons. Does s...
VB6 + classic asp: developing activeX component
hi all, i've created a little activeX dll under vb6 which i'm running under classic asp. my question: once the dll is compiled it has write-protection caused by the IIS (access denied). i have to completely stop the webserver, then recompile + restart the server again. is there a more convenient way to do this? maybe even without havi...
How to get the xml attribute values?
Say I have some xml. How to get the attribute value using VB? ...
VB6 Packaging and Organization
Is there any clean way to package VB6 Class Modules, other than writing DLLs or manually adding prefixes to the module names? EDIT: I'm hoping VB6 has something along the lines of packages or namespaces from other languages. ...
VB Mismatch Error
I keep getting a mismatch error for this line: UPDATE tblLunchTime SET [End] = '06/28/2010 9:41:34 AM' WHERE Start = '06/28/2010 9:41:31 AM' Does anyone know why? EDIT: Rest of the code added. 'Save end time in database. Dim strValuesQuery As String strValuesQuery = _ "UPDATE tblLunchTime " & _ "SET [End] = '" & Now & "' " ...
VB6 CallByName woes
I want to do a CallByName for some Subs but I just can't get it to go. Everything goes fine until execution reaches the CallByName, then I have problems: Whenever I use Me, it complains about a compile error And if I use frmMyServer, it says "object or method not supported" Question: How do I do this? This is what I have : in my...
VB 6: How many controls can I have on a single form?
I know the limit for named controls is 254, beyond that you have to use control arrays. But it seems we have hit the limit for arrays too. Any idea what that absolute limit is? ...
SP from SQL Server 2005 is not returning records in recordset (VB6)
SP from SQL Server 2005 is not returning the records in recordSet (VB6) recored return are -1. If access the recors using query and through record set, record set are filling with records. Same connection string is used. I chek properly and there is no issue in code written for command object, then what is the wrong? ...
SP from SQL Server 2005 is not returning records in recordset (VB6)
Thanks dretzlaff17 for replying, I am giveing details.......... SP from SQL Server 2005 is not returning the records in recordSet (VB6) records return are -1. If access the records using query and through record set, record set are filling with records. Same connection string is used. I checked properly and there is no issue in code ...
VB6 Object Comparison
What VB6 method allows two custom objects of the same type (defined in a class module) to be compared to each other? I think there's an equivalent to Java's compareTo method, but I can't find it anywhere. ...
Probing .NET Assembly with Registration Free COM/.NET Interop
We have one assembly that is used by the VB6 executable via COM Interop. This assembly uses other .NET assembly (not available for COM). We have defined a .manifest for our VB6 application, so that we can use the .NET assembly without registration. We also defined a .config for our VB6 application, with probing settings, to look in subdi...
How to populate Crystal Reports with SQL
Since there doesn't seem to be any way to load old VB6 (ActiveReports) reports in .Net, I need to recreate dozens of reports in .Net. I'd like to do this in the least painful way possible. In VB6, the original authors simply did something like this for every report: adoConn.ConnectionString = globalConnectionObject.ConnectionString ad...
Silverlight/VB 6 Integration
VB 6 can host web pages, which means it can also host Silverlight apps. Communication from VB 6 to Silverlight can easily be done via URLs. But is there a way for the Silverlight app to send messages back to VB 6? ...
VB6: what can I do to ensure my application uses specific versions of MS controls and DLLs?
What can I do to ensure my application uses specific versions of MS controls and DLLs? Can I put the correct versions of the DLLs and OCXs in the application directory? ...
C# equivalent of ccDebug in VB6
hi all, I am trying to convert VB6 code to c# and I ran into this code in VB6 #If ccDebug then ... End If. Please help me converting this code or doing this any other way. Thanks ...
VB 6 InteropForms: The file [...] was not registerable as an ActiveX Component
I am working my way through the walk-through and I got as far as trying to load the control into the VB 6 toolbox. I can load the DLL as a reference, but not as an ActiveX Component. When I try I get the message "InteropForms: The file [...] was not registerable as an ActiveX Component.". I can create the control at runtime as a normal...
SQL Server 2005 Stored Procedure Using Table Variable Doesn't Return ResultSet to VB6 App
I have a stored procedure which selects a single field from a single row (based on a conditional statement) and stores it in a local variable. Based on the value of this field I update the same field in the same row of the table (using the same conditional statement). So the procedure first does a select into a local variable and then ...