I have a query that calculates price x quantity. That bit is easy. However from time to time my suppliers will issue a detailed quotation (ie lots of items, lots of prices and lots of quantities), then one week later issues the exact same quotation but with price changes and/or quantity changes. I need to show to my client the progression of the costs, so the calculated (price x quantity) column has a cost at (date) heading that needs to be updated regularly. I am looking for a way in my query to lock down the data in in the calculated column at each date, so that when I get a revised quotation, I don't have to re-enter all the items, I just change either the price or quantity. Is there a way to do it ? This is about as clear as mud, but I hope someone out there understands. Thanks for your help.
When a order (identified by orderid) of products reaches a certain status I lock the article numbers (with an orderrule number 1 to many to that order-id) from changing. This works ok, the user can't change the article numbers and quantities. What doesn't work is the fact that they can still add records to that order. How can I get Access that far that they can't add records?
Well the title says it all. I need to create a button to lock the info on the form so it can't be edited and at the same time insert the date. Any ideas?
In a Access 2003 database, I have an "Inscriptions" (subscription) database with a primary key on 2 fields idPersonnel (employee) and idSession. I have made a form so that user can select a session (in a listbox), then one or more employee (another listbox) and suscribe them to that session by using a button, which, on VBA side, first check that there is enough room on the session (defined by "MaxParticipants" field on "Sessions" table, linked to "Inscriptions" table on idSession), then insert data in "Inscriptions" table
This is working fine in a single-user environnement, but fails if 2 people want to join some employees on the same session at the same time, as I have a confirmation message between check and insertion. Therefore 2 users can select employees, get the confirmation message (at this point both are told there is enough room), resulting in having more people than expected joined to the session. Fortuneatly, if both users try to insert the same employee(s) to that table, one will get a duplicate error, but insertion will be made if employees are different.
On another DB engine, such as SQL server, I would use a stored procedure that would lock the table, do the check and the insertion then unlock the table.
But it does not seem to be possible in MS Access. What are the possibilities in MS Access to prevent a session from having more than maximum number of participants ?
Code: (THIS NEVER WORKS FOR ME - RUNTIME ERROR) Me.AllowEdits = Me.Parent.AllowEdits Me.AllowDeletions = Me.Parent.AllowDeletions Me.AllowAdditions = Me.Parent.AllowAdditions
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.
I have a form and I want show a message on the form when the it is locked as another user is editing the data in a particular record.
I know the record selectors show the records lock status but it a very tiny symbol which will mean nothing to the users of the database and anyway I don't want record selector bar on the form. How I would do this???
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.
I want to lock the view of certain tables and queries so that users could not perform any change at their own. Is there any way in VB to protect it with password....
I would like to filter data from a table using a query (from an data input form). The objective is to output all results if input form field is empty and to output results higher or equal to the type in the field if field is not Null. The query code is as follows:
Background I have a query (Q1) that retrives data from a table (Table 1). One of the fields in Table (F1) contains both text and numeric data (ie: 24 eggs). I want to separate these values in Q1.
Questions How can i in Q1 retrive only numeric data from F1 and display that data i a field? How can i in Q1 retrive only text from F1 and display that data i a field?
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
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.
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?
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?
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
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
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.
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.
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)
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.