
November 26th, 2004, 07:09 AM
|
|
Registered User
|
|
Join Date: Nov 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Array Listboxes to Access Database
I have a form (FrmSquadding) which has 1 single input text box and writes it to the access database (Bowling.mdb) which works fine. Now after I enter this information into the name section and saved to the database I want all 29 list boxes (which are set up as arrays) to show me the list of names I have in the database and retrieve the results I require.
I have found several pages on how to do list boxes but these all have the .additem and appear to save it to the program and not the d/base. Also none of the pages I have read tell me how to get the info to show in all 29 list boxes. I have tried an array for x = 0 to 29 next x in the proceedure but in the main coding I was looking at there was a loop so I coudlnt see how to get my array x to work with it.
Also looking at a dbl click on the name box to search the list of names.
I have attached the files if anyone dares to look at them.. ( II have had to put them on my webspace due to I keep getting an error when trying to use the function here)
Also I kow my coding is very bad but I have only been learning VB out of a book for a few months in my spare time and now found out the project I have decided to do is huge lol..
Last edited by Tazskool : November 26th, 2004 at 07:13 AM.
Reason: Tried attaching my file
|