VB Forum / General / March 2006

When a file is being used (e.g. by another program) it is sometimes not
possible to overwrite it, delete it etc. Is there a gentle way to test if it
is "Access Denied" without actually trying to overwrite (it and trapping the
error)? Because that seems rather like testing if ...

I'm upgrading an app from MS Access to VB 6.  I have used a List Box in
Access that has columns and column widths.
Is there some equivalent control in VB 6?  I've tried various Listboxes I
found in VB 6, but none of them have the column width property.

I have been trying to find sample code for inserting into Sql Server 2000.  
I haven't been very successful.  One thing I don't understand from the few
snippets I've seen is how to connect the value in the textbox to the
parameter.

Can anyone refer me to a link that tells all about the ins and outs of using
the .exe.local file to force applications to use the local folder for
components? (or anyone have anything good or bad to say about it).
I read about in it VBPJ vol10 #7 (June 2000) article "Reduce DLL ...

This is Lotto Based.
There is a System in Lotto called "Wheels".
A Lotto Wheeling System is a Special Pattern to Arrange Numbers into
Combinations. This System can be Used Over and Over again with

Coming in through
http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.vb
.general.discussion&lang=en&cr=US
Is there a better way?
How do I do corss-posting?

If user X tries to open foo.txt(path), which he does not have access, with
the following routine:
   Open path For Binary Access Read As 1
   Text1.Text = StrConv(InputB$(LOF(1), 1), vbUnicode)

Steer me to a place where I can learn how to do this.
POP vs SMTP vs MailTo
Does the person need an eMail account on the PC?
Is it OK to use any Server Name and what does a Proxy do?

Every time I close VB6 SP6 with Common Controls update, VB6 "crashes" with
this error message.  This occurs on several PCs.  Running on WIN XP SP2.
I always click "Send Error Report" but never get a response (sometimes I do
get a response for other problems).

I have a text box with multiple lines and a vertical scroll bar. Is there a
way to always display the last lines rather than the first ones?
Dan

I am having a problem formatting a worksheet via vb.
I have
Dim XL As Excel.Application
Dim XLWBk As Excel.Workbook

which is better practise - stored procedure or activex to create a
adodb connection for visual basic applications that can be called from
multiple applications? thank you very much.

I have a sql server database enterprise database, v. 8. I have multiple
visual basic applications connecting to this database -- the apps have
to be individual they cannot be all combined into one. I would like to
re-use some of the code for all the applications including the code ...

This seemed a simple project but I'm at the edge almost.
I can't seem to convert a string to a date.
The string looks like this:
"01 MAR 06" and I want to convert it to a date like: 01-03-06

I am having a very strang issue. I have a picture box with Autoredraw
set to true. I am clearing the picture box and re-writing data to it
about 5 times a second (a real time graph) .
I .Cls it, then I draw some data to it using .Print  and .Line  and