VB Forum / General / April 2005

  i used to execute the queries using the statement
  rs.open "the query statement",adopendynamic,adlockoptimistic
  even i dont know exactly the advantages of using the properties like
adopendynamic, adlockoptimistic and also i never used cursorlocation

I need to create a sql statement in VB that involves mixing and matching a
bunch of different strings: sql inser, select, update, etc. with fields,
values, params, etc.
What would be the fastest way of handling strings in VB?

I'm working on creating a function which should return a Collection of File
Names following a specific criteria which is variable. Let's say for the
first time I need a list of all files with ".doc" extension, next time it's
going to be ".doc", ".pdf", ".mdb".

I need to access a file with file.GetLastWriteTime and work on the same file
before closing the program, but it seems vb keeps a handle to the file....
how do i release the file after i have accessed it.

I have an app to synchronize a Win98 PC's clock to an NNTP server using
WinInet API's and then setting the clock with SetSystemTime.  Works
fine, but the clock in the systray doesn't get updated to the sync'ed
time unless one opens the Date/Time Properties window.  Currently, I

Is Package and deployment Wizard part of VB6. If yes, how
do I use it.
Txanx

Friends,
I have the following requirement. There are command buttons on the form
which are defined as control array and I'd like to respond their events in a
class module. If they were not defined as an array it would be easy for me

When a programme is running is it possible to alter the priority of the
programme process from within the programme?

How do I create .cab file from within the vb6
environment? Also, how is INI file created? Thank you for
all the help. Barb

I have a form with code:
I am attempting to create a function called GetDate
the date desired is the date last modifed to include this inthe new name of
the file.

i have this code .. i understand the other flow a little bit but
there's something i can't get ..
Private Sub cmdDisplay_Click()
Call Generate(txtLimites(0).Text, txtLimites(1).Text)

I am investigating converting a VB 5 app with windows interface should be
converted to a windows service using the ntsvc.ocx.
The app in question calls 3 different other windows forms applications
(.exe) each with a single form that is non-interactive but can cause a

I am creating an HTML report/file that will be written to the user's
computer. Once the report is created, I want to open the newly created HTML
file with the user's default web browser I have done this type of thing beore
in VB6, but I can't seem to find out how to do it with VB ...

I have designed a software audit tool which loops through
the "SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall"
registry key but the problem is that on every pc but the
one the software was designed, I get the error message:  

We got back "No accessible overloaded. "Streamwriter.writeline is most
specific for these arguments:
Overrides Public Sub Writeline(ByVal buffer as Char() ).
Overrides Public Sub Writeline(ByVal value as char)