Combox Filter Then Lock Record
Oct 10, 2005
Hi
I have a combo box to select a record on a form.
I would like then record to lock once it is selected via the combox box and the combo box to clear.
If a records is slected again from the combo box it will then show the new record and lock it again.
The problem is users are sometimes using the mouse button to scroll and moving to a different records by accident.
Thanks
View Replies
ADVERTISEMENT
Oct 12, 2005
I ve searched these forums but cant for the life of me find the answer althought there are a lot of posts on combo box filters.
I have MainForm based on tblStaff. I have SubForm based on tblTimesheet.
They are linked by StaffID.
The user selects a Project from ProjectID in the Subform which is filtered to only show Projects assigned to that user. This is done by filtering the combo box by StaffID from the MainForm. Works no problem.
The problem i have is in the next combobox which displays the potential activities for the user. As there are about 80 potential activities i want to filter this based on the Project Role. There are only 5 project roles. I can refer to the project role in either the SubForm query or the ProjectID combobox query but it doesnt work.
I hope this is coherent. Could anyone suggest some code or query parameters for this!?? I'm not an idiot but im beginning to wonder.
Thanks in advance
View 1 Replies
View Related
Jun 29, 2005
Hi every body. I got bounded form as picture below. Initially the form loads all the recod.
I want add a feture to this form so that when i make 4 combo box selection it goes and
load those records that matches that crieteria only . All my controles are in the main form.
I am not using form and subform.I be happy if some one show me how i can switch from show all
mode to filtered mode.(an example higly appretiated)Thanks
http://i5.photobucket.com/albums/y180/method007/comboboxfilter.jpg
( form pic)
View 1 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
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
Jun 15, 2006
Hi All, I've searched the forum and have found a lot of info on locking records/forms. I pulled this from a thread but it doesnt work. I have a subform with many fields with a check box. if the check box is true then I want to lock that record(or the form). I loaded this in the on current event and I can still edit the form and or record.
if me.closed = - 1 then
Me.AllowEdits = No
Me.AllowDeletions = No
else
Me.AllowEdits = yes
Me.AllowDeletions = yes
thanks
View 3 Replies
View Related
Apr 11, 2005
OS/Program :xp/Access 2002
The following problem. Within my main form I have a status field. Dependent of the status of the main field I would like to lock the total record in my sub form at once. Within which event of the sub form could I achieve this and which property locks a total record?
thanks
giovi
View 2 Replies
View Related
Dec 31, 2005
Hi,
I'm new user here and I use Microsoft Access 2003 for my applications.
I use an mdb on a server (datas) and form on station over the network (application).
I would like to lock the record edit by user when this user press "modify" button and unlock the record when this user press "save" button to avoid with the other users modifying the recording.
Is it possible and how ?
Thanks for your answer.
View 1 Replies
View Related
Dec 13, 2006
Hi
I am a little bit confused with locking subject
I have a table in ms access database. it has some fields.
I access to this table through the application
but I want to fetch the information of a record and then lock this record. close the connection and then work on this information
after finishing works I want to update the record and then release the record.
the locks that I read are a little confusing
would you please help me and recommend a solution for this problem
thanks for attention
best regard
View 1 Replies
View Related
Jul 6, 2015
It should be noted that this is a shared database with the BE on a network. I have a process that allows users to create an Agenda for a meeting. In order to make the process more efficient the user selects a drop down box which then prefills attendees for that meeting. All very simple really, until more than one user attempts to run the process.
The issue is that this process runs a couple of queries. One to filter the attendees and then another to combine this information with the agenda information which is then finally appended to the MASTER Data tbl.
Is there a way that I can stop users using this at the same time by either giving an alert to the new users saying please wait and defer the process until the current process has completed and then the new request starts.
View 1 Replies
View Related
Feb 8, 2006
Hi,
I've a unbound combox field in main form, which upon select the subform should display the information. I tried this code but it gives me an error :
Dim strSQLSF As String
strSQLSF = " SELECT * FROM UT_table_EOM_UT "
strSQLSF = strSQLSF & " WHERE UT_Table_EOM_UT.Expr7 = '" & UTEOM_SEL & "'"
Me.UT_Table_EOM_UT_subform.Form.RecordSource = strSQLSF
Me.Requery
Run-time error 2001
You canceled the previous operations
View 5 Replies
View Related
Jan 10, 2006
Hi,
In MS Access, the form,
I make one combox, I want anybody input the value by dropdown list, they cannot input the value by typing in keyboard.
How can I lock to enter the value by typing, but they can input it by dropdown list.
Because, if I lock the field, then we never enter the value, if no lock, then we can enter it either dropdown list option or type in keyboard.
I just want to make dropdown list option to enter the value.
Please let me know, thanks.
View 3 Replies
View Related
Dec 14, 2004
hi! I asked this question before, and i didn't understand the answer.
I have a form with a subform. at first, i disable the subform until the main form is filled completely. Then, I have a button to enable the subform. This button also disables the main form.
My first line in the subform needs to mirror the info in the main form. To do this, i open a recordset, and then use .AddNew to fill in the details.
I don't want this first line to be edit-able or delete-able once it has been filled. How do I lock it from being edited? Also, if I later decide to delete everything on the form, will i be able to clear the whole form if this line in the subform is locked?
Please helpp
View 4 Replies
View Related
Mar 2, 2015
I have a form in datasheet view and on that form I have a yes/no tick box is it possible that when the tick box is ticked it locks the line from further entry.
View 3 Replies
View Related
Jan 26, 2015
Is there a way that when I field gets a password entered into a field the form can be locked so nothing on that record or subform linking to that record can be altered ...
View 7 Replies
View Related
Jun 22, 2006
hi, umm im tring to copy values from a combobox into a textbox so that multilpe values can be saved on the databse.
the textbox it linked to a table, and the combobox uses sql quries 2 get data from a table... i have a command button which then inserts the vaule from the combobox to the textbox.
in the commmand button the vba code used is:
textbox.value = combobox.value
but this only insert one value to the text box i want multiple value one after the other. it just keeps replace the value which is already in the textbox i want it to add on 2 the value in the textbox...
can any1 help me out?
thank you 4 ur time!
purejoker!
View 5 Replies
View Related
Nov 15, 2006
Hello,
I have a simple question with an answer that hides relentlessly from me. I have a combo box on the main form called cboProjects. I also have a subform called SubProjectsDetails. I'm trying to get it to where if a user selects a project from the combo box, the details show up in the subform. The relationships are good and working, and if I add a Find Record button on the form, that works as well. I just don't know the code to dynamically populate the subform with combo box values.
Anyone have any tips?
Thanks
View 2 Replies
View Related
Feb 12, 2007
Afternoon.
I have had a search through the forum however am unable to find anything...
I have two questions:
a) How do I check whether someone else is currently accessing a record / form?
i.e. Opening the form (SchemeDetails) like this:
DoCmd.OpenForm "SchemeDetails", acNormal, "", "", acEdit, acNormal
Forms!SchemeDetails.SetFocus
DoCmd.GoToRecord acForm, "SchemeDetails", acGoTo, tempVal
Can I check if someone else is in the specified record before I open it? Record Locking is (deliberately) set to "No Locks".
b) How do I check to see if a table exists?
i.e. If DataTable2.Exists = True then ...
Or something like this?
Hope someone can help me!
View 6 Replies
View Related
Dec 19, 2013
I use the first record of my table as a blank when the form is opened. Users are supposed to use a drop down to navigate to a record for updating. Some users have populated fields into my blank that i've had to go in and delete.
I'm wondering if there is a way to prevent that first record from being edited.
View 5 Replies
View Related
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
Aug 15, 2013
I have a sales call tracking program.a list of available numbers are displayed to multiple users running the a user clicks on a record to get a call screen displayed with client info they then call the client and try for a sale.
the problem exists that two users can click on the same list record and open up the same call screen - they then both try to call the customer manually on the phone. one agent will get through the other will get a busy signal and record the call as a Busy Call. When the user with the customer is done he tries to record a Sale or No Sale and is met with an error message saying the record has been modified and they cannot save changes!!
I need a way to get access to immediately lock the record when it is clicked so only one person can open the call details screen? What is the best way to lock the records?
View 8 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
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
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
Apr 12, 2013
Is it possible to have a 2 step confirmation process.
I have a yes/no control box to confirm that the record is OK or correct.
Is it possible to have a second process where by I can lock the record from erroneous data entry or editing? Like a "Post" in accounting.
View 3 Replies
View Related
Aug 30, 2013
I have a checkbox which when checked then turns textboxes to locked as below. However when I navigate to the next record which may not be checked the text boxes remain locked. I obviously want to lock the boxes depending on each record. I am navigating via the windows next/back record buttons. How do i do it?
Private Sub Check44_Click()
If Check44.Value = -1 Then
serial.Locked = True
gain.Locked = True
swst.Locked = True
Else
serial.Locked = True
gain.Locked = True
swst.Locked = True
End If
End Sub
View 6 Replies
View Related