Greetings everyone.  I am extremely new to the Visual Basic programs (I
played with 5 and now am playing with 6).  I am very experienced in writing
ASP and connected to Access databases and such so my boss told me I had all
the knowledge to create my own webpages.

Here is my questions: First I am trying to create an application that
interacts with an Access database.  I have successfully been able to connect
to one thanks to this site's tutorials.  What I am trying to do is create a
drop down list box that contains all the info in a certain field.  I did it
in a loop:

Private Sub Form_Load()
   Set Db = OpenDatabase("Data.mdb")
   Set Rs = Db.OpenRecordset("data", dbOpenSnapshot)
   Do While Not Rs.EOF
     PalsListCombo = Rs!NickName
     Rs.MoveNext
   Loop
End Sub

But in the Combo Box it only lists the last record in the database.  How can
I have it write all the NickName records into that list box?  I want to
simulate a user choosing a Nickname to get the corresponding data.

Also, I was curious how to make an application to sit in the windows Tray
rather than the Taskbar.

Any help is always appreciated!

Susan

--
Another visit from Susan.
http://www.*-*-*.com/

I believe there is a method you need to use for combo and list boxes to
add items.  Something like
combobox.additem "Item",index

Look up combobox in the help, and then look at the methods and
properties.

As far as putting something in the tray, go to planetsourcecode.com and
search for them.  there's really only one way to do it, but there seems
to be a million implementations of it for specific uses...

-Adam

P.S.  Please avoid cross-posting.  Pick the group it fits into the best,
and try that.  If no one responds, then try other relevant groups...
Thanks!!!
(sorry, pet peeve of mine...)

Susan:

On the Windows System Tray issue, check out MSDN article id Q176085 entitled
"HOWTO: Use the System Tray Directly from Visual Basic."  The sample code
should get you going in no time!

Colin.