Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / January 2005

Tip: Looking for answers? Try searching our database.

Editing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dale@community.nospam - 27 Jan 2005 19:35 GMT
I have a form that shows one record from a table at a time. I want to
know if I can turn off and on the editing of these rows. Some rows I
want to allow the user to edit others I do not. Any help is appreciated.
Rick B - 27 Jan 2005 19:46 GMT
You can use an if statement in the "current" event to set the locked value
for each control based on another field.

In other words, if you have a checkbox on your records called "complete"  or
"locked"  you could test to see if this was checked.  If it was, then you
would set the controls locked value to true.

Since you don't tell us how you'd determine which rows could be editted and
which can't, it is difficult to give you a detailed answer here.

Rick B

> I have a form that shows one record from a table at a time. I want to
> know if I can turn off and on the editing of these rows. Some rows I
> want to allow the user to edit others I do not. Any help is appreciated.
dale@community.nospam - 27 Jan 2005 19:52 GMT
Rick,

It will be based on an id column. If the id is less than a certain value
it will be non-editable otherwise the user can edit them. The table has
3 fields. The id, and abbreviation and a text column. If I understand
you correctly I can set the field to locked for the abbreviation and the
text column based on the id column in the current event.

Dale

> You can use an if statement in the "current" event to set the locked value
> for each control based on another field.
[quoted text clipped - 11 lines]
>>know if I can turn off and on the editing of these rows. Some rows I
>>want to allow the user to edit others I do not. Any help is appreciated.
Rick B - 27 Jan 2005 20:03 GMT
You got it!

something like...

If ID < 1000 Then
 Me!abbreviation.locked = true
 Me!textcolumn.locked = true
Else
   Me!abbreviation.locked = false
 Me!textcolumn.locked = false
End If

Rick B

> Rick,
>
[quoted text clipped - 21 lines]
> >>know if I can turn off and on the editing of these rows. Some rows I
> >>want to allow the user to edit others I do not. Any help is appreciated.
dale@community.nospam - 27 Jan 2005 20:06 GMT
Thanks

> You got it!
>
[quoted text clipped - 47 lines]
>>>>know if I can turn off and on the editing of these rows. Some rows I
>>>>want to allow the user to edit others I do not. Any help is appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.