VB Forum / General / April 2005

I have a problem related to SQL query.
Before server re-format its operating system, the sql query resides in vb
application works fine. After reformatting, the runtime error
-2147217871(80040e31). The error code shows query timeout.

I have this code that is returning run-time error 7004. The rowset is not
bookmarkable.
Cn.CursorLocation = adUseServer
  Set iWebOrdLookup.ActiveConnection = Cn

I am following - to where I can-  the "correct" procedures to unload
controls and forms... now I wonder myself if it is possible to verify that
my application has released to the resources... the Administrator of Tasks
of Windows isnot enough to me, So im searching for a more ...

just a tricky question about the Format function:
My expression can either evaluate to a whole (integer) number, or it may
have a fractional part.
In the first case, I'd like the number to be displayed without decimal

I sent this post yeaterday and if I do a search on my name is shows as being
posted on 5-24 @ 9:34.  However, I can not find it in the list of messages
for that date and time so I am repeating it .  Sorry if I am somehow am
failing to look at the right place.

I'm quite new in vba excel. Well i want to make a program that can rea
a txt file, convert it into excel w/sheet and place data etc. number a
each column. The txt file would be probably like this:
No.   Column A     Column B    Column C

I would like to dynamically create one or more arrays at run time.  I've
been able to do this with Dictionary object:
   If m_Values.Exists(Index) Then
       'fetch

Dear Sirs,
where can I find some solution to see how can I paste some part of mp3 over
another mp3 or wav files.
Best Regards

I have had a few quirky bugs that I haven't been able to run down yet.  I
have put logging in place to log information such as variables, values of the
controls, and propertys in the forms.  I would like to take the logging
further to include system information such as file names ...

Do I need the client to purchase a copy of Microsoft Access if my VB
program makes use of Access.Application?  Are there certain DLL/OCX
files that I can distribute to my client without having them purchase
Access? If I can get by with just distributing some DLL/OCX files, which

Simple question:  Can I have a collection of clsX, and another collection of
clsX, and "share" and instance of clsX between them?
What I mean is that I have a class clsX.  I have a collection called mColX
that is a collection of those.  When I load up the program, for instance, I

When pressing F1 for context help in VB6, MSDN appears correctly for VB
language keywords but not for such keywords as “Application” or “Documents”.  
I have referenced the ‘Microsoft Word 11.0 Object Library’ but receive the
message “Unable To Display Help” when pressing the F1 ...

i've written a program that downloads the graphs represented on a single
.gif file here:
http://tidesonline.nos.noaa.gov/plotcomp.shtml?station_info=8747766+Waveland,+MS
what i'd like to do is to cut it into 4 separate images and save each one to

I want to click on an item in a radiobutton display with a value attached to
it.  When I click submit I want that value added to a total which displays in
a text field.  Each time I click on a radiobutton item, I want that total
increased by the value attached to the item chosen. ...

Got this Function online, I don't even pretend to understand it:
Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal
lpBuffer As String, nSize As Long) As Long
I then call the Function: