VB Forum / General / April 2006

Here's an easy one. What is the syntax to detect an unitialized string?
Example of what I want to do but with incorrect syntax:
' In the global declarations area
Dim str as String

What is the difference between these two bits of code?  I'm running VB6 Sp6.
Private Sub chkStatus_Click(Index As Integer)
 getRecordset
End Sub

I am using VB6 to write the following code.  I have created a variable,
XMLOut, that holds a string and I am trying to pass it to the Email Function
so that it is the TextBody of the email, but the variable is always blank.
Any help would be appreciated.

I want to replace a certain byte sequence inside a huge binary file with
another byte sequence(same byte length) with a vb6 program.
For example, if I look through the file and find the start sequence
0x0A,0x0B,0x0C it should be replaced with the new sequence 0x00,0x01,0x02.

I know I'm missing something simple, and could have sworn I've read about
this somewhere, but at the moment I don't recall where to fix this.
Public Enums, in a MultiUse class module.
I want to adjust the spelling on several of them.

I successfully create an excel spreadsheet using the following code
   Set rs = gDB.OpenRecordset("tblCaseSummaries")
   strSheetName = "Keep"
   eSQL = "SELECT * INTO [Excel 8.0;DATABASE=" & gstrCaseSummariesLoc &

Are there any code snippets or docs which explain how to access (both read
and write) the extended file attributes?

I'm attempting to write some VB6 code to analyze a specific gravitational
problem and in order to do so I need to provide an interface to a real world
object in order to obtain real time feedback. This is the sort of thing I am
trying to analyze (see section 2.21)

There is a button named CommandButton1 in sheet1 of an excel workbook .
How to programmatically to add CommandButton1_click event heandler with
VB?
I know how to add a macro programmatically using set xlmodule =

I have a need to store 2000-3000 characters of data in a field in an
Access database. I'll be using DAO 3.6 to manipulate the database from
a VB6 program.
I assume that the "Memo" data type is the proper thing to use here?

(but only when I compile under certain circumstance)
Hello Folks,
I've had a tough and elusive problem regarding multiple ActiveX-Controls.
The application is a VB EXE, and uses a whole stack of self-built VB

I am trying to read a txt file.  I am trying to read in the file line by
line until EOF.  For example, I need to test the value of the of column 1 and
5 of the line being read.  How can I check the values of these columns?  
Thanks for sharing your thoughts.

I just spent the last hour tracking down this bug in my code.
Int(Log(64) / Log(2))
vs.
Log(64) / Log(2)

I have a problem at hand. There is a link
http://alpha2.iimb.ernet.in/pgsem2006/interviewcall.html. Which
displays the result of an exam. I want to check the result of all the
2000 candidates for my reference and sort it into passed and failed

I have a function as following:
Private Function GetAllFile(ByVal pDir as String, ByVal pFile as String) as
Boolean
   Set lvFs = New FileSystemObject