Cannot Enter Data
Steven Fuller
from Paradox. My next step is to allow for data entry
into the converted Access tables, using a form.
When I create a form based on 2 tables or a 2-table
query, I cannot enter any data in any field; it just
beeps.
I can make forms for data entry based on one table, and
they work fine.
I have tried to unlock, allow edits, etc. but I cannot
find any answer to this seemingly simple problem.
I have tried to send this with my Access db attached, but
it does not go through.
Can anyone tell me what I am missing?
Thanks --
Steve Fuller
John Vinson
<SFu...@InforMedixMR.com> wrote:
>I am a new user of Access. I am converting my databases
>from Paradox. My next step is to allow for data entry
>into the converted Access tables, using a form.
In my experience, Paradox tables are often less fully normalized than
is ideal for Access. Have you done any changes to the table structure?
Have you (in particular) defined a Primary Key field or fields on each
table, and established relationships between the tables? I'd guess
not, since this problem would be (one of many!) symptomatic of this
lack!
>When I create a form based on 2 tables or a 2-table
>query, I cannot enter any data in any field; it just
>beeps.
Sounds like you also have error messages turned off. Leave 'em on
until you have it working... <g>
The problem isn't the form. It's probably that the Query upon which
you based the form is not updateable. Try opening the Query in
datasheet view - does it have a "new record" line at the bottom? If
not, it's non-updateable. To make it updateable, you must have a
unique Index (such as a Primary Key) on the "one" side table's joining
field, and a non-unique Index (which the Relationships window will
create for you automatically) on the "many" side.
However, it's usually much simpler to use a Form for the "one" side
table with a Subform (or Subforms) for the Many side table(s). Access
will automatically synchronize the linking fields, and display all the
related records when you pull up a "one" side record.
>I have tried to send this with my Access db attached, but
>it does not go through.
Good; very few of us volunteers will open (or download or for that
matter even see, thanks to kill filters) messages with large
attachments. They're neither welcome nor helpful; if someone wants to
see your database, they'll ask and you can EMail it to them, or you
could put it on a webpage and post a link to it.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
Steven Fuller
-- Steve Fuller
> John W. Vinson[MVP]
> Come for live chats every Tuesday and Thursday
>http://go.compuserve.com/msdevapps?loc=us&access=public
>.
>