cannot edit records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which i have created to specifically edit my records. and then
an exact duplicate form to only have records added. They are identical except
for their names. Then I have made sure that the properties of the edit form
are set to allow edits, additions, deletions,etc.
The controls on my form forms are all set to enabled 'yes' and locked 'no'.
BUT, i cannot either edit my records at all or even add a record in either
form. they simply appear as i designed them, with the first record in place,
but i cannot do anything else with the form. its not frozen, it just wont
allow me to do anything.

PLEASE can someone help me. it wasnt always like this.

Thank you
Rigby
 
Is the Record Source of the form editable? That is, if you open the Record
Source of your form, do you see the New Record at the bottom (that's the one
with the * in the row header. Also, is the * on the navigation bar enabled.
If the answer is Yes to this, then it's a problem with your form. If the
answer is No, then the problem lies with your Record Source.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Hi,
are these forms based on a query? Maybe you created a non updatable query or
recordset. Try to open the query itself and see if you can change anything
there. Look this up in the access help, it can have several reasons:

1. Improper join
2. Aggregate functions
3. Multiple non-hierarchial 1-many relationships
4. Security
5. No primary key on a linked table.
All these things will result in a query which is non updatable. Most likely
it is a relationship issue.
HTH
Good luck
 
Hello Roger

The * is not available on the navigation bar. I have a query as my record
source so it will prompt me to enter an employee ID number. I have about 14
tables linked in this query. What can I look for to fix this?

Thank you so much for your help so far
Rigby
 
Hello Oliver

I am looking up those phrases in the Access Help now. But, all my tables in
this query have the same primary key, an employee ID number. I have created a
one-to-one relationship between each table via the ID numbers. there is, as
yet, no security involved in my database, its far from completion
(unfortunately). I will look into the 'improper join' and 'aggragate
functions' which you mentioned, although i am not entirely certain what you
are reffering to with these.

Thank you so much for all your help
Rigby
 
Any form that is based on a Join query is going to be problematic. That's
not to say it can't be done, but you have to supply the foreign key value to
ALL of the tables before it will be editable. (In the case of a One-to-One
relationship, the foreign key is also the primary key.) A better solution
would be to use a Form/Subform set up. This is most often used with
One-to-Many relationships, but will work with One-to-One as well.

Decide which table is your "main" table and base the main form on that.
Then put each of the other tables with 1:1 relationship to this table in its
own subform and embed these subforms on the main form. Be sure to set up
the Link Parent/Child properties on the subform controls.

This set up will ensure that all of the "child" tables get the right value
in their primary/foreign key fields so they will link properly. The subform
control takes care of this for you.

On a related note: If you have 14 tables in a 1:1 relationship, it is very
likely that you've designed your database incorrectly. 1:1 relationships
are very rare in properly designed databases. I realize you probably don't
want to hear that, but I'd be remiss if I didn't mention it. You're going
to continue to have problems with this database unless you change the
design.

The tablesdbdesign newsgroup is a good place to get help with this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Hello Roger

The * is not available on the navigation bar. I have a query as my record
source so it will prompt me to enter an employee ID number. I have about 14
tables linked in this query. What can I look for to fix this?
Click to expand...

A Query based on fourteen (!!!) tables will almost certainly NOT be
editable. It's much more common to use a Form for the "one" side
table, with subforms for the "many" side tables. Could you explain at
least some of your tables, and indicate how they are related?

John W. Vinson[MVP]
 
Back
Top