vb6

Is there a way to force the VB6 IDE to unload libraries?

When debugging a VB6 application, I have noticed that the VB6 IDE keeps any libraries loaded if they were used by the application being debugged. The library remains loaded between debugging sessions. This interferes with my debugging because unfortunately, one of our libraries (written in delphi) keeps state around in global variables a...

How to give string value in the query?

Using VB6 and Access 2003 Query Select Temp.* into NewTable from Temp Table Name storing in Stroutput as a string. Tried Query. Select Temp.* into ‘ ” & Stroutput & “ ’ from Temp From the above query am getting error in ‘ ” & Stroutput & “ ’. When i give temptable instead of ‘ ” & Stroutput & “ ’ is working. How to give a strin...

How to create a Setter/Getter of UserControl in VB6?

For an unknown reason, VB6 doesn't interact the same way with UserControl than other object. I have a class that require to hold a graphical interface, a user control and need to be set to be later used from the get method. I have try many thing like using the special class VBControlExtender but without any success. Here is what I have...

Error handler naming

Is there a best practice for naming the error handling section? How about the resume label? I use "ErrorHandler:" and "ProcExit:". Thanks. ...

How to get a total time?

Using VB6 and MS Access Table: ID Lunch_Intime, Lunch_Outtime 001 13:00:00 14:00:00 002 12:00:00 13:00:00 003 12:00:00 15:00:00 004 14:00:00 16:00:00 So on… Lunch_Intime, Lunch_Outtime column data type is text. I want to get a Total_Lunch_Time for the id. Tried Query: Select Lunch_Intime, Lunch_Outtime, Lunch_Ou...

Vb.exe performance time

Hi I am running a vb.exe through automation. In exe I have return a code which takes a data from database and saves that data into file. I ran that .exe for the first time. It took 1 mins. For testing baseline I called same .exe 5 times one after the other. But it took nearly 10 mins to generate. My question is if it takes 1 min fo...

window application registration issue in vb6

i want to register my application when it first time runs. it will ask a serial number and 16 digit key after entering correct key it will register. when next time i run the application it will not ask me a register key. i want the code in vb6 ...

Jet error 3011 when opening a file with 2 "extensions"

I'm having a problem with Jet throwing error 3011 when I try to use it to open a file with 2 "extensions" ("filename.tst.csv"). Run-time error '3011' The Microsoft Jet database engine could not find the object 'filename.tst.csv'. Make sure the object exists and that you spell its name and the path name correctly. Where the cod...

What's wrong with output parameters?

Both in SQL and C#, I've never really liked output parameters. I never passed parameters ByRef in VB6, either. Something about counting on side effects to get something done just bothers me. I know they're a way around not being able to return multiple results from a function, but a rowset in SQL or a complex datatype in C# and VB work ...

Detect what process/program start my process/program

Is there a way in code to detect what process or application starts my process or application. Any .net, vb6 or c++ code snips would be great ...

3D Rotation in OpenGL and Local Rotation

I am trying to prototype a space flight sim in OpenGL, but after reading many articles online I still have difficulty with getting the rotations to work correctly (I did have a quaternion camera that I didn't understand well, but it drifts and has other odd behaviors). I am trying to do the following: 1) Local rotation - when the user ...

What's the best way of hashing this complex structure in VB6?

I have the following structures defined (names are anonymised, but data types are correct): Public Type ExampleDataItem Limit As Integer ' could be any value 0-999 Status As Integer ' could be any value 0-2 ValidUntil As Date ' always a valid date End Type Public Type ExampleData Name As String ' could be 5-2...

Screensaver: Draw in front of the lockscreen

I need to build a screensaver which simply draws a picture and displays some information around it. That all isn't any problem. The problem is that I would like to lock the screen, which I do with the API-Call Private Declare Function LockWorkStation Lib "user32.dll" () As Long Call LockWorkStation() and in fact have my screensaver d...

How to search a file in the specified path?

USING VB6 I want to search a file from the path. For Example. Path = "C:\Newfolder\" file name = *.txt, *.fin I want to get all the *.txt, *.fin file from the newfloder. Need VB6 code Help. ...

VB6 application requiring comdlg32.ocx, running on windows server 2008

I have a legacy vb6 application that needs to run on a server 2008 machine. I have been unable to get comdlg32.ocx to register, which the application depends on. Any suggestions? ...

Visual Basic 6: Read MSG files and extract content

Hi, I would like to read MSG file stored on the filesystem and do the following: Read the body text of the msg file. Open and save the attachments in the MSG file. Is it possible using the msoutl.olb#Microsoft Outlook 10.0 Object Library? I would like to avoid using Outlook Redemption v. 4.7 based on question MSG Read Stackoverflo...

Delete all files within a directory vb6

Hi all, I was wondering if anyone could help me with a vb6 function that would delete all files within a directory (excluding subdirectories). Thanks ...

VB6 & Source Safe

We have multiple developers working on the same code base. We also are trying to use SourceSafe (6.0) When one developer makes code changes to their local copy, we note it in a list of changed objects for this release. When it's time to compile our next release, we open the "master" copy, update all the changes from SourceSafe to the...

How to update a table automatically?

Using VB 6 and Access 2003 Code Dim db As Database, tbl As TableDef Set db = DBEngine.OpenDatabase(App.Path & "\txtdata.mdb") Set tbl = db.CreateTableDef("Temp") tbl.Connect = "Text;database=" & App.Path & "/ConvTemp/" tbl.SourceTableName = strOutput & ".txt" db.TableDefs.Append tbl db.Execute "Select Temp.* into table1 from Temp" db.T...

PV Function and Porting VB6 to C#

I'm working on porting some classic VB6 code to C# and just stumbled across a usage of the PV function. I feels wrong including a reference to the Microsoft.VisualBasic Assembly. Is this something that is commonly done, or should I explore further options. The next idea that pops into my mind is exploring this PV function in Reflector. ...