datasheet lock and paste

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • JML
    #1

    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.

    Tags: None
    • Tom van Stiphout
      #2
      Re: datasheet lock and paste

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

      Assume your checkbox name is chkLocked, and your subform control name
      is subfrmData. Then write in chkLocked_After Update event:
      subfrmData.Lock ed = (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.

        Comment

        • JML via AccessMonster.com
          #3
          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_After Update event:
          >subfrmData.Loc ked = (chkLocked)
          >
          >As you can see, no need to lock or disable individual controls.
          >
          >-Tom.
          >
          --
          Message posted via AccessMonster.c om
          TRIBUN855: Informasi Lengkap Permaian Online Akses VIP Tanpa Uang Asli
          http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200711/1
          TRIBUN855 menghadirkan informasi lengkap seputar permainan online terbaru, akses VIP player, game online gratis, permainan tanpa uang asli serta berbagai fitur dan mekanisme permainan digital.


            Comment

            • JML via AccessMonster.com
              #4
              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.c om
              TRIBUN855: Informasi Lengkap Permaian Online Akses VIP Tanpa Uang Asli
              http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200711/1
              TRIBUN855 menghadirkan informasi lengkap seputar permainan online terbaru, akses VIP player, game online gratis, permainan tanpa uang asli serta berbagai fitur dan mekanisme permainan digital.


                Comment

                Previous template Next
                Working...