Search results

Hi I have a form,BusinessOpportunity, to which I have to add about another 20 fields. It is kind of a checklist associated with every record which, the user has to complete. I don't want to add these fields on the form because it's already very conjusted. I was thinking of creating another...

I am having this strange problem. I have secured one of my forms. Users have to enter their userid and password. Once their userid is authenticated it is stored in a table. On my form I have the userid field. I use the code below to see if userid matches with the one in the table. If it does...

Kevin: That's not what I want. How do I reference my subform from my mainform and unlock it. For example something like this Me!subformname.enabled = True Is it the right format??? Ekta

Hi: I use the code below to change the property of the controls on my main form. In this code I want to add the code to unlock my subform. How can I do that. Main form name: Opportunity subform name: notes_subform If objRec.RecordCount = 1 Then Me!UserName.Visible = False...

Thanx:)

Hi Elana: If you look at the code that's what I have done. Me!UserName.Visible = False But the problem is that when you open the form it appears but after navigating theough 7-8 records it become invisible. Ekta

I use the code below to lock and hide some of the fields on my form depending on the userid and userlevel. It works fine but the problem is that when the user opens this form I want to hide the hide the field username. When the user opens the form it is visible and after navigating through 6-7...

Hi: I have the followign code on the open event of my form. If the Userlevel is user then I want to hide a button on my form and if not I want to display it. When I run the code it displays the button even if Userlevel is user. Don't know what I am doing wrong? Private Sub Form_Open(Cancel As...

Yes, the combo box is bound to the USERID field in my tblOfRecords. The values in the combo box come from tblOfUsers.

Jon: I created a table and added the two fields: UserID & User. I then created a combo box on my formvwhich displays the users. Ekta

Jon: I am not sure what you want me to do here.

ok I'll do that So, now what method would be good for this. The one you told me or the one Jon told me. How should I go abt it?

Hi Pat & Jon: I am sorry for not replying. I juss saw your replies today. I was out of town. I appreciate your help. Like Jon said..I think this can be done.. the 6th user can add the user name when adding a new record. Right now I have this field "CaptureLead" in which each users lastname is...

Hi Pat: Yea, I understand that. I din't mention it b4.. the users can view all the records and edit their own records but they can't add a new record.. the new record would be added by that 1 user who will have access to all the records.

Hi Pat: Thanx for your help but I think I'll need some more help.:) You told me that I'll compare the gUserID with Me.txtUserID and this Me.txtUserID will be the field on my record. So do I need to add this field to the table on which my form is based. And how will this field be populated. I am...

Hi Pat: Thanx for your reply. That is exactly what I am looking for. Can you please tell me how to set up UserID as a global variable and then compare the logged in UserID with the userID in the record. I get the idea but don't know how to implement it. I am doing this for the first time so...

Hi: I want to create a username and password for my form. There will be 6 users who will use this database. Every user has records related to him on the form. Out of these 6 users, 5 will be able to see all the records on the form but they can edit only their records and not other users...

Hi: I have created a database which will be used by 5 users. My problem is that there are records related to each user in the database. I want that when a user opens the database he should be able to see the records related only to him and not the records related to other users. Out of these...

Thx again.. I will try it

Hi bjackson: Thx a lot for your help. It works great. Can you also tell me the other way of doing this. I wanna learn. One other question that I have is that right now I have this option group and the user selects from it. But what if I want to add one more criteria, which I have to in near...