datasheet lock and paste

[JML]

How do I able to locked users from pasting records from column datasheet to
another column? My case is I have a form that has a check box that determines
when it is checked, the subform datasheet will be locked from users to edit,
otherwise they can edit. I done this by locking each field in the subform
successfully, but I also want the fields to be Enabled as well. Each field
are locked and enabled, the problem is when you select the column of a
datasheet and copied it to clipboard, then paste it to another column (which
the field are already locked), ms access still allows it to paste to that
column. Does anyone has the solution for this? Please help.

[Tom van Stiphout]

On Thu, 01 Nov 2007 13:03:16 GMT, "JML" <u38722@uwewrote:

Assume your checkbox name is chkLocked, and your subform control name
is subfrmData. Then write in chkLocked_AfterUpdate event:
subfrmData.Locked = (chkLocked)

As you can see, no need to lock or disable individual controls.

-Tom.

>How do I able to locked users from pasting records from column datasheet to
another column? My case is I have a form that has a check box that determines
when it is checked, the subform datasheet will be locked from users to edit,
otherwise they can edit. I done this by locking each field in the subform
successfully, but I also want the fields to be Enabled as well. Each field
are locked and enabled, the problem is when you select the column of a
datasheet and copied it to clipboard, then paste it to another column (which
the field are already locked), ms access still allows it to paste to that
column. Does anyone has the solution for this? Please help.

[JML via AccessMonster.com]

I have already tried your suggestion before and it's still the same. You can
still paste records to a 'LOCKED' cell of a datasheet whether you make that
fields' properties locked to true, even while the subform is locked. Try
creating a locked subform in datasheet view and copy two or more cells in a
column and paste it to other columns. Access would allow it to paste. Is
there a way to not allow this to happen? I want the fields to be 'enabled'
and 'locked' because I want my users to scroll around the datasheet like they
were using Excel.

- John

Tom van Stiphout wrote:

>Assume your checkbox name is chkLocked, and your subform control name
is subfrmData. Then write in chkLocked_AfterUpdate event:
subfrmData.Locked = (chkLocked)

As you can see, no need to lock or disable individual controls.

-Tom.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200711/1

[JML via AccessMonster.com]

I'm not used to Access 2007, a lot have change since then including the menu
bar and toolbars. Is there other way to do this? I don't want to upgrade to
Access 2007, most of my clients prefer using the older version, v.2000 or v.
2002

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200711/1