Search results for query: *

kjv1611 I appreciate your taking an interest. I really do. However, my issue here is clear, even though the solution may not be. This is not a matter of simply linking to tables or populating list boxes with queries. I would not require assistance if it were. All of the information is...

No. We have a program stored in an Access 2003 format. We have User Level Security installed. My list boxes are displaying User and Group accounts, which are stored in the Workgroup information file. The code that I have pulls that data nicely. When I add a user account or assign a group to...

kjv1611 Thank you for your interest. What you are suggesting is exactly what I am asking. Is CurrentDB a viable alternative to what I was doing? Keep in mind what it is I am trying to do. The whole point is that I have two list boxes that need updating: One displaying User accounts and the...

Still frustrated..! Let's try this a different way. I actually have a few areas that will all necessitate the need to refresh the list of user accounts. The Form OnLoad event, Create Users, and Remove Users functions. It will be the same answer for all areas. Here is sample code from the...

Darrylles Thank you for your suggestion. Unfortunately, I did not have much success. The module: modWorkSpace produced an error and would not work as constructed. So, to test the rest of the code, I eliminated modWorkspace. To compensate, I added: Set Wrkspc = DBEngine.Workspaces(0) to top...

Darrylles Thank you very much for the reply. I am under a timeline, so I truly appreciate your help. I will try this right away. I just want to clear up something. If I am understanding you correctly, I should create a public module to replace my initial code to populate list boxes. I...

Update: I came across two topics on the net that "seem" like they want to point me in the right direction. One concerned the updating of the dbengine. However, the code to do so is having no effect or I am just unsure of where in my code to use it. DBEngine(0).Databases.Refresh The other...

I realize that, which is why I opened my post with a pre-apology. This question would have been lost in thread of the other post, which is why I started a more direct post hers. Also, this forum, since it is geared towards VBA, is probably more directly related to my question. While I...

Not really. This RowSource for both list boxes are generated new each time the form is loaded. I have code on the OnLoad property that does this. See below. Set WrkSpc = DBEngine.Workspaces(0) Dim strAccountName As String Dim grpAccountName As String Dim usr As User Dim grp As Group...

Hi Everyone, First, I apologize upfront. I originally posted this question within another post that covered different but related topics. It occurred to me that this forum may be more appropriate for this question. Not trying to be repetitive. My question is this. I have a form that I use to...

Hello All, Another wrinkle came up. I was able to install code that: Creates and Removes User Accounts Display a list of all User Accounts Display a list of all Group Accounts Display a list of Group Accounts for the selected user My issue now is that when I create a user account, I would...

It should be straight-forward. Code is not a not a necessity. It depends upon what you are trying to do. I was just checking. Do you have a valid Control Source defined for the combo box? Is the form's Record Source based on a table or a query? When you attempt to make a selection, check...

You cannot select the "fields"? Do you mean it will not allow you to select the "record" values displayed within the combo box? Are you receiving any error messages? Typically, you would have code placed on the "AfterUpdate" event for the combo box. Is this the case? If so, can we see the...

Hello, This originally was one small piece of another post. I am afraid it got lost in the shuffle so I wanted to have a dedicated post for it. I am using Access 2013 but our programs are designed and saved in a 2003 format. I want to be able to link and display the contents of two tables in...

Yes. Absolutely. Actually, I started out that way but when I couldn't get the syntax correct, I started experimenting. You really helped out. Now If I can just figure out how to link to the tables in the workgroup file, I will be all set. That's todays project!

I just got it to work. See below. Thank you very much for your help! Now, if anyone knows a way of reading the MsysGroupList table in the .mdw file, please let me know. The code below works fine but I need the ability to add multiple groups at once rather than one at a time. My hope was...

I would prefer to have nothing hard-coded. I would like everything to come from a form field.

Andrzejek, I do see the difference and your code worked fine. However, the code you gave me is assigning the password as: pword. What I am saying is that I would like the user to be able to specify a password on a form field rather than having the password hard coded. Notice that I have...

Andrzejek, Thanks a lot. For the most part that worked great. However, when I attempt to create the password in a similar fashion, it fails. See below. Dim usrNew As String Dim grpNew As String Dim passnew As String Dim PidNew As String Dim str As String usrNew = Me.NewUser grpNew =...

Hello, I have a database that is written in a 2003 format in order to take advantage of user accounts. I need to set up a user form to allow for easier creation of user accounts and to assign them to groups. With this in mind, I have two questions: First, The initial code that specifies the...