Form Locked, Unable To Unlock
Feb 13, 2005
Hi all,
I'm having a problem here and after searching the web, I can't find a solution.
Problem is that I have a form which seems to be locked. None of the fields can be modified. This should be ok except for 1 combo-box.
I have checked all objects settings and all objects have:
Edit/Delete/Add options enabled;
Visible option enabled;
Locked option disabled;
The form has only Fromview enabled and recordlock is off.
There is no VB code modifying a 'locked' status.
Can someone help me out here?
My project is +20Mb so first I'd like to see if there are any things I've forgotten to check before I'll strip and post it.
View Replies
ADVERTISEMENT
May 3, 2005
Hi can anyone help. My database is running on a Citrix server. No real problems except that I am continualy being left with the database apparantly locked by another user. Am unable to delete the LDB file even when no other users are logged on. Is there a way of deleting LDB files in relation to stale Access sessions. I know that in normal circumstances these files close automatically. Problems seems to be occurring when the database is not exited properly or the connection to the server drops for some reason. I've tried loads but can't find a workaround.
Stuart Dennis
View 14 Replies
View Related
Jun 11, 2013
I have a user that is unable to edit records, He can click in the fields but he could not delete or enter data in the fields. He has the ability to edit records but its fields are locked. I created a split database and created a secure front which I distributed it to multiple uses. The other users front end is working fine, expect for the one.
View 2 Replies
View Related
Jun 19, 2006
Hi,
I am trying to open my form locked and have the uers click a button to unlock the form to enter data. The way i do it now is have 2 forms one set to allow edits "yes" the other set to "no" and then have a button for each
This is working ok but i would like to tidy things up a bit and get it to one button.
I struggle with programming but i will do my best to understand any posts.
Thxs for any help
Adz
View 1 Replies
View Related
Jun 22, 2013
On mij registration form I have the option to fill in the name and day of birth, email and GSM number of the partner off the main contact.
But to keep the form nice and clear, I only want to make the fields acceseble when the checkbox from [couple] is checkt OK.
How to make the fields and the Box around it Light Gray, so its very clear it issn't clickable.
The main coller is white BG and Green strokes. (see attachment) When the field [paar] 1 (couple in englisch) is OK then the fields in de eclips 2 are available And I want the collors of the stroke 25% black and de fields disabled.
View 2 Replies
View Related
Mar 17, 2014
I have two forms linked together.
frmMaterialRequest
MaterialRequest
Status
frmHandledBy
MaterialRequest
HandledBy
What I want is to meet the following:
- Form 2 to be locked but its "MaterialRequest" is enabled.
- HandledBy to be unlocked if the MaterialRequest meets the "Status" of "frmMaterialRequest" which is "Approved".
View 9 Replies
View Related
Mar 24, 2014
I have a form with several subforms within (tabbed subforms). I've used the code:
In the Current event of the parent form -
Code:
Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = False
In the Current event of each of the subforms -
Code: (THIS NEVER WORKS FOR ME - RUNTIME ERROR)
Me.AllowEdits = Me.Parent.AllowEdits
Me.AllowDeletions = Me.Parent.AllowDeletions
Me.AllowAdditions = Me.Parent.AllowAdditions
In the Click event of the button -
Code:
Me.AllowEdits = True
Me.AllowDeletions = True
Me.AllowAdditions = True
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.
View 14 Replies
View Related
Aug 3, 2005
Hi:
i have a MS Access aplication that have a vba code with a password.
Now i have a patch (in MS Access too) that will upload this full aplication, but when i try to copy a form didnt work. This is because have password in the vbe code.
someone knows how can i unlock the vbe before update the form and after update the from lock in VBA language?
thanks
View 1 Replies
View Related
Mar 17, 2005
i have an access database in lan and when 2 users are working in the same form and in different record the record will be locked
ex if the first user is changing the date in the fist record the second user cant change another record
http://briefcase.pathfinder.gr/download/adi32/2976/399219/0/test.zip
to check open together the forms table1 table1b and try to change two different records
thank you
View 3 Replies
View Related
Aug 8, 2006
Sorry, i'm an access noob.
I have an ADP with a form in it, the form was working correctly until an ex coworker did something to it.
Now the form is locked, when you goto form view you can only view information. You cant edit or add new records, all the fields are locked.
How do I undo this?
View 3 Replies
View Related
Nov 24, 2006
Hi! I'm certin this is something really simple, but I just can't remember how I've done it before.
I have a combo box called "ReferralReason" and when a particular option ("Other") is chosen from the list in there, I want the text field "ReferralReasonOther" to become unlocked.
Could someone please tell me:
a) do I type the VBA code for this in the properties of the combo, or, the text field? (Does it even make a difference)
b) what do I actually type?? :confused:
Thanks in advance for your help!
View 2 Replies
View Related
Jul 6, 2006
On my first form I have a pull down box and when I select an item and click the add button, the item appears in a locked text box above the pull down box. After I click the submit form button, it goes to another form. On the other form is a similar pull down box and locked text box. So far I got the item selected on the first form to appear in the second form's locked text box.
Again, the second form also has a pull down menu and when I select another item from the pull down box and click the add button on the second form it deletes the first item selected in the first form from the second form's locked text box. The items selected are put in a table. I was wondering if there was some kind of code I can input so the second form's locked text box keeps the first value from the first form and can add additional values when selected through the second form's pull down box. Sorry if this sounds confusing. I really appreciate your help. Thank You.
View 1 Replies
View Related
Aug 25, 2005
Hi there,
I've created a database of our customers and the plan is to have a few of our members of staff working through it doing support calls - there's very little information to get written to the database - just a flag to show whether the customer has already been contacted or not.
The problem I'm having is that as there's a set call order, and as we're going to have multiple users working through it, there's nothing there to stop 2 or more users having the same record open at the same time and customer getting called more than once. I've looked into the built in access record locking, but that is not going to help much as it doesnt seem to prevent the same record being opened more than once - it just prevents them being updated.
Ideally I want the database to set a flag when a record is opened and unset it when the user moves to next record, and have the form I'm using to browse the records just skip flagged ones. However I have no idea how I would go about doing this as I've pretty much just started writing access.
Anyone able to help me here please?
View 7 Replies
View Related
Oct 24, 2005
I have a main form that has 3 fields. They are all locked fields, only to show the user the "person" record that they are looking at. They update to subforms on a tab. The first subform is activities (like from a mailing - received return no forwarding address, received updated address, called us, etc)
The other subform is for addresses, original and updated.
There is a date field for the date of any updated addresses.
What I need to do is allow users to enter activities and move around from main record to main record. The important thing is that if they enter an activity on the subform that is for receiving an address change, I need to make sure that they do not leave the main record, without entering in an updated address for that same date, on the address subform.
The activity subform has a date field too, so the validation part seems like it wouldnt be too hard...
IIF ?subform-activities-field-activitytype = "updated address" (3/code to lookup table) AND ?subform-address-field-date = grrr this is where I get confused.
Then msg "Stop, you must add the updated address for the activity of receiving an address change"
cancel = true
end if
make sense?
Any help would be gratefully appreciated!
View 4 Replies
View Related
Mar 22, 2006
Help! What seems like a simple problem is driving me crazy.
I have a form (one of 2 that are nearly identical) that appears to be opened “filtered”.
When the form opens, none of the controls react to clicks, it does not allow edits. It has a feel as if a master lock is on the form. Finally, a right click to a shortcut menu saw some progress. If I select “Filter By Form” (the current record fields become blank) and then select “Apply Filter/Sort”, the form becomes “normal”, i.e. all fields and controls behave normally.
I have gone over the code of this form and its near-twin and cannot see any differences relating to this problem.
Assuming there is some type of stealth filter at play, Access Help yielded:
Use this procedure to delete any type of filter, regardless of what method you used to create it.
1. Click in the form, subform, datasheet, or subdatasheet whose filter you want to delete.
2. Switch to the Advanced Filter/Sort window (Advanced Filter/Sort window: A window in which you can create a filter from scratch. You enter criteria expressions in the filter design grid to restrict the records in the open form or datasheet to a subset of records that meet the criteria.).
3. On the Edit menu, click Clear Grid.
4. Click Apply Filter on the toolbar. I can not find the “Advanced Filter/Sort” window they talk about. I am assuming that this is a filter issue.
Does anyone have any insight on why this form opens “locked” and what the related filter issue may be?
I have also tried the VBA code:
Me.Filter = ""
Me.FilterOn = False
To no avail.
Any help is certainly appreciated.
Thanks,
JQ
View 1 Replies
View Related
Dec 2, 2013
I have a form that I allow my users to view but not to change any of the records.
As the number of records has grown it's become necessary to add a search function.
My problem is that because the form is locked it cannot be searched.
View 7 Replies
View Related
Aug 2, 2012
My main form was working fine (I could key in data) until I added two subforms. Now the main form will not accept data, but the two sub forms do accept data. I have searched properties of all forms and queries, and I cannot find any suspects.
View 1 Replies
View Related
Oct 19, 2005
:eek: :eek: :eek: :eek: :eek: :confused: :confused: :confused:
I am trying to update a database table via a command button on the main form, that uses tabbed sub forms.
The database gets its data from paradox data tables copied our company's
third-party software. These table files are copied from one location to another to stop the paradox database from locking up and giving me errors during the import process of this database. I then link to these files at a pre-determined location on a local computer hard drive.
When I try to run the code below I get the error about the table being
locked by a user or process. As you can see I have tried adding a pause
incase the files are still being copied but this does not seem to be the
problem.
I have used a msg box to confirm that the copying process has completed before starting the make query, but the same error comes up after I click ok.
Can anyone suggest anything else.
As you can see from the simplicity of the code below I am a beginner so take it easy on me, by not taking knowledge for granted. :)
code:
------------------------------------------------------------
Dim response
Dim stDocName As String
Dim stLinkCriteria As String
response = MsgBox("Are you sure that you want to update xxx with Customer
data from xxx?", vbYesNo, "Perform Update")
If response = vbYes Then
‘pause software to let any pending work to be completed
Sleep (5000)
‘close active form
DoCmd.Close
‘close all active forms
Do While Forms.Count > 0
DoCmd.Close acForm, Forms(0).Name
Loop
‘pause software to let any pending work to be completed
Sleep (30000)
‘delete existing file
Kill "c:folderfile DATA.DB"
‘replace with new file
FileCopy "J:Folderew_DATA.DB", " c:folderfile DATA.DB "
‘pause software to let any pending work to be completed
Sleep (40000)
DoCmd.SetWarnings False
stDocName = "Make_DATA"
DoCmd.OpenQuery stDocName, acNormal, acEdit
‘pause software to let any pending work to be completed
Sleep (35000)
stDocName = "Make_DATA_SUMMARY"
DoCmd.OpenQuery stDocName, acNormal, acEdit
‘pause software to let any pending work to be completed
Sleep (35000)
stDocName = "qry_Update_ Status"
DoCmd.OpenQuery stDocName, acNormal, acEdit
‘pause software to let any pending work to be completed
Sleep (35000)
‘open up main form when finsihed
stDocName = "main-form"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.SetWarnings True
Else
End If
View 3 Replies
View Related
Dec 25, 2013
I have a Main Form which is essentially the based on my child table called tblTaskHistory. The Main Form has a subForm which is based on the parent table called tblTasks. I am using SQL queries to feed the combo box recordsource that is located on the Main Form. The After Update for the combo box populates the subForm which allows the users to look at details of a task before he/she "accepts" it. The problem is that when he/she clicks on the subForm to view the details of the task the Main Form locks up. The user, after interacting with the subForm, cannot make an edit on Main Form now. The user has to close the Main Form and then reopen it to perform the "accept" action. The form works absolutely as intended - that is if the user doesn't click on the subForm - however once he/she clicks on the subForm the Main Form locks up.
View 1 Replies
View Related
Oct 11, 2007
Hi..
I got a access file from a friend of mine, but when i open it in access, i don't see any tables or the standard menu buttons.
The only menu i see, is a docked menu with a couple of submenus, wich in turn open forms, where you can enter data..
How can i see the tables and bva script behind this access file?
I tried F11 and Alt-F11, but is does nothing.
He won't tell me how he did it, because he doesnt like to share what he knows...
Can anyone help me??
Thanx !
View 6 Replies
View Related
May 11, 2014
I have a form with 2 option buttons on it one with year 12 on it and one with year 13. I have a simple form with drop down menus and text boxes allocated for year 12s and 13s. I want all of the year 13 text boxes and drop down lists to be locked if year 12 is selected and I want all of the year 12 text boxes and drop down lists to be locked if year 13 is selected. I do not want to over complicate the form by hiding parts of it or having a new form open depending on the option button selected.
View 9 Replies
View Related
Sep 28, 2014
I want to lock down and unlock the full menu based on a password..
For instance upon load of the database I would like it stripped down when a general user logs in... but if a admin logins in then they get all menus...
so based on the user type will dictate the menus visible.. cane this be achieved'''''''''''';
View 2 Replies
View Related
Jun 18, 2013
I am looking to lock my database until the user puts in the correct credentials.
I have already put the form on Pop Up and Modal. They can still select the "X" in the top right of the window.
View 1 Replies
View Related
Jul 9, 2013
I have a database that has all the employees in my company with basic information. I have a auto number set up for each person. I also have on my form a subform with information about the employee's history in the company. I have bin trying for the last couple weeks, to put a button on my form, that will open up the custom report I made for the one employee, in print preview mode. Everything I have tried gives me a error. The main error I get is The database engine could not lock the table "EmployeeT" because it is already in use by another person or process. If I open the report by itself, then I get all my employees. I am looking to just open a single report from the form I am currently looking at.
I have 2 tables. One Named EmployeeT with all the employees basic information. I have a auto number with the field name EmployeeID.
The 2nd table is called IncidentT, which has its own auto number, and records all the problem/incidents with the employee. For example, lates, if the did not show up, or cancelled out of that day, etc. I have the 2 tables sharing the EmployeeID, sharing the relationship. My main form, has a lot of my information and a subform, Like i said. But no matter what I try I can get rid of that error.
The only way I got it to work without the error, is when I go into properties and change the Record Set Type to Snapshot on both the form and subform. But then I can't edit the form or subform anymore.
View 2 Replies
View Related
Apr 3, 2013
I am using Access 2010 and I have my tables hidden in the navigation pane (I don't have any concerns about users finding the tables to make edits), however I am looking to "lock" all fields on a form once a user saves the record. The concern is that when they go to enter a new record they may end up on a previous record and overwrite the information. My thought was to create a checkbox on the table that I can edit each week to lock records. At that point, what type of code can I create or use that will lock records on the form?
View 2 Replies
View Related
Jun 1, 2015
Access 2002 . Can I condition a field to 'locked' on just one record of a continuous form subfile, based on the contents of a 2nd field in same record?
View 14 Replies
View Related
