Locking A Record Via An Option Button
Oct 11, 2004On my form is an option button called "optClosed". When the option button is selected, I want to lock the current record so that data cannot be changed. Is this possible?
View Replies
ADVERTISEMENT
Locking A Record Via Button
Mar 24, 2006Hi all,
I have created a form using Access 2003 which users have to enter data into.
What I want is a button on the form which will display "lock record". When the user clicks this it will lock the record so that another user can’t accidentally change the field values. If they do want to change the field values the will have to press another button displaying “unlock form”
Is this possible and how?
Cheers
Option Button ??????
Jun 6, 2005Lets say that I have a large list of locations in a listbox. What I want to do is to be able to have an option button that I can press in that will sort these locations. Like 3 or 4 different buttons, lets say like retail, finance, ect. Anyone know what kind of code I might have to use to make these sort on clicking the option button?
View 4 Replies View RelatedOption Button - N/a
Mar 23, 2006I'm working on a survey database, I'm having the users select the opton button to rate (1 - 10). Then as an after thought, I thought I would add a button that says N/A or doesn't apply. Course option buttons store numbers.
ANy idea's on how to accomplish this? What ever value gets stored I wouldn't include it in the results.
The Option Button
May 30, 2006Hi peeps,
I am encountering a few problems when I'm using the options button on a form.
Is there a way for the options button to display a different value instead of a -1 when the data is transfered to a linked table? i.e Good or Poor or Fair?
Also can a number of option buttons have the same control souce? at the mintue I have three buttons pointing at one control souce and when I select one of the buttons they all get selected.
Any help will be much appreciated.
Option Button
Dec 7, 2006I have a table that has 300+ peoples names on it. Each of these people has a region they belong to 1,2,3,or 4. I also have a form that has 3 combo boxes that are linked to this one table. This information is sensitive and can change by importing new data as well. Is there a way that I can add 4 option buttons, depending on what the user clicks on Opt1, 2, 3, or 4... that is what populates the combo boxs? This seems rather simple, but I can't figure it out.
View 1 Replies View RelatedValue Of Option Button
Jan 24, 2006Hello,
how do I reference the value of an option button in an option group?
i tried this:
Code:If [exact] = -1 Then where = where & " AND [SerialNumber] = " & Me![serialno] ElseIf [exact] = 0 Then where = where & " AND [SerialNumber] = " & Me![serialno] Else where = where & " AND [SerialNumber] Like '*" & Me![serialno] & "*'" End If
attached is an image of the form.
thanks
Locking A Record
Mar 14, 2008is it possible once a record has been entered, to lock it so that it can not be changed by just anyone but that the administrator could change it using a password?
View 6 Replies View RelatedLocking Record
Dec 19, 2006Had a good look at previous posts but couldn't find exactly what I am after.
Having entered a record I don't want users to go back and edit/amend the input. I can see how to lock and unlock records but controlling this wilt say a checkbox also means any user can 'uncheck' and edit. Is there a method to restrict who can unlock ('uncheck') and edit a record, other than using Access Security permissions.
Thanks
RussG
Record Locking Help Please!
Dec 20, 2006I can't do nothing in my database because it keeps saying users have it open. There is nobody in the database though. I open up the file and saw two admins names and I deleted them both because we out of the database. The database is on a network drive and when I try to do any updates I get the message "Can't save changes or make changes because the database is open"
I DON"T KNOW WHAT TO DO, FOR THE LOVE OF GOD SOMEONE HELP ME PLEASE, Help me Jesus, Help Me Oprah, Help Me Tom Cruise!
Locking A Record
Feb 22, 2008Hi everyone.
This is my first post and I am really hoping someone will be able to help me.
I have created a database for a friend and multiple users will be using it. I would like to know if anyone is able to assist me in being able to lock a specific record when a particula option on a combo box is selected.
For example:
I have a combo box with several status'. Open, Pending and Closed.
Once the status is changed to closed, can that record be locked to unable ant further editing?
Thank you very much in advance for your help!
Option Button Unclick
Feb 2, 2006Hello,
Does anyone know how to unclick an option button on a form after a selection has been made?
One option is to go to the form and delete it there. But I am looking for a more effective way.
Thanks!
Grey Option Button
May 23, 2006Hi,
I have a group of option buttons. A user can select more than one. However, currently all of the option buttons have a grey spot in them except for the first one which is blank. I want all of the option buttons to be blank.
Any thoughts?
Thanks
Calculation Using The Option Button
Jun 14, 2006Hi there guys,
I have set up a form that is going to be used as a survey.
I have 19 questions that need to be answered and have set up an option group for each question containing 5 option buttons in each.
Is there away to calculate a total score?
for example if all questions were answered using opt5 then the total in the textbox would appear '95'
Thanks for all your help!
Record Locking Problem
Jan 28, 2007Hi all,
I have a split database, with identical front end databases that have tables linked to the back end database. All forms are all located in the client databases.
Both databases are set to "no locks" (I believe this is referred to as "optimistic" record locking?) and are set to "shared" open mode.
However 2 seperate users cannot open the main form, even when opening different records - it comes up with the record locking error message.
Question - The form they open is filtered to show only one record (as selected on opening the form) - will this lock the whole table or just the one record it is looking at?
I'm not sure I've explained myself brilliantly here - I'm not up on all the lingo! If you don't understand please say & I'll try to explain better.
Record Locking Error
Feb 14, 2006:confused: I created a data base in which 4 users enter information using a form. I have no record locking applied. When 2 or more of the users enter the form at the same time but have not entered any information they get a record lock error when one of them tries to enter data. The company wants to open this up to more people so I need to stop this from happening. Any ideas? I'm using access 2003 and windows xp.
Is there a way to assign a new record upon opening the form rather than waiting for data to be entered? I think this would be my last resort because it could create alot of blank records. All help is appreciated.
Thanks
John:confused:
Tables :: Locking On New Record
Jun 14, 2013I've created a database and split it so that the data tables are held separately. Everything works fine apart from when 2 users simultaneosly try to create a new record on the same table. I'm guessing this is a record locking issue but can't work out what I should be amending.
View 4 Replies View RelatedOption Button Description Table
Nov 13, 2007Option Button Description table
I would like to create a table containing description value of my option button group.
This is my description table:
tblLenkeDESC
IDLenkeDescLenkeDESC
1Lenke 1
2Lenke 2
3Lenke 3
4Lenke 4
5Lenke 5
6Lenke 6
And this is my table containing selected option from the form:
tblLenke
IDIDNameLenke
114
225
336
441
552
How can I associate description with the selected options?
Many thanks,
Debbie
Option Button Linked With Combo Box
Jun 28, 2006Morning folks,
Todays problem is as follows!...
Is there away to set the values in a combo box depending on what option button you have selected.
What I would like is to select an option button in an option group then that would trigger certain vaules in a combo box. And if I selected another option button it would change the values in the same combo box?
So if I selected optWhite, the values in cboEthnic = British AND Irish AND Other
If I select optMixed, the values in cboEthnic = White and Black Asian AND White and Black Caribbean etc...
Hope this makes sense.
Forms :: Option Button To Allow Yes / On But Disallow No / Off
May 7, 2015I have a form that is linked to a table. The form show an option box that is by default set to off. This option button links to a yes/no field in the table.
I want to allow a user to change the state of the option box from off (no/false) to on (yes/true), but once it is on, it should not allow the user to switch it off.
Forms :: Option Button String Value
Aug 3, 2015My frame name is "Frame1" with Option buttons "Circle" and "Square"; My code line : Name = me.Frame1.however "Name" get a value of 1 or 2 depending on the selection.how I can get a return of the String Values instead of the Numeric values.
View 3 Replies View RelatedAccess Check Box And Option Button
Apr 25, 2013I'm new to access. I have created table with following fields.
ID No, Name, Address, Gender, Favorite Food
I want to create form to insert data into tables. I have used option buttons for Gender and Check boxes for Favorite Food. But data didn't insert to the table specially option button and check boxes data didn't insert but other data successfully inserted into the table.
Database1.accdb
How To Use Option Button To Store Value Into Table
Dec 9, 2013I want to make option button in access to allow user choose status like: Single, Married and Widower
Single
Married
Widower
When user choose the value must save into table. How to do this?
MS Access Record-Locking Information
Mar 31, 2006Hi,
I have a question.
Does anybody know about "MS Access Record-Locking Information"?
And, the file extension is .xxx
Only one person can open the file.
Does anybody explain to me and teach me how to make/solve it?
Or, offer the link about it to me?
I want to know that.
Thanks a lot.
Access Record Locking Confusion
Oct 6, 2006In OPTIONS -> Advanced I have the option Open Database using Record-Level locking ticked.
What is strange is record level locking works on Form1 (Form1.recordlocks= Edited) as long as Form2 has Form2.recordlocks = No Locks. If I change the Form2.recordlocks = Edited, Form1's locking becomes page level locking.
This is even true if Form2 is not open...
Additionally, Form2's locking is always page level locking if Form2.recordlock = edited.
I would like all my forms to perform RECORD level locking not page Level locking. How do I accomplish this.
I've been trying to resolve this issue for about 2 months now but no answers from the community.
Thanks for any comments.
Record Locking Error 3009
May 10, 2005Hi All:
I have a form that at certain times, requeries tables to update pricing. My problem, I have now found, is if users access this form at the same time (even if they are accessing different records) the second user will get error message 3009: "You tried to lock table while opening it, but the table cannot be locked because it is currently in use. Wait a moment..." when requery code runs.
Does anyone have any recommendation on how to handle this? Anyway around this? I am at the end of a very long creation process and hope I don't have to reinvent the wheel. I'll hold my breath! Thanks!
ps I have record-level locking set as well as edited-record record locking