VB Forum / General / October 2004

I was wondering if anyone has ever tried to tackle this issue. I have a
database that may have user names entered in it several dozen times and I
would like to go through and "mark" names that have duplicate entries. The
system does not need to be perfect as I will be visually ...

I need to make it so when a user leaves a text box after entering in the
date, it formats it correctly.
if the user types in 10/4/04 when they leave, it will automaticly change it
to 10/04/2004 which is good, but if they enter 100404 then it does nothing

I'm working with VBA in Microsoft Access.
Here's my problem:
Dim SubCategoriesSQLSelect As String
SubCategoriesSQLSelect = "SELECT SubCategories.Name FROM SubCategories WHERE

I have a need to get an XML message from a website and then read the XML
document as a recordset.  I have read an XML file, but not XML message from
a url.  Can anyone point me in a direction to find out how this can be
accomplished?  Besides a VB6 project, the user wants something ...

I'm a newbie in VB Classes design. The ActiveX Control Interface Wizard made
for me the following code for read-only & runtime-only property:
Public Property Let MyStatus(ByVal New_MyStatus As Long)
   If Ambient.UserMode = False Then Err.Raise 387

I'm a very experienced programmer, but new to VB.
I'm trying to write a very simple web service using classic VB that will
"listen" for incoming XML that has been sent to it using a POST (with no
form input, so it's not named for using request.form).

My VB6 program runs 100% under Citrix (Windows 2000), but every time a
msgbox is called to display a message, the program throws an application
error.
It says "Application popup: Close: Prog1.exe - Application Error : The

I have the following line in my code: Printer.Scale (-39, 30)-(39, -30) and
as expected it sets my landscape printed page to (-39,30) - upper left and
(39,-30) lower right.  At least it did until recently!  Though I have not
changed the code that has been working all along it now ...

Howdy All,
   I'm writing a VB6 COM wizard designed to interact with Word.  This
allows me to instantiate a Wizard object, and that object takes
responsibility for showing the forms and collecting the data.  The forms

I am looking for samples on how to download a file using http command  not
ftp.
the site requries a UserName and Password.  I have downloaded some sample
but none of them work.

How come this is not connecting?
[code]Dim oSocket As CSocket
Private Sub Form_Load()
Set oSocket = New CSocket

in my vb.net application i have 2 function's.
the first func' must get a 2 dimen' array as a parameter
and send it to the second function.
the problem is that i dont know the exact size of the

How to search for a string in the columns other than the first one?
Consider I have 3 columns in my listview control.
I want to search for a string in the second column.
lvwGeneral.FindItem(Mid$(txtSearch, 1, snTxtlen), 0, , 1)

I have build a recordset in ADODB selecting multiple fields from
multiple tables. This is working fine.
But now I tried to add a field to this recordset and I get an
error message saying Connection Failed.

Is it possible to catch an event tell when the clipboard contents change
without checking it every few milliseconds?
I'll explain with an example.
In Excel, select a group of cells and Ctrl+C them.  The marching ants