ACCESS FEED: Re: [MS_AccessPros] First record in a form

Selasa, 30 Oktober 2012

Re: [MS_AccessPros] First record in a form

Hi Liz

Thanks for joining in.

I'm not sure I fully understand your suggestion but it seems to address a problem of allowing secure access to forms to a group of users which is not really my problem - in this instance I want all these users to have the same access to the same form and for it to behave in a the same way - it is simply the fact that in using this particular form and switching from datasheet view to form view one group gets the current record and the other group gets the first record (regardless of current record) - obviously I would like all users to get the current record displayed in form view after switching.

If I have misunderstood what you are suggesting and you think it will indeed address my problem please explain it to me in a bit more detail.

many thanks

Phil

________________________________
From: Liz Ravenwood <liz_ravenwood@beaerospace.com>
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, 30 October 2012, 15:30
Subject: RE: [MS_AccessPros] First record in a form

Would this work? It's something I do.

1. keep a table that lists the network logins accessible only by a form that can be opened by someone in that table (dlookup)
2. If a user wants secure access to another screen, they need to have an authorized user let them in to the club this way.
3. Once the user network login is stored in the table, the secure forms are opened by determining the network login and seeing if they are a member of that group.

Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: mailto:MS_Access_Professionals%40yahoogroups.com [mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of John Viescas
Sent: Tuesday, October 30, 2012 6:51 AM
To: mailto:MS_Access_Professionals%40yahoogroups.com
Subject: Re: [MS_AccessPros] First record in a form

Phil-

Is there any code in "FormA" that runs in the Open, Load, or Current event? How do users "switch to Form view?" Are users allowed to use the built-in Access menus / toolbars / Ribbon?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: Phil Knowles <mailto:pdk444444%40yahoo.co.uk>
Reply-To: <mailto:MS_Access_Professionals%40yahoogroups.com>
Date: Tuesday, October 30, 2012 2:22 PM
To: "mailto:MS_Access_Professionals%40yahoogroups.com"
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] First record in a form

Hi Glenn

Thanks for your prompt reply.

There is no logic in the whole system that differentiates between either GroupA or GroupB or the users in those 2 groups - any logic that there is is to deal with users of GroupC - users of groupA and groupB always fall into the 'else' logic of an IF statement and therefore all conditions should be exactly the same. Or should they?

The only differences between GroupA and GroupB users lie in the permissions area.

cheers

Phil

________________________________
From: Glenn Lloyd <mailto:argeedblu%40gmail.com>
To: mailto:MS_Access_Professionals%40yahoogroups.com
Sent: Tuesday, 30 October 2012, 11:22
Subject: RE: [MS_AccessPros] First record in a form

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: mailto:MS_Access_Professionals%40yahoogroups.com
[mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of Phil Knowles
Sent: October-30-12 7:07 AM
To: mailto:MS_Access_Professionals%40yahoogroups.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 <mailto:pdk444444%40yahoo.co.uk <mailto:pdk444444%40yahoo.co.uk> >
To: mailto:MS_Access_Professionals%40yahoogroups.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]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

[Non-text portions of this message have been removed]