Phil,
It is difficult to diagnose this sort of problem without being able to see the actual form and the code associated with it, or at least the code. My guess is that there is something in either the Load or Open event handler for the form that tests either the user name or group and adjusts the recordset accordingly.
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Phil Knowles
Sent: October-30-12 7:07 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] First record in a form
Hi Guys
I got no response on this particular problem and I could really do with some guidance - I'll try and explain it more fully.
I have 2 groups of user - say GroupA and GroupB
GroupA has 2 users - say UserA1 and User A2
GroupB has 2 users - say UserB1 and UserB2
All the users use FormA with datasheet view as default.
When GroupA users change from datasheet view to form view the record displayed is whatever record was current in datasheet view but when GroupB users change views the record displayed is always the first record of the datasheet view (ie it seems to lose the current record flag)
GroupB has higher privileges than GroupA and I am also in GroupB and in addition I have ADMINS privileges but it also happens to me. (ie when I change views I get the first record rather than the current record)
Everything other than permissions is the same for both groups so I have been searching in there for an answer but am now stuck.
There is some code in a macro to direct a completely different group of users (GroupC) to a different form based on an If command dependent on current user along the lines of
if current user()="userC1" then openform FormB else openform FormA
*** [Side Note - I bet I could achieve this by testing current group rather than current user - is this possible]
Has anyone any ideas about what this could be or how I could track it down?
cheers
Phil
________________________________
From: pdk444444 <pdk444444@yahoo.co.uk <mailto:pdk444444%40yahoo.co.uk> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Tuesday, 23 October 2012, 20:39
Subject: [MS_AccessPros] First record in a form
I have a form which my users display in datasheet view and then switch to form view.
It behaves differently for 2 groups of users.
For one group it retains the record from datasheet view but for the other group it reverts to the first record.
The group for which it reverts have higher privileges than the other group!!
What could be causing it to revert to the first record?
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar