VB Forum / VB Syntax / August 2005

ik zoek een oplossing voor volgend probleem: ik heb een exceltoepassing waar
- na invulling van gegevens - een e-mail gegenereerd wordt via een VB. In
deze mail staat een tekstje waarin ik een hyperlink wil zetten, maar in VB
lukt me dat niet.

I'm a VB newbie.  I want my application to play all of the files (.mp3) in a
given directory when I start it. I am able to play a single file by using the
"URL" property of the WMP object.
I'm wondering what the simplest way to pass the contents of a directory to

Hi there i am always getting the said topic error when i use format/string/or
Str.... function or Syntax??? in my old projects.. It works fine when
creating a all new clean project..... Is there something reference or stuff
that i should know when using format/string/date/time ...

what is [] operator? for example:
[String].Compare(....
Thanks for help

   I'm using VB6 and Access 2000. I'm running an ALTER TABLE SQL statement
to change a primary key on a column and datatypes on other columns. I'm
using the code:
Dim c as New ADODB.Connection

How do I make the progress bar look like XP style?
TIA
Guy

First of all, apologies if this is covered elsewhere in the forum but I've
looked high and low and can't find anything.
I'm relatively new to VB6 and am trying to do something thats probably quite
simple: I need to capture the user's ID or username while they're logged in

Does anyone know the syntax for getting the number of fields in a given
recordset (I mean a variable of type ADODB.recordset)?
thank you

How can I convert this number: 2227808324
To hex?
(84C9A844)
Using Hex$ in VB6 returns an error

Good morning all
I have a simple question, but I can't think of the answer...need more
coffee.
I have a small database table from which I draw a list of QA Schemes. The

I am trying to create an interface where the user will choose from various
formats: YYYYMMDD, YYMMDD, YYYYDDMM, etc.(through a combobox), in order to
specify the Date format of a specific column in a csv file that i try to
open.

as the subject says, I googled it to no avail.
Do I have to enter a specific code, and what is it?
TIA
-steve

Dear Friends
How can I save and retrieve images using vb6 and Microsoft Access
Thx
Anuradha

I am trying use create a dynamic multidimen. array with DIM and REDIM
PRESERVE, but it doesn't work. Can anybody help me?
Dim l_vAray() As Variant
dim c as integer

This is so bizarre I hesitate to post it, but I need to get this working.
My code looks like this...
Private Const cmdTestResourcesSel = "SELECT * FROM TResources" & _
                                                      " WHERE Scenario =