VB Forum / General 2 / October 2004

My web page will not work with
 sSQL = "SELECT * " & _
 " FROM AllExpenses2005" & _
 " WHERE Vamount = '" & Request.Form("searchItem") & "'" & _

I've got a an issue with comparing dates in VB6 (sp4) and I would
greatly appreciate help that anyone has to offer on this subject...

I have two variables (start_DateTime and end_DateTime). Both contain

 I want to do the following:
  declare a file stream and a writer in subroutine A
and perform the actual write operation in subroutine B.
 How should I do it ?

I have some code in my form's resize event. However, when I maximize
the form, the code doesn't fire.
Is this normal? If so, how do I make sure it fires?
---Atreju---

Dear VB fans
Is it possible to have multiply selected nodes of the TreView object,
similarly like in the ListBox object?
Tx

I'm having problem debugging ActiveX exe written in VB6 in VC6. I
folowed the steps described in msdn but with no success.
I have no problems debugging standard exe or ActiveX dll, works fine,
ActiveX exe no success.

G'day All,
Using VB6, I want the best way to extract the filename "\20040102.txt"
from this string "C:\TEMP\SHARES\20040102.txt".
The InStr function returns a Variant (Long) specifying the position of

Hi When I compile my program on my XP Professional computer and copy
the program to cd, the program installes and runs fine on XP computers
but wont run on a Windows 98 computer.
Is there a trick to doing this? as many of our customers still use 98.

I have a formless activeX dll running in IE that hooks the common
dialog API's. It works perfectly except that the dialogs are
positioned at the top left of the screen and I would like to center
them based on the parent application. I don't see a good way to refer

Create a new solution, add a class...
Public Class Class1
Public Sub New()
   .New()              '<----- This line will blow up the IDE

Hi, anybody know any url where can i get the lsClassName parameters for the
Api's.
Like "Button" or "ListBox"  on CreateWindow
Thnx!

hey man thanks for the code except i am getting a error at this line with
the 1 by it
Private Sub Form_Load()
Dim strTMP As String ' declare the variable to hold the text

Which reporting tools offers good multi-language/localisation stuff?
Erik

Does any one know which is the simplest & better way of sending
e-mails through VB, is it:
1. MAPI
2. CDO

Nothing in VB seems to give me more trouble than using wildcards in
expressions for SQL statements. I have a form with boxes from A to Z
to look up customer information. The user selects the start letter of
the last name. I use the letter and a wildcard to find all last names