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.
3  3725 
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.
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 http://www.accessmonster.com/Uwe/For...ccess/200711/1
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 http://www.accessmonster.com/Uwe/For...ccess/200711/1 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Kent Eilers |
last post by:
I want to follow naming conventions for my controls - i usually prefix combo
boxes with "cbo". When a form is in datasheet view however i do not want
the user to see the 'cbo' prefix in front of the field name.
Is there a way to retain this nomenclature and yet have the view display the
field name (or anyname i want for that matter)?
...
|
by: Fred Ferreira |
last post by:
Hi there
Does anybody know how I can lock the column widths at Datasheet form view?
|
by: sasan3 |
last post by:
Well, I have the lock part figured out.. but how do I gray-out or put
in some type of visual effect that indicated that the row in the
subform is locked?
Thanks.
Si
|
by: excalibur |
last post by:
I'm trying to extract data from a database in VB.net and paste it
directly into a powerpoint slide.
I've tried doing this one cell at a time but that runs too slowly to be
practical (lots of data and a very big presentation) so I want to build
up an array of data, put it onto the clipboard and then paste it all in
one go into powerpoint....
|
by: igniztion |
last post by:
Hi,
When I paste several rows into datasheet view in MS Access, does this
trigger a single INSERT with all the rows, or is it counted as one
INSERT statement per row?
Vegard
| | |
by: Peted |
last post by:
Hi
wondering what is the best way to do this
Need a user to click a button, that sends 3 or 4 string based commands
via a TCP/ip socket link
I can connect to the ip device no problems, am using indy sockets, and
can send information ok
|
by: pradyumn.1 |
last post by:
hi everrybody,
i want 2 make a higly secured guard lock which no 1 can
heck......
here i hav already make a login page, change password
page,and file uploder page with encryption..
bt here i wana , when i store a encrypted file on that
perticular location bt i specially wana that no 1 can
open ,cut,copy,paste of this perticuler page for...
|
by: curran.george |
last post by:
'add one textbox to form1 with Control Source property = ID
'copy/paste the form_load code below:
'Then open the form and then attempt to sort the datasheet
'crashes 2003, error 3450 Access 2007 - I can't find much info on
this... - Can someone explain what's happening and how to fix this?
Private Sub Form_Load()
'2008-01-11
Dim rsx As...
|
by: LucasLondon |
last post by:
Hi,
I'm trying to use VBA to extract underlying data from charts in powerpoint to excel, i.e from the underlying powerpoint datasheet that feeds the chart.
I've found the macro below on the net. It copies the data in each chart/datasheet and slide in powerpoint but I'm struggling with the bit to get the data into excel.
Below it I've...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
