General :: Way To Get Access To Immediately Lock Record
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 Replies
ADVERTISEMENT
Nov 24, 2014
I am building a Inventory Management Application for Tyre Shop. I have SaleMainTbl and SaleDetailTbl both used for preparing daily sale summary. I have Mainform based on SaleMainTbl with TxnDate and Total Amount (Sale) and the TxnDate is in one to many relation with SaleDetailTbl. FormSaleDetail is multiple row(continuous) form that makes billwise summary of each day having -TxnDate--BillNo--ItemSold--Company--Qunatity--Rate--Amount fields. I have inserted this form in FormSaleMainTbl.
So FormSaleMainTbl is Main form and FormSaleDetail is subform. TxnDate in FormSaleDetailTbl is automatically taken from SaleMainForm. I have further added text boxes in Main Form to show company wise sale for each day for which there is a query build one for each company that takes the currently loaded date from FormSaleDetail and calculates the Sale (Sum) of each brand (Company) of Tyres. All these objects are working very fine. However I have to close the MainForm and reopen it for result of query to appear in the appropriate text box in Main form.
Is there way to do this as soon as record is entered or at least at the end of completing the entry of each days sale transactions without closing the form. So the gist of the problem is realtime display of query result in text box on a form or updating the form screen immediately on updating any record or at the most after completing the updating of form but without having to close the form.
View 5 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 9, 2015
I have an equipment database with a "main menu" page. There is a button to add vendor. When this button is activated and vendor name is inserted/saved/closed, the newly created vendor isn't immediately available in another form. I have to close out of the database and open it back up before it's visible. What can I do to make the new record immediately available to other forms?
(adsbygoogle = window.adsbygoogle || []).push({});
View 4 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
Jun 6, 2014
how 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 Related
Aug 29, 2014
Is it possible to lock a table/macros/forms/reports in MS Access?
View 3 Replies
View Related
Jul 17, 2014
I have a database created in Access 2003 about six years ago. I’m the sole user of the Application, which I use to keep track of my personal assignments and to quickly access other resources. A search form was added and tweaked over time until it contained the features I desired. The search form uses a subform to display a list of records, with the ability to click a record‘s "Edit" field to open and update that record.
In about March 2014 we upgraded from Office 2003 using Windows XP to Office 2010 using Windows 7. All users on other Applications that I’d designed and support experienced missing Reference issues, but those were resolved rather quickly. I'd been off work intermittently for about six weeks between April and July and gradually started noticing other issues with my personal assignments tracker that I did not immediately associate with the upgrade. Early on, I noticed that I could no longer delete or rename database objects on several of the databases that I'd designed and support. Eventually, I also noticed that I was unable to create new records and received SaveRecord error messages associated with the subform. I'd encountered SaveRecord issues before and went through previous steps to resolve, but to no avail. Eventually, I came to the conclusion, right or wrong, that all of my recent issues were associated with the upgrade.
I found through online research that my loss of ability to delete or rename Objects was possibly due to the loss of Object Owership and Permissions, which was associated with my Security Workgroup. I confirmed that Ownerships and Permissions had been lost and was unwilling to recreate the database, just yet. No user of other Applications that I support reported any problem creating new records.
I know now that new Access doesn’t have the Security menu item that allows Workgroup creation and joining. After months of online research and trial and error, I was directed to Microsoft Knowledgebase Article 918583, which provided VBA code that allowed me to Run the Workgroup Administrator to rejoin my previously established Workgroup.
After rejoining my Workgroup, everything seemed to return to normal. I could delete and rename records and was able to create new records. After a few days, I noticed that new records were not being displayed in the search form right away. I confirmed that the records were being added to the main table, but still not available in the search form, queries, or reports until after an additional record had been added. In other words, for example, in order to view record 1, a record 2 would have to be added. In order to view record 2, a record 3 would have to be added, and so on. This makes it very tedious to enter new assignments.
I believe the present issue is greater than my search form, because the newest record is not only not available in the search form, but not available in any other form, query, or report. I have no clue where to start.
View 2 Replies
View Related
Feb 6, 2013
I have an Access DB shared through a network folder. It is currently frozen and showing a record lock, however, none of the users have it open. Is there a way to kill the lock so I can restore it?
View 5 Replies
View Related
Feb 20, 2008
I am having a problem running Access 2007 runtime on a workstation. I have set up the 2007 database (.accdb) on our server and am able to connect to it and open it from the pc that has Access 2007 full version installed and it works fine.
I also installed Access 2007 runtime on another PC and was able to open the database using the runtime version just fine.
However, on this other PC, I installed the runtime version, and when I use the command line (msaccess.exe /runtime \serverdirectorydatabase.accdb) to open the database in runtime mode, Access opens for a split second and then closes immediately.
When I just run msaccess.exe, it opens the runtime version and says that I have not specified a database, as expected. So, I am wondering why it is not opening the database when i DO specifiy the database.
If i specify an incorrect directory for the database, it opens the runtime version and a dialog appears telling me that a database was not found, and upon clicking OK, the program closes.
I can say, that when I run it off the computer that works through the runtime version, I get a security warning telling me that there are potentially unsafe elements in the database, but i just have to click OPEN and it still opens it fine.
Perhaps the non-working PC is denying it access due to these security issues?
I can't seem to figure this out, and any help is appreciated.
View 8 Replies
View Related
Jan 12, 2015
Access database 2007: I have a database with some forms init but when i type my username and password to open the main menu to insert data the form shows 1 second and closes the whole database. I don't know whether the problem is the VB code or the microsoft.
View 14 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
Jan 16, 2015
is 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 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
Apr 11, 2013
How can I lock a picture of an employee to his Employee record?
View 5 Replies
View Related
Jan 9, 2014
I 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).
View 6 Replies
View Related
Feb 11, 2014
I 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.
View 9 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
Feb 11, 2014
I 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?
View 1 Replies
View Related
May 4, 2014
I 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 Related
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 6 Replies
View Related
