 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Editing or adding records in a form
I created a form to input data into several different tables. I am unable to add new records in the form view. I cannot even edit records in the form. Whenever I'm in the form view and try to edit a record it seems as if it were locked. I have checked the properties of the form about ten times now, Allow Edits is Yes, Allow Deletions is Yes, Allow Additions is Yes. Record Locks is on No Locks. Recordset Type is Dynaset, etc. Can somebody help me? Thanks, tiz Presuming the form is bound to a query, it is likely that the query is not updatable. Paste the SQL for the form's recordsource into a query window and see if you can update that. > I created a form to input data into several different tables. I am unable to > add new records in the form view. I cannot even edit records in the form. [quoted text clipped - 6 lines] > Thanks, > tiz I checked the form's record source and it is not updatable. How can I change the recordsource's property to make it updatable? You can't. If Access decides the query is not updateable, you're stuck with it. However, if you post the SQL of the recordsource query, we may be able to suggest a way to help you achieve what you want. > Presuming the form is bound to a query, it is likely that the query is not > updatable. [quoted text clipped - 12 lines] > > Thanks, > > tiz Hi: ChrisJ I have same problem. My front end form using a query and gets data from two tables, the tables are located in another computer (Access tables). Before, this form can add new record, Edit..., but today, all my staff (including me) the form just can't do that, even set Edit is true. If I go to open the tables in the back end, I can add new record (there is a * indicating add new), but if I run the query from my front end, I just can't add new record. (there is no * indicting add new). Please let me how to solve this problem. Thanks. James > You can't. If Access decides the query is not updateable, you're stuck with it. > However, if you post the SQL of the recordsource query, we may be able to [quoted text clipped - 16 lines] > > > Thanks, > > > tiz This is not the same problem. In Tiz's case the form never worked. In your case it did, but suddenly stopped working. Something must have changed to cause this. The most likely causes, if everything else is still working, are Database corruption or security issues > Hi: ChrisJ > [quoted text clipped - 15 lines] > > James I have the same problem as Tiz. However, I have no idea what you mean by "Paste the SQL for the form's recordsource into a query window and see if you can update that." Please explain! Help menus were no help. Thanks! > Presuming the form is bound to a query, it is likely that the query is not > updatable. [quoted text clipped - 12 lines] > > Thanks, > > tiz Open your form in design mode and display the properties window. Select the "data" tab and look at the "record source" setting If the form is "bound", this setting will be the name of a table, query or an sql statement (hand-written query). My previous answer assumes that the record source is an sql statement. In this case, copy the contents of this property. Open a new query window. Click OK to go to the design view. In the "show table" window, click "Close" without selecting anything On the lefthand end of the toolbar, click the bold "SQL" button. A new SQL window will open with "SELECT;" highlighted. Replace this with what you copied from the properties window. Run the query, and see if you can enter or change data Chris What do I do if this does not allow any editing or changes? Thanks > Open your form in design mode and display the properties window. > Select the "data" tab and look at the "record source" setting [quoted text clipped - 15 lines] > > Chris Post the SQL of the form's recordsource, and we may be able to tell you how to fix it. You may need to go to a form/subform setup > What do I do if this does not allow any editing or changes? > > Thanks I had the same problem - A perfectly running form that was being used for data entry and editing stopped working. It acted like edit, add and delete were turned off. I tried everything I could think of and then came here to see if anyone else had the same problem. It was suggested that the query was not allowing the update. I checked my query and it was set as a select query. I Changed that to be an update query and then re-selected the select query option. I then tried my form and it worked ok. > Post the SQL of the form's recordsource, and we may be able to tell you how > to fix it. You may need to go to a form/subform setup > > > What do I do if this does not allow any editing or changes? > > > > Thanks SELECT Main_Table.Inserter, Main_Table.Date, Main_Table.Meter, Main_Table.Shift, Main_Table.Category, Main_Table.Job, Main_Table.ID, Main_Table.Count, Main_Table.Postage, Main_Table.MasterItem1, Main_Table.PSItem1, Main_Table.Description1, Main_Table.Price1, Main_Table.MasterItem2, Main_Table.PSItem2, Main_Table.Description2, Main_Table.Price2, Main_Table.CostCenter, Main_Table.Contact, Main_Table.OH, Main_Table.Post, Main_Table.Total FROM Main_Table; Any suggestions? I can't add new records! Please Help > Post the SQL of the form's recordsource, and we may be able to tell you how > to fix it. You may need to go to a form/subform setup > > > What do I do if this does not allow any editing or changes? > > > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.