I have a form with a lookup, which when a product code is entered, the description automatically appears.
This is fine 99% of the time, but occasionally an unusual product needs to be added or the description slightly changed.
Is there a way around this problem, as when using the lookup, this field is then locked and cannot be edited at all
Thanks
Chris
I want to make a field where data can be enterred but once its saved cannot be deleted or changed in any way.
Anyone have any ideas how this can be done?:confused:
I have a table which is linked to a form which has been working fine for over a year now but yesterday the table "locked" for editing. I can now only copy data from the table. The editing functions delete, cut, new etc are not working, we can still filter the data.If we enter data on the form it creates a new line on the table but we cannot edit directly from the table.
View 6 Replies View RelatedI do not get this, can anyone come up with an idea or area that I could look into. There were fields that the sales reps could write notes into, they are not able to type in these fields anymore. I had a back up copy of the DB prior to this event happeneing. I compared the field in design view and all the values are exactly the same. But the Prior version I can still type in, the newly updated version I can't.
I tried copying the field from the DB where it worked and pasting it where the one not working was, and that didn't work. So, I got to believe there is a GLOBAL lock somewhere available. Unfortnately, the books I have do not discuss this situation at all.
Does anyone have any ideas...I have to think this is an easy fix, but I can't figure it out.
Thanks!
Friends,
I have a subform that I have attempted to lock all but one field (a checkbox.) Unfortunately, it appears that even though I have made sure (under field properties) that the field is unlocked, I cannot enter anything in directly in the subform. The field in the table is not locked. If I open the table, I can easily check and un-check the checkbox. I have opened the actual subform by itself and can check and uncheck the checkbox. However, when I go to form where the sub-form is placed and attempt to check/uncheck the checkbox, I am not able to do so. Any ideas???
I want to use the checkbox to run reports from a query that looks for those fields that are checked.
Thanks,
Mike
I tied several tables together in a new query, and then pointed an existing form to this new query instead of the old query. It appears to be working wonderfully, except that the new query has locked the three fields I need the users to type in (all of the fields are the same as the old query, and all but these three fields were already locked). The odd thing is that the properties on the field show that it is not locked.
On the original table, you can change the text in those fields. On the datasheet view of the new query, you can not change the text in those fields. On the datasheet view of the old query, you can change the text in those fields.
I can't figure out how to unlock those fields in the query. Can someone help, please?
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 RelatedHi,I have a table which contains sales information like deal name,closing date of deal,Monthly revenue information,total revenue yearly also quarterwise
information.The below table gives some idea....
i want to enter data in multiple fileds ex:when I enter revenue amount it should get updated in corresponding month based on the closing date information.Suppose closing date for a particular deal is mar-08 then the total revenue entered in revenue field should get updated in march month field.Please help me how to edit data in multiple field and also logic to apply to solve my problem.I have to design a report based on this information and source should be one table so i want to edit data in main table.
Any help would be appreciated...
I am new to ms access database so got stuck..pls help me
Closing date Jan Feb ar Apr May Jun Revenue Q1 Q2 Q3 Q4
Mar-08 1,500 1,500 375 0 0 0
Jun-08 4,000 4,000 0 0 0 0
Jun-08 6,000 6,000 0 4,500 0 0
Jun-08 3,000 3,000 0 0 0 0
Jun-08 1,720 1,720 0 0 0 0
Jun-08 20,000 20,000 0 0 0 0
Jun-08 2,000 2,000 0 0 0 0
Jun-08 20,000 20,000 0 0 0 0
Thanks in advance. yuor help is appreciated,
Regards,
kala
I have produced a table, the records from which have to be selected by individuals for auditing purposes.
I created a second table with individuals initials and passwords. This is linked by the initials to the main table. Records on the main table are returned when the query is run.
At first I could not edit fields in the query but changed the recordset type to Dynaset (inconsistent). I am now able to edit the query fields. However, having created a form based on the query, I am unable to edit the fields in the form. This is the basis that the auditors will use to score so is vital. Have I missed any other switches or techniques?
I have attached a portion of my database. if you go into the form called frmtest, select a branch from the very top drop down, select a detail and click the Edit button.how to have the information populate all the fields for editing. The Cost and Quantity fields work but my combo box fields don't properly work. The top combo box populates but when the record is updated it doesn't save the id. The second combo box doesn't even put the data in the data box.The main table where IDs and fields are is the BRANCH_EXP table, it's a linking table which links tables with many to many realationships.
View 3 Replies View RelatedI 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 RelatedI total novice at VBA. I am trying to code a button to modify (the last) record in a subform list and then add a new record based on values in unrelated or unbound fields on the button form.
The following code is based on the first of two YouTube tutorials (this bit on the edit) and looks like it should work. Except that my Access 2010 with Visual Basic for Aplication v7 does not recognise the type definition Database or Recordset
Code:
Private Sub ANOwner_Click()
Dim cn As Integer
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
[Code] .....
Create form to search multiple fields in table
Return records that match search
Open the record that you want in Form View for editing
Hi
I know this sounds stupid but on my database with user-level security, i have somehow managed to remove administer rights from all users , and do not know how to change it back, if it is even possible.
I think what might have happened is it was stored on my USB drive and i switched computers and opened the db, would that have affected it? :confused:
Is there an easy way out of this or am i screwed? :eek:
thanks, ian :)
I have been following a text book to try and secure a database, i set up the Work Group Info File, allocated a password, now even when i want to start a completley new database i have to enter a password.........
AND when i set up the password i must have enetered it wrong now i am completely locked out!!
Is there any way to fix this i cant do anything!! I cant even start on a completely new databse!!
Please help
undefined
Hi, can anyone help? Like an idiot I veered away from my intention to put a password on an Access database which holds only a table and a few queries and explored other security options. I now cannot get in to the database at all and get a message telling me that I do not have the necessary acces srights and to consult my administrator. When I look at the properties, I am shown as the administrator, which makes sense but despite trying various, desperate things, I cannot get back in to take the security off. Needless to say I did not create a copy first, so have learned a lesson the hard way. Any advice gratefully received.
i have this database with tables i can't access, so i had to import the data into a new database , given the size of the new database JoeCruse (form this board) pointed out that it could be that the front end is separated form the back end. and i can't find the front end anywhere
i want to press F11 and see the tables and so forth open up when i launch the original db. how do i go about doing that.
:eek: security levels were set on a database using the wizard, unfortunately the person who set the security did not print out the sheets with the WID etc on it, this person is now unable to open access at all from their pc it asks for a password which the user does not believe they set or if they did set one it was their standard pc log in, however the database and access can be opened from any other pc on the network......can anyone out their help...thanks
View 2 Replies View RelatedAre all mde files locked so that you cannot edit or see design view for forms etc?
Are there any tools out there that can unlock an mde database?
Thanks,
Dave
I have a database that I password protected. Somehow, in the process of applying the password, the file became corrupted and now I am getting the following error message:
"This database is in an unexpected stat; Microsoft Office Access can't open it.
This database has been converted from a prior version of Microsoft Office Access by using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu (Database Utilities submenu). This has left the database in a partially converted state."
Does anyone know what this error is and how I can retrieve my data?? I have tried to import the files into a new database, convert the database into a different version and compact and repair. Nothing has worked. I have looked into recovery tools and two of them do get me into the database and let me see some of the data, however, the programs are holding my information hostage until I purchase the software which is running around $300.00. Any ideas???
I recently split my database and created an MDE file. Users were given a copy of the MDE file and the BE is in a shared directory on a server. There are only two users at this point in time inputting data into the database (there will be at least a dozen more in the near future), but every so often one of them experiences being unable to input data from their Form because of this lock condition. Sometimes the condition will go away (if they wait long enough) and they can input data again. Sometimes it's User A experiencing the lock, sometimes it's User B. I thought splitting would alleviate lock issues, but it doesn't seem to be the case for me. Could this be a "permissions" issue on the shared directory where the BE is located or some security setting within Access (or both)?
Thanks in advance for everyones help!
Michael
I copied Odun's post below to describe my problem. I'm having the same problem. I can't even creat a new blank database without being prompted for my user name and password, which aren't working.
Any suggestions would be very much appreciated.
Thanks,
Mike
-------------------------------------------------------------------------
#1 02-13-2006, 04:33 AM
odun
Registered User Join Date: Apr 2005
Posts: 108
can't log on to database
Hi all,
I was playing with passwords for one of my access db.
I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure if the Name is correct, is there a way to retrieve the log on name?
I also noticed that when I try opening any other db on my system, it asks me to log on, I though I was only applying a password to one file.
Please help
Thanks!
odun
View Public Profile
Send a private message to odun
Find all posts by odun
Add odun to Your Buddy List
--------------------------------------------------------------------------
Hi
Is there anyway of returning the menus that I removed from the Tools > Startup options back?
It looks like I have locked myself out of my FE!!!!
Thanks,
B
Hello out!!
Is a moment of desperation! I created a security group or something (dont know what i was thinking!), and now there is no way to get into my application!!!! It says to contact with the administrator, but I'M the administrator!!!!
Any way to get the scripts minimun from the applications?? The classes, the modules??? God!!!! My last backup was 4 days ago!!!! I can't loose everything!!
Message:
you do not have the necessary permission to use myapplication.
:confused::confused::confused::confused::confused: :confused:
I have two db's a front end and a back end db. One of my users recently got this error "Could not update currently locked" Access "3218". I have a form tied to a table. She changed a drop down that puts an ID in the table row and the error occurred. This has never happend before and the locking is set to "No Lock". She swears nobody else was in that specific form either. How does this error occur out of no where? I did add 3 new columns to that table for a total of 30 columns. The front end is local and the back end is on a shared drive. Honestly if anyone can help I would be so so greatful. There is no code used to update this row in the table. As soon as she hits the drop down the new row is created in the table.
Thank You
Jerry
Hi there
I really hope someone can help me.
I used a test database to work on security. I didn't think it would effect other databases. Now I've locked myself out and can't open any databases. I keep getting asked my logon and password for ALL databases.
What can I do? I don't understand why it's effecting me using all databases. Everytime I type a username and what I believe to be the correct Password it wont let me in
Help...