 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / February 2008Goofy Form Problem
I have four forms, Manager A, B, C, and D. The forms are there so that our managers can enter data such as when a new construction form comes in they enter it on the form. B, C, and D work fine. The A form you cannot enter anything. I have checked and unchecked every control on the form and rebuilt the form a dozen times. The tables are reasonably normalized and the queries work like a charm. This is driving up the wall. Any suggestions? Thanks! Are you sure Allow Additions and Allow Edits for the form are set to Yes? Are you sure your queries create an updatable recordset?  SignatureDave Hargis, Microsoft Access MVP > I have four forms, Manager A, B, C, and D. The forms are there so that our > managers can enter data such as when a new construction form comes in they > enter it on the form. B, C, and D work fine. The A form you cannot enter > anything. I have checked and unchecked every control on the form and rebuilt > the form a dozen times. The tables are reasonably normalized and the queries > work like a charm. This is driving up the wall. Any suggestions? Thanks! I know the allow additions and edits are set to yes. How do I see if my query creates an updatable recordset? Is there some query property that has to be set for that? > Are you sure Allow Additions and Allow Edits for the form are set to Yes? > Are you sure your queries create an updatable recordset? [quoted text clipped - 5 lines] > > the form a dozen times. The tables are reasonably normalized and the queries > > work like a charm. This is driving up the wall. Any suggestions? Thanks! No, there is no property for that. If you open a datasheet view of your form and see if there is a blank record at the bottom then the recordset is updatable. If there is no blank line, it is not. Some queries create recordsets that can't be updated. For example, Union queries, Totals queries, and some with complex joins can't be updated. SignatureDave Hargis, Microsoft Access MVP > I know the allow additions and edits are set to yes. How do I see if my query > creates an updatable recordset? Is there some query property that has to be [quoted text clipped - 9 lines] > > > the form a dozen times. The tables are reasonably normalized and the queries > > > work like a charm. This is driving up the wall. Any suggestions? Thanks! I checked the form (actually a form and subform) both have blank records at the bottom. The queries are plain jane select queries. Anyway, I just rebuilt the form again and it is allowing additions and edits. Weird huh? Thanks so much for your help! golfinray > No, there is no property for that. If you open a datasheet view of your form > and see if there is a blank record at the bottom then the recordset is [quoted text clipped - 15 lines] > > > > the form a dozen times. The tables are reasonably normalized and the queries > > > > work like a charm. This is driving up the wall. Any suggestions? Thanks! **** happens. I am right now working on a similar problem. Some of my forms that were working correctly started having problems like not being able to set focus to a control and not being able to set a bookmark. SignatureDave Hargis, Microsoft Access MVP > I checked the form (actually a form and subform) both have blank records at > the bottom. The queries are plain jane select queries. Anyway, I just rebuilt [quoted text clipped - 20 lines] > > > > > the form a dozen times. The tables are reasonably normalized and the queries > > > > > work like a charm. This is driving up the wall. Any suggestions? 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.