I have a database that on form_load capture's I'd numbers. The user can know have acces only to their own entries. I need to be able for 2 people to have access to each other's information. What I would like to do is for the user to be able to switch from viewing their inventory to viewing their "buddies" inventory. The second problem of this is when I pull out forms from other users I find that since environ pulls from form load once viewed the last person that opened now becomes owner. I gues my question come in 2 parts. 1) How do I code the form to show user and their buddy only and not all other users? 2) once this is done how to turn off the capture so that is does not update with viewer's id? I know that this may seem confusing the way that I have worded it. I'm not sure how else to explain it. Thank you for your help and appreciate any help or advise that you may offer.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is it possible for 2 users to veiw the same information?
- Thread starter frosty90
- Start date
stanhargrave
Programmer
frosty90
You can drive your form with a query that allows an or argument (i.e. "user1" or "user2"
. Second, the only way that more than one user can view the same info on a form is to make the query open in snapshot rather than dynaview. This means that neither of them can update the record in the form. You could allow them to click a button (i.e. "update" which could change the form to use a dynamic view of the record. They would not be able to update the same record at the same time (which if they could would cause several data normalization problems for you).
The other alternative is to load the form with the data in unbound controls. This would allow them both to view and update the record simultaneously. The problem with this method is the winner in the data update race is the person who updates last. This presents the data normalization problem I mentioned previously.
If you need any code samples of these methods, please let me know.
Stan
You can drive your form with a query that allows an or argument (i.e. "user1" or "user2"
. Second, the only way that more than one user can view the same info on a form is to make the query open in snapshot rather than dynaview. This means that neither of them can update the record in the form. You could allow them to click a button (i.e. "update" which could change the form to use a dynamic view of the record. They would not be able to update the same record at the same time (which if they could would cause several data normalization problems for you).The other alternative is to load the form with the data in unbound controls. This would allow them both to view and update the record simultaneously. The problem with this method is the winner in the data update race is the person who updates last. This presents the data normalization problem I mentioned previously.
If you need any code samples of these methods, please let me know.
Stan
- Thread starter
- #3
The update issue would not be a problem with 2 users updating. This would be used if one user is on vaction, leave etc. So if I understand correctly they would be able to dynamicaly view and if needed updated they would then become the owner. If I misunderstood please advise. Would this have to be coded in pairs. I have 38 users. I will have them paired off. Ex u221096 and u320016 would be buddies and allowd to view each others information and so on. The update function would then have the record assigned to the last user that updated. If you have example code it would be greatly appreciated. Thank you for you help.
Chris
Chris
- Status
