General :: Lock Record After Approval
Jan 26, 2015Is 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 Replies
ADVERTISEMENT
General :: Way To Get Access To Immediately Lock Record
Aug 15, 2013I 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?
General :: Check Box Event - Lock Textboxes Depending On Each Record
Aug 30, 2013I 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
Find First Date Approval
Mar 28, 2008I have a query based on an SQL database that our company uses to document problems and resolutions. I need to run a report that will show all the reports that were completed in the last 30 day. The field that the approval date is documented is called dbo_approved. Sometimes a report is approved and then at a later date reopened to add something then approved again. The design of this database is such that the first approval is one record and the second approval is a different record. So, using a normal query I will find some records that were previously appproved which I don't care about. I only want a list of reports that were approved for the first time within the last 30 days. Is there a criteria I can use in my query to only look for the first approval date?
As always I appreciate the help.
Jim
Forms :: How To Set Up Approval Process With ACCESS Form Features
Jun 10, 2015I am considering the possibility of revamping the employee onboarding & off-boarding process for our organisation to make it more efficient.
Current State: We use InfoPath forms in SharePoint Servers 2010 to handle onboarding/employee change/off-boarding requests submitted by the related department. With the Workflow process, the respective manager will receive email to approve the requested intake form and once it is done, the form will be assigned to someone in the business support team for processing. Once all the required logistics are completed, we shall enter the new hire's profiles into our MS Access employee database through an employee input form.
It works well although it seems like a duplication of work since the support team has to manually input the employee information, which is already captured on the InfoPath form, into the Access database. We also need to align the field options (such as data on drop down lists) in the InfoPath form with similar field on the input form in the database whenever there are new field added or changes made on existing fields.
Future State: I wonder if there is a way in Access to set up a similar request/approval process so that we can get rid of the InfoPath form when the requester can input the employee information on a onboarding intake form in Access with data stored in a temporary table. After the request is approved and subsequently completed by the business support team, we can say, click a button and transfer the employee data from the temporary table to the employee table. Of course, some sort of validation rules should apply before the transfer takes place to ensure data integrity.
I think the major challenges would be to build an approval process within Access to provide similar notification features as from InfoPath.
I know this might be a wild thinking but just want to look for possible options to save manual work and improve the efficiency of our process.
Record Lock
Dec 1, 2005I 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.
Lock Down Record
Feb 2, 2005Hi 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 RelatedCant Lock Record HELP!
Jun 15, 2006Hi 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
General :: How To Lock Access DB
Jun 6, 2014how to lock access DB Tables ,Queries, Report so other's can not import them to other access database (without encrypting my database with password ).I've noticed when forms have VBA codes it cant be imported if they locked by password(VBA) !
View 7 Replies View RelatedGeneral :: Possible To Lock View Design
Jan 16, 2015is it possible to lock the " view design" the user at present could run a query and the view the design and change it.
View 2 Replies View RelatedGeneral :: Lock A Table In MS Access?
Aug 29, 2014Is it possible to lock a table/macros/forms/reports in MS Access?
View 3 Replies View RelatedConditionally Lock Record
Apr 11, 2005OS/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
Lock Edit Record
Dec 31, 2005Hi,
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.
Lock A Record Through Application
Dec 13, 2006Hi
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
Record Lock When Appending?
Jul 6, 2015It 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.
General :: Lock Picture Of Employee In A Form?
Apr 11, 2013How can I lock a picture of an employee to his Employee record?
View 5 Replies View RelatedGeneral :: Lock The Open Navigation Pane?
Jan 9, 2014I want to keep the navigation pane open for use by the users, but I want it locked so that the users can't click on the top menu and change the pane's display from All Access objects to any of the other choices.
LockNavigationPane set to Yes is not the solution as this only prevents people adding, deleting and moving objects (such as tables/querys/forms).
General :: How To Count Fields With Records And Lock Them
Feb 11, 2014I have a terrible skill in this but I am doing my best to find ways. But I am running out of time in the development stage. I have the following form and table:
Tables:
Eqpt
EqptHistory
Forms:
frmEqpt
frmHistory
frmEqpt is the Mother form and frmHistory is the subform connected thru eqptID. Now what I want to do is count the records in the frmHistory and Locked the fields for editing. If it is new records, the fields will automatically unlock.
How do I do that because I can't find a way to count the fields with records and lock them.
General :: VBA To Lock Bound Date Box On Form
Feb 19, 2013i 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...
General :: Lock Date In Table And Query
Feb 11, 2014I have a field that generates a date from when the first input is put into another field.
I know and can lock the "date" field in the form but is it possible to lock that date in the table and query?
General :: Lock Individual Records After Saving
May 4, 2014I have 4 users all with the same rights. What I want to do is lock each individual record created by each user from the other 3 users after they have been saved ( I am not referring to record locking/table locking while updating/creating ). i.e., They can all read each others created records BUT only update/modify their own created records. They all have individual passwords to log in.
View 4 Replies View RelatedCombox Filter Then Lock Record
Oct 10, 2005Hi
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
Freeze/lock One Record In Subform
Dec 14, 2004hi! 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
Modules & VBA :: Lock Record After Update
Mar 2, 2015I 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 RelatedGeneral :: Lock Archived Records To Prevent Editing?
Dec 12, 2012I want to lock archive records so that they can't be edited, however I want them available to users for viewing. So for example if the file is "closed" the record can not be changed.
View 5 Replies View RelatedGeneral :: Lock Down Application By Saving As ACCDE File
Sep 29, 2012Trying to lock down an application by saving as ACCDE file. Saves OK but when you load application none of the controls work. I.e. button clicks do not launch "Open Form" or " Print Report" commands.But in ACCDB format application works flawlessly.
When I tried on a different machine I get an error message that says too many Table IDs. Odd since I only have 3 forms, 3 tables and 3 reports. Lots of DoCmd's and switching between the 3 forms but not sure why this would create "too many Table IDs"?