Jumat, 11 Mei 2012

RE: [MS_AccessPros] Disable F11

 

Phil-

Splitting is easy. If everyone uses the same drive letter for the network share, then you need do nothing else except give everyone their own copy. You can keep the "master" copy of the code on the server for changes that you might want to make. Get Bill Mosca's front end updater from the files on the group.

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

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

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Phil Knowles
Sent: Friday, May 11, 2012 4:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Disable F11

Hi John (and Bob)

Ok I get the message - I need to split my database!

I will obviously have to look into how to go about this - can you recommend any good links for this?

I have seen the tool for splitting a database on previous versions of access - we are now on 2010 but with an mdb database.

Is splitting the database a simple operation? Are there any obvious pitfalls to look out for or any simple tips for going about it?

cheers

Phil



________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, 11 May 2012, 14:33
Subject: RE: [MS_AccessPros] Disable F11

Phil-

Oh, my! It sounds like you have multiple users sharing one copy of the "code" part of the database. You should NEVER do that. Each user should have his or her own copy of the database that uses linked tables to a shared "tables only" file on a server. Letting multiple users share a databae is just asking for corruption.

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

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

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Phil Knowles
Sent: Friday, May 11, 2012 3:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Disable F11

Hi John

OK I can live with setting it manually but I still have a problem if what I said before is happening.

ie I set the value. I then have to close the database session (ie get all the users off or wait until the last user comes off) and then start a new database session with the changed option setting. But this option setting will apply to all users who log on to that database session.

If this is the case it is no good for restricting the use of the F11 key

My only hope is that the option setting and resetting don't take effect for a complete database session but apply for the user who joins a currently open database by starting Access on his own PC and apply for that access session only.

Do you see what I mean and do you know which is the case?

cheers

Phil

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, 11 May 2012, 13:49
Subject: RE: [MS_AccessPros] Disable F11

Phil-

Ah, I didn't check that. It means that you have to close and reopen the database for the setting to take effect. But "Allow Special Keys" (and any other variation I tried) isn't a valid argument anyway. I couldn't find that option in any list for any version since 2003, so you probably can't set it in code.

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

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

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Phil Knowles
Sent: Friday, May 11, 2012 2:14 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Disable F11

Hi John

It would appear that the 'allowspecialkeys' option is only checked and applied when you open a database - and if you change the setting, it only applies from the time the you next open the database.

What I was wanting to do was to set its value to true or false depending on the currentuser() which I would do on OnLoad event of the startup form. This, I assume is after the options have been set for this usage session of the database.

I suppose therefore that, in a multiuser environment it will either be on or off for all users who log on during that session of the database being open and can only be changed when the last user in that session logs off.

I am confused now - because if this is the case then I won't be able to do what I want ...... ah unless it doesn't mean the opening of the database if it is already open, it means the starting of the access program by another user.

If you can clarify this for me I would very much appreciate it

cheers

Phil

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, 11 May 2012, 11:47
Subject: RE: [MS_AccessPros] Disable F11

Phil-

The link wrapped in the reply, so it's not complete. Try this:

http://tinyurl.com/cxuju38

As for setting the option "on the fly," take a look at the SetOption command. It's pretty simple:

Application.SetOption "<option name>", Value

Where Value is usually True or False (-1 or 0).

You can find a list of the option names here:

http://msdn.microsoft.com/en-us/library/aa189769(v=office.10).aspx

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

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

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Phil Knowles
Sent: Friday, May 11, 2012 11:57 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Disable F11

Hi John

Thank you for that - I think the clearing of Use Special Keys may be OK but it would be better if I could do this programatically based on the user who logs on rather than manually - is there any way to do this?

I understand what you mean by setting the allowbypasskey to false but the link you gave me doesn't seem to work?

thanks again for all your help

Phil

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, 10 May 2012, 10:37
Subject: RE: [MS_AccessPros] Disable F11

Phil-

In Options / Current Database, clear the Use Special Keys option. Also set
AllowByPassKey to False to keep them from holding down the Shift key when
opening. See:

http://office.microsoft.com/en-us/access-help/allowbypasskey-property-HA001232717.aspx

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

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

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of pdk444444
Sent: Thursday, May 10, 2012 11:19 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Disable F11

Hi

I would like to disable the F11 key for some of my users when they log on.

I have already disabled the ribbon (thanks to a previous post!) by adding code
to the startup form for these users.

What is the best way to do this?

Thanks in advance

Phil

[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]

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar