If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Wizard unable to open form in Form or Datasheet view
I am just learning Access, and I am unable to get a Form to work with my
database. I get an error, "The wizard is unable to open your form in Form view or Datasheet view, possibly because another user has a source table open in exclusive mode." I am the only one working on this database, which is brand-new. I found one Help article that said if a "reserved word" was used, that could cause a problem like this, and I had done that on my first try. I created the form based on two tables, "Facilities" and "Activities", that are in a one-to-many relationship ("Facilities" is the many, "Activities" the one). I deleted that database and started a fresh one with the same name but not using that reserved word, thinking that would fix the problem. It has not. I cannot enter data in fields bound to the "Facilities" table, but I can to fields bound to the "Activities" table. When I try to type in the "Facilities"-bound fields, I get a brief message at the bottom of the screen that says, "join key of Facilities not in record set." Can you help? |
#2
|
|||
|
|||
Wizard unable to open form in Form or Datasheet view
On Fri, 14 May 2010 16:12:01 -0700, JeanRNorman
wrote: They don't tell you this, but especially as a beginner you should follow the paradigm: one form, one table. In this case, the main form is bound to the Activities query, and if you have a subform, it should be bound to the Facilities table. Rookies sometimes think one of these should be bound to a join of parent and child table. Not so. The relationship is expressed by setting the LinkParentFields and LinkChildFields properties. The control wizard can help you with this. -Tom. Microsoft Access MVP I am just learning Access, and I am unable to get a Form to work with my database. I get an error, "The wizard is unable to open your form in Form view or Datasheet view, possibly because another user has a source table open in exclusive mode." I am the only one working on this database, which is brand-new. I found one Help article that said if a "reserved word" was used, that could cause a problem like this, and I had done that on my first try. I created the form based on two tables, "Facilities" and "Activities", that are in a one-to-many relationship ("Facilities" is the many, "Activities" the one). I deleted that database and started a fresh one with the same name but not using that reserved word, thinking that would fix the problem. It has not. I cannot enter data in fields bound to the "Facilities" table, but I can to fields bound to the "Activities" table. When I try to type in the "Facilities"-bound fields, I get a brief message at the bottom of the screen that says, "join key of Facilities not in record set." Can you help? |
Thread Tools | |
Display Modes | |
|
|