How to Convert Seconds to “Days, Hours:Minutes:Seconds” Format in Visual Basic 6 (VB6)

This following code will give you a complete solution how to convert a Seconds value to a “Days, Hours:Minutes:Seconds” format in Visual Basic 6 (VB6). This will be useful when you want to know how many days, hours, minutes, and seconds from the given Seconds value. For example, you have a record which has value [...]

Share
[Read more...]

How to Get Data from Excel Worksheet Using VB6

You can read and retrieve data from Microsoft Excel Worksheet easily by using your application that you made by Visual Basic 6 (VB6) programming. Simply just using its Microsoft Excel Object Library reference provided by VB6. The following code will show you how we can do that step by step. Started from how we can [...]

Share
[Read more...]

How to Calculate Difference Between Two Dates Using VB6

This following code will show you how to calculate difference between two dates by using Visual Basic 6. The calculation result will give you an output that contains of the difference between those two dates in format: Days, Hours:Minutes:Seconds. The both dates must be in complete format. For example: the first date is March 1, [...]

Share
[Read more...]

How to Convert 10 Digits Numeral to The Date Value?

I have hundreds of records that need to be imported from one table and database (let’s say that this is the first database) to another table in different database (and the last one is the second database). Unfortunately, one of the columns in the table in first database has the Date value in 10 digits [...]

Share
[Read more...]

How to Convert 5 Digits Numeral to The Date Value?

A few days ago, a friend of mine asked me for help. He wanted to export his data from Excel file into Access database file. There were about sixteen thousand rows in Excel that have to be exported into Access. One of the columns in that Excel had a Date data. Unfortunately, most of those [...]

Share
[Read more...]