Forms :: Temporarily Lock Form Field In A New Record

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 Replies


ADVERTISEMENT

Forms :: How To Lock A Field In A Form

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

Forms :: Lock Form Until Certain Field Is Entered

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

Lock Field For A Record If Another Field Is Null

Nov 24, 2005

Lock field for a record if another field is null:

I would like to stop users from entering a date in "Ctrl Closed" unless they have populated "Ctrl Reason" for any given record.

Not sure how to do this.

Any ideas would be greatly appreciated.

View 6 Replies View Related

Forms :: Lock Fields Once Record Is Closed

Aug 29, 2013

I have several forms in my database that have a closed (1=Closed) option button. Is there a way to make all of the fields for that record readonly if the closed option is set to equal 1?

View 3 Replies View Related

Forms :: Lock Individual Record When Certain Check Box Ticked?

Dec 24, 2013

I want to lock an individual record when a certain check box is ticked so it can't be edited again. I've tried setting the form to read only when this check box is ticked on the form OnCurrent event, but this locked every record and I had to remove the code to untick the check box and be able to edit the record again.

View 2 Replies View Related

Lock And Un Lock A Text Field Through A CMD Button

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

Forms :: How To Lock A Field If Equal To A Value

Oct 9, 2014

I'm still using Access 2003 to manage our membership database, is it possible to lock a field(member's name) if the membership is equal to withdrawal or terminated? Possible to use "on click"?

View 3 Replies View Related

Lock A Field On Main Form If A Field On A Subform Is Complete?

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

Forms :: Lock One Field So That Once User Input Data It Never Change Until Closed

Nov 28, 2013

I have a form in Access2000 with 5 text fields which get transferred to the table for each new record. Is there a way i can "LOCK" one field so that once the user has input that data it never changes until closed. I can already lock the field but once i create a new record the field then goes blank.

View 4 Replies View Related

Modules & VBA :: Lock Certain Fields On Form Based On Value In A Particular Field

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

Forms :: Lock A Form On Opening Of Another

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

Forms :: Save Form Record On Move To Next Field In Record?

Jan 15, 2014

After I enter data into one field in a record I would like the form to save the record when I move to another field in the same record. It seems that the record is only saved when I exit it entirely. Is there a way to save a record when moving between fields in that record? Can this be done without using an Event Procedure for each field?

View 8 Replies View Related

Forms :: Validating Text Field On Form Against Another Field In Same Record?

Apr 17, 2014

I have a form where I would like to validate (restrict) choices in subsequent fields.

Example

Combobox choices are Air, Fire, Water, Earth, Space

In the form I have 4 fields = Material1, Material2, Material3, Material4. (all in same record on my table)

Basically I need the validation to not allow duplicates across the 4 fields.

something like....

[Material1] <> [Material2] or [Material3]or [Material4]

I am not sure of the proper syntax for the validation field in the Form Properties. Or if I am even putting it in the right place.

View 3 Replies View Related

Forms :: Move From Last Field In Form To New Record Field On First Page

Aug 27, 2014

What is the best way to move from the last field on the last page of a form to a new record field on the first page?

View 5 Replies View Related

Forms :: Lock / Unlock Form AND Subforms From Editing Data

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

Forms :: Disable / Lock Fields On Form And Subform Based On Checkbox

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

Removing Validation Temporarily

Feb 13, 2006

Hey,

Im doing a booking system and there is validation on booking date field:

>Date()+7 And <Date()+62

This (im sure u know) means that it wont let me book less than one week in advance and more than 2 months in advance. At the start of the year the people who do the booking system put in regular bookings for the whole year (so more than 2 months in advance). it has to be highly automated so I need a macro (or something, i dunno!) to remove the validation so that the regular bookings can be added and then the validation should be put back on at the end. So maybe 2 macros? Please HELP!

View 4 Replies View Related

Forms :: Passing Field Value From One To Another Form That Creates A New Record

Mar 13, 2013

I have several different sub-forms that have a button that opens a new form which creates a new record. Each of the different sub-forms have a field value that needs to be passed to the new record when the other form is opened. I've tried a few solutions, but to no avail. Right now I'm using the macro functionality as follows for one of the subforms:

ACTION ARGUMENTS
--------------------------------
RunCommand SaveRecord
OpenForm frmDocumentNew, Form, , [AssociatedClientTracking]=[Forms]![sfrm_ClientTracking]![ID-ClientTracking], , Normal
OnError Next,
GoToRecord ,,New,
MsgBox =[MacroError].[Description], Yes, None,
SetProperty [AssociatedClientTracking], Enabled, Me.ID-ClientTracking

The problem I think is that I'm creating a new record so the value doesn't get passed. The new record is only created after the user begins to enter data in the new form that was opened.

View 2 Replies View Related

Display Field From A Query On A Form Not In The Forms Record Source

Jul 27, 2005

In short can I display a field on a form that is not in the forms field list without using a sub-form? I am trying to show a value from a query on this form. I tried this in the control source:
[qry_op500_entry_delta]![countofphone model]
I get an error stating that this is not in my field list for the form.
If the answer is No or if needed I can give more information on what I am trying to do.

View 6 Replies View Related

Forms :: Creating Required Field In A Form Before Moving To Next Record

Feb 5, 2014

I have created a Form based from a Table. On one of the fields, I need to be required inside the Form before moving to the next record of that form. I can not make the required field in the table, because I have to append information day to day.

Also, the required field is a combo box option that is limit to the list.

What kind of Code I can do inside the form of the specific field to make it required before clicking onto the next record. It does not matter if the processor closes out of the form before updating, only if moving to the next record.

View 5 Replies View Related

Forms :: Create A Multi-field Search Box That Goes To Record In A Form

Jul 7, 2014

This is what the search box must do:

- Searches 3 fields (StudentID, FirstName, LastName) and jumps to the relevant record.

The closer to the search box in the navigation bar below, the better, so this is what I would really like too.

- A repeat click would take me to the next result/record (if any) with the same criteria
- Instant search as soon as I start typing

View 11 Replies View Related

Forms :: Access Form - Close Field And Duplicate Record

Nov 25, 2014

Access form fields (ID, Name,File_Ref,Mobile,Email, Closed (yes/No)

If Click My Command button at the same auto tick the current record closed filed and duplicate record.

View 1 Replies View Related

Forms :: Condition A Field To Locked On 1 Record Of Continuous Form Subfile

Jun 1, 2015

Access 2002 . Can I condition a field to 'locked' on just one record of a continuous form subfile, based on the contents of a 2nd field in same record?

View 14 Replies View Related

Record Lock

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

Lock Down Record

Feb 2, 2005

Hi all. I have a form that when I click a button is automatically changes a field on another form and then closes both forms. Can I add anything to this button to stop that record from being altered again. IE. when i click on this close job button nobody can ever change the record again. Thanks.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved