VB Forum / General / August 2006

I have created a two dimensional ArrayList named aSystem that is populated as
follows:-
       aSystem.Add(New PickList(0, "Undefined"))
       aSystem.Add(New PickList(-1, "Standard UTM"))

I'm writing a small app that may use either SQLServer or MS Access.
My experience is with SQLServer and ADO, and I typically open and close
the database connection with each i/o, and use disconnected recordsets.
Now, is this appropriate with MS Access, or is this going to slow the

Is there an easy way to write a routine that can respond to changes to a
folder?  I was hoping that the FileSystemObject.Folder object had some kind
of update, add, delete type events already but I didn't seem them right off
the bat.

I'm utilizing a database that I created within MS Access within a
program I've created in VB.NET.  I am using the VB front end to
navigate the information, but want to be able to print a report, that
I've also created within MS Access.  I've attempted using the

I've written a programme that processes stock market price data in
VB.NET 2005 Express. I've optimised the code as much as possible, eg:-
using arrays, not passing parameters to functions, etc...
The code is slow because it is processing large amounts of data many

I created a dll control which utilizes (among other things) ADO recordsets.
The control properly reads the database catalog and can pull an empty
recordset, but when passing records to a listform (seperate form with a
gridview - as Friend) within the control, no records are ...

I need to control the format of the Write # statement .  When writing a
double variable holding the value 1, it writes 1 (with no floating point)
which causes a problem when I try to import it into another program.
How can I force it to write in a, say scientific format or with a

What are the advantages and disadvantages to the following two
examples? Does it take less system resources to pass the parameters as
opposed to storing them in variables?
Option 1:

How can i create a folder using vb code???

I need to create the following table, however when I try to set the reference
column to Autoincrement I get problems. Also I am unsure how to add a primary
key oran index. All he exmaples seem to fail
   If pbUseMicrosoftAccess Then

I have a VB6 app to do some data import from a SQL server to an Access
database, somehow, the app crashed and after that I can't open the access db
anymore, when I open it always say the db "is already opened exclusively by
user 'Admin' on machine 'xxx'.

I am having an issue with a DLL on a webserver. I have a local test
environment setup to develop asp pages and dll's. I have tested the dll
on my local workstation and it works fine. When I transfer it to our
webserver it will not execute the newly added functions in the dll. It

I am familiar with how to check if a directory exists.  But I want to
take it a step further.  We name directories in our job files as job
number and job name.  Job number is consistant, but name isn't.  I may
enter it one way and another user a different.  What I want to do is

I've got a CheckBox . . . and when I assign a value to it using
CheckBox.Value=1 for instance, it calls the CheckBox_Click()
procedure as well! Is this "normal"?,
FERHAT AÇICI

I have an app in which the main window needs to be non-resizable. The
user should be able to minimize it, maximize it and be able to drag it
around but not resize it. I'm using the code shown below to accomplish
this. (I've omitted some other code in this event that positions