I am very new to making VB
applications although I have a fair amount of experience with ASP. I want to populate a dropdown combo box with all the users in my database which is situated in the same directory as the application.
I am unsure of the coding but I would assume that you would have to locate the db like:
App.Path & "\despatcher97.mdb"
and the SQL statement would be as follows:
strSQL = "select * from Users order by Name"
and with my experience with ASP I assume the population part would be something like:
Combo1.ItemData(Combo1.NewIndex) = .Fields("Ident").Value
Loop Until .EOF
I am just unsure how you would fit it all together.
Any help with this matter would be greatly received.
With many thanks for your time and assistance,