How To Lock A Form For Changes?
Aug 24, 2006
I made a table containing information about products (price, amount, supplier,...). The most inportant info is the order number (cause it's unique).
Then I made a form, containing a combo-box and several text-boxes. The idea is to find a record using the combo-box, and vieuwing the information of that product in the form. This works, but a problem occurs: the order numbers change each time in a single number (I guess the autonumber). How can I solve this problem so that my combo-box is still available for searching, but no changes can be made in the table that is the source for the form?
View Replies
ADVERTISEMENT
Jun 13, 2005
I need to lock and unlock a a few text fields with a CMd Button.
and i do know about the allowedits thing, but i only need to apply this to a few fields on my form.
can some one throw me a clue?
View 2 Replies
View Related
Jun 19, 2006
Hi,
I am trying to open my form locked and have the uers click a button to unlock the form to enter data. The way i do it now is have 2 forms one set to allow edits "yes" the other set to "no" and then have a button for each
This is working ok but i would like to tidy things up a bit and get it to one button.
I struggle with programming but i will do my best to understand any posts.
Thxs for any help
Adz
View 1 Replies
View Related
Jul 7, 2014
I want to lock a form but keep it visible when a 2nd form opens in front of it. I would also like to keep the 2nd form on top. How to do these 2 things?
View 14 Replies
View Related
Sep 12, 2014
Is it possible to lock a field in a form after the user has populated the field? So for example, I have two date fields and I want them to be locked after the user has entered values on those fields. I want to avoid the user to come back in the future and change those fields. However I would like the database administrator to be able to change those dates when needed. How do I do this?
View 5 Replies
View Related
Feb 28, 2006
Apologies if I am covering old ground here but unfortunately I cannot find a suitable solution after searching the forum.
Basically my switchboard on Open includes DoCmd.Maximize so that the switchboard does indeed open on full screen. However, say I then leave my database open and work on a different application on my PC then when I click on my database on the taskbar then the form is not longer full screen.
So what I am basically asking is, is there a way of 'locking' it to appear full screen even if I flick between applications on my PC?
Many thanks in advance,
Paul.
View 6 Replies
View Related
Aug 7, 2013
I want to incorporate a button that locks a certain portion of my form but my form is still quite long...
Is there a way which I can lock multiple fields at once or do i have to do:
Code:
Field1.Enabled = False
Field2.Enabled = False
Field3.Enabled = False
Field4.Enabled = False
and so on...
View 4 Replies
View Related
Apr 11, 2013
How can I lock a picture of an employee to his Employee record?
View 5 Replies
View Related
May 11, 2015
I have a data entry form that I would like to lock all fields until the Contract Number is entered.
to see if I was on the right path I tried something very simple,
on current
if me.contract_num = null then
msgbox("enter contract number")
end if
but that didn't even work
View 8 Replies
View Related
Feb 19, 2013
i want to use vba to lock or diable a date box on my form.
I have used[button].Enabled = False
This works ok for buttons but doesn't seem to work for my date
fieldMe.OrderDate.Enabled = False
I get an errormethod or data member not found. it highlights the .Enabled part...
View 7 Replies
View Related
Jun 29, 2015
I'm trying to lock a checkbox when the forms open and depending if one has role as admin, it should unlock it.When I add the below code in the on open form I get error:
Code:
Me.lock_case_admin.Locked = True
Me.lock_case_admin.BackColor = 12632256
This is the part that should onlock if it is admin:
Code:
Me.lock_case_admin.Locked = False
Me.lock_case_admin.BackColor = 16777215
Maybe it is me, or the checkbox is giving the error that causes the dialogbox to open to to choose the ID nr.
View 5 Replies
View Related
Aug 4, 2015
I'm trying to lock certain fields on my form based on the value in a particular field. It seems to work the first time but applies itself to all other records in the database from then on!
The starting point is a command button that sends an email and makes Me.DPLLock = 1. The corresponding table entry is formatted as a number.
The code is...
Private Sub Form_Current()
If Me.DPLLock = 1 Then
Me.OR_Name.Locked = True
Me.OR_Sales_Order.Locked = True
Me.OR_WO_No.Locked = True
Me.OR_Qty.Locked = True
[Code] ....
Ive tried Me!DPLLock with the same result.
View 7 Replies
View Related
Jun 13, 2013
I would like to be able to lock a form's field temporarily until certain information has been added to other fields. Once the required fields are complete, I want to be able to allow the field to be updated.
Here is a simplified version of the table fields (only including relevant fields):
tblContacts
LastName (Text, Required field, Duplicates OK)
FirstName (Text, Required field, Duplicates OK)
CurrentEmployee (Yes/No field)
Basically, I don't want the user to be able to update the CurrentEmployee field in a new record until the LastName and FirstName fields have been completed.
The reason I want to prevent this is that when CurrentEmployee field is updated, the record is then assigned a ContactID number (PK autoID field) which means that my subform is assigned an ID# and the result is messy if the user decides to abort the creation of the record.
View 7 Replies
View Related
Oct 25, 2013
I am looking to completely disable a record when a specific Yes/No tick box is checked.
By that I mean all form fields are locked and disabled when the Yes/No tick box is checked (Yes)
View 2 Replies
View Related
Mar 24, 2014
I have a form with several subforms within (tabbed subforms). I've used the code:
In the Current event of the parent form -
Code:
Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = False
In the Current event of each of the subforms -
Code: (THIS NEVER WORKS FOR ME - RUNTIME ERROR)
Me.AllowEdits = Me.Parent.AllowEdits
Me.AllowDeletions = Me.Parent.AllowDeletions
Me.AllowAdditions = Me.Parent.AllowAdditions
In the Click event of the button -
Code:
Me.AllowEdits = True
Me.AllowDeletions = True
Me.AllowAdditions = True
So the main form is locked upon opening and unlocked with the click of an unlock button. How to apply this to the subforms as well. They just stayed unlocked the whole time.
View 14 Replies
View Related
Feb 15, 2014
I am trying to lock records on a form and subform after a checkbox has been ticked, have used the code below from a previous post.
Private Sub Form_Current()
If Locked = -1 Then
Me.AllowEdits = False
Me.AllowAdditions = False
Me.AllowDeletions = False
[Code] .....
This is locking the Main form records is there a way to code this so that the fields on the subform are also locked when the checkbox is ticked?
View 7 Replies
View Related
Oct 24, 2005
hi, i would like to be able to prevent a user from being able to change a field (lock a field) in a main form if a field in a subform is complete. (the field in the subform is named: "new_weekly_base" if this is complete then i would like the field: "weekly base" to be locked on the main form. is this possible?, please help.
the main form is named: "SCREEN-MAIN"
the subform is named: "SCREEN-SUBFORM"
(the main form has a button on it which loads the subform.)
ive tried the below code but it doesnt work, any help would be excellent.
-------------------------------------------------------
Private Sub Form_BeforeUpdate(Cancel As Integer)
If [NEW_WEEKLY_BASE] >= 0 Then
With Me.WEEKLY_BASE
.Visible = True
.Enabled = False
End With
End If
End Sub
------------------------------------------------
View 4 Replies
View Related
Apr 22, 2006
Hi,
I create the datasheet form,
I know how to lock the field, but it lock the whole column of the field.
I want to lock the field except the last record field only.
Can I do that?
eg.
ID Field1 Field2
1___a______b
2___c______d
3___z
I want to lock the field2 except the ID=3
Please let me know, thanks.
View 1 Replies
View Related
Oct 30, 2005
My company has asked for an issue tracking database with the requirements that if is someone is edditing records it locks that block down until that user is done. I don't have any idea how to do it. my db is set up this way.
tables
tblPolls
tblIssues
Querries
qryPolls
qryIssues
qryFindPollsByID
qryFindPollsbyName
Forms
FrmFindPolls
FrmSearchResultsbyId
FrmSearchResultsbyName
FrmIssueTrackingMain
FrmIssueTrackingSub
The Form Issue Tracking Main has the Sub form IssueTracking Sub
Here users enter the issues in the sub form. The forms are linked by Poll ID
Is there a way to lock all the records with the same pollid in the tbltblIssues. Also to check who is editing them at the time?
View 2 Replies
View Related
Apr 5, 2006
I've set up a database for use by a team of approx 10 people. I've got problems with locking records so that only 1 user can edit a record at one time. This is happening in a form with a subform included... Can anyone help?
View 6 Replies
View Related
Aug 16, 2007
hello,
Access gives me the following error:
runtime error 3326 this recordset is not updatable
How do I make a recordset UPDATABLE?
2 days ago, I was able (from front end file) to open a table (in the back end in another computer) and modify the records or add a new one. Yesterday, Office 2007 was automatically updated from the internet, and now I can open the tables but it locks me (it doesn't let me modify or add anything)
Does anyone have any idea of what's going on and how to fix this?
thank you
View 6 Replies
View Related
Oct 13, 2004
hi,
i have created a table with 2 records.i want to lock the record such that nothing can be done with the existing records but allows to add new records.wat should i do??
thank u
View 3 Replies
View Related
Nov 5, 2005
I want to lock a table to disallow further records.
I want to have only one record (I would have created this rec by myself) to store initial conditions and infos such Username/company etc.
Any ideas?
I'm also interesting in other solutions than locking a table if sucj a thing is not possible or nt functional.
Tnx in advance
View 3 Replies
View Related
Dec 1, 2005
I have a created a database for insurance policies.
I'm using a form in the database to edit the data in the underlying table.
I use "pessimistic lock" in the database and in the form.
The database runs in a multi-user environment.
My question is the folowing:
When a user is editing a record, it is obvious that this record is set to
lock in the table (--> pessimistic lock), but the 4 records that are right before this record
are also locked too!
There is nobody else editing at that same moment in the database and it is
not a one-time occurence!
Can somebody help me out with this one... I'm realy desperite and I
searched the entire forum.
View 2 Replies
View Related
Apr 12, 2007
I'm working on a database that calls on a table of zipcodes. All of these zipcodes have latitudes and longitudes connected to them..... I've searched around but cant seem to find anything on locking a table. Is it possible to lock down a table so changes cannot be made?.....(until I need to make them)
View 1 Replies
View Related
Aug 30, 2007
hello to all
i want to lock the tables and queries of my database in access so the users cant modify any information
View 1 Replies
View Related
