By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Listing all users in a combo box.

P: n/a
I would like to be able to list all the users of a MS Access database
in a combo box. How would one do this? What is the function or Sub
look like to do something like this? I have ADO 3.6 I believe (Access
2000).

Thanks in advance for all your help

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Karen Hill wrote:
I would like to be able to list all the users of a MS Access database
in a combo box. How would one do this? What is the function or Sub
look like to do something like this? I have ADO 3.6 I believe (Access
2000).

Thanks in advance for all your help


Dim usr As User
Dim strUserList As String

For Each usr In DBEngine(0).Users
Select Case usr.Name
Case "Creator", "Engine"
' don't display these
Case Else
strUserList = strUserList & usr.Name & ";"
End Select
Next

Combo0.RowSource = strUserList
--
[OO=00=OO]
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.