Prev: Creating forms from queries
Next: out of date items
From: JeanRNorman on 14 May 2010 19:12
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?
From: Tom van Stiphout on 15 May 2010 01:17
On Fri, 14 May 2010 16:12:01 -0700, JeanRNorman
<JeanRNorman(a)discussions.microsoft.com> 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?
 | 
Pages: 1
Prev: Creating forms from queries
Next: out of date items