datasheet lock and paste

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.

Re: datasheet lock and paste

On Thu, 01 Nov 2007 13:03:16 GMT, "JML" 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.


>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.

Re: datasheet lock and paste

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/Forums.aspx/databases-ms-ac cess/200711/1

Re: datasheet lock and paste

On Nov 15, 10:02 am, "JML via AccessMonster.com" wrote:
> 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.

Access 2007 does not allow me to paste under the circumstances you
describe.

Re: datasheet lock and paste

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/Forums.aspx/databases-ms-ac cess/200711/1

Re: datasheet lock and paste

"JML via AccessMonster.com" wrote in
news:7b4bea78f67dc@uwe:

> 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

Clearly, I miscommunicated.

I did not mean to suggest that you upgrade to Access 2007.

As I am unable to duplicate the behaviour you describe, that is the
ability to paste into a locked control in a sub-form in datasheet view, I
thought that:

a) Others would say, "I can."

or

b) You would examine your form, subform and control and discover that
some anomally caused the behaviour you describe.

Your reply prompted me to bring my coffee down here to the catacombs
where I have a couple of legacy computers. I fired one up and opened
Northwinds in Access 2000. I modified the Orders SubForm, locking
UnitPrice. I was unable to paste into UnitPrice.
I unlocked UnitPrice. I am able to paste into it.

I expect you could do what I did with Northwinds in a few minutes. Then
you could consider, "Is this the problem I described in my original
post?"

Then you could determine if the results are what I describe (not-paste-
able), or what you describe (paste-able).

If you get the results I describe, you could go back to the database
where original problem occurs and determine why.
If you get the results you describe you could say, "The guy knows
Squat!" and get on with life.

BTW, upstairs is Access 2007 and a powerful computer. Down here Access
2000 on the legacy (Celeron 1700) computer is only about six times as
fast. Maybe I'll build a little hut down here and just stay.

--
lyle fairfield


Think free Aim Mail is a good deal? 4 gig storage! IMAP too! I have an
account. It has about two thousand messages stored on Aim's server. But I
can't access the account, nor the stored messages nor new messages. Do I
have the username and password right? I'm pretty sure because I can log
into the account with an instant message program like Miranda or
Trillian. And they can tell me I have fifteen new e-mails. But for two
weeks I can't login with the webmail interface, nor with IMAP, nor with
POP. So, be careful with Aim mail. Cuz there seems to be no recourse.
And, yes, I know the terms I agreed to specify AOL has no responsibility
whatever. But maybe this will help you remember those terms are for real
and your e-mail may disappear forever.