List Box Choice

[Kalpesh69]

Hi

Does anyone know how I can write it so that when a user clicks an option in the list box, its should automatically create a connection to an MS Access 2000 database on a remote workstation ie., on a LAN. Any help would be much appreciated, as I'm still quite new. If you can point me to any good books on VB6 as well to learn from, it would be really helpful.

Many thanks

Kalpesh

 

[mmilan]

The list box has a click event that you can use.

Inside the click event, check the listindex property. If it is not -1, then you can use lstbox.list(lstbox.listindex) to get at the selected item's text.

Then you make the connection...

mmilan

 

[zemp]

For VB books take a look at

http://www.visualbasicbooks.com.

zemp

 

[bmdb]

Lots of sample code at

http://www.planetsorucecode.com

and

http://vbnet.mvps.org/

and

http://www.freevbcode.com