adding new record

  • Thread starter Thread starter maximus
  • Start date Start date
M

maximus

Hi,
I'm having a problem with adding new records on forms. I
have 3 forms with their AllowAdditions properties set
to "Yes" but I don't get that little star at the bottom of
the form which allowes you to add records and tehre is no
way to add new record. Other forms are working fine and
properties seems to be the same. Database is SQL 2000 and
front-end Access 2000. Plaese help.
Thank you
 
maximus said:
Hi,
I'm having a problem with adding new records on forms. I
have 3 forms with their AllowAdditions properties set
to "Yes" but I don't get that little star at the bottom of
the form which allowes you to add records and tehre is no
way to add new record. Other forms are working fine and
properties seems to be the same. Database is SQL 2000 and
front-end Access 2000. Plaese help.
Click to expand...

You likely have bound the form to a query that is not editable. Open the
query directly and see if you can make changes or get the (*) row at the
bottom.
 
-----Original Message-----


You likely have bound the form to a query that is not editable. Open the
query directly and see if you can make changes or get the (*) row at the
bottom.
Click to expand...
Two of the forms are bound to tables and one to a query
and they are not updatable. How do I make them updatable?
 
Thank you.
Setting of Unique Table property helped with form which
has View as Record Source, but not with other two forms.
Any sugestions?
 
Are you sure the form is bound directly to the table and doesn't use an SQL
statement? If bound to the table, can you open the table in Datasheet view
and insert rows? If not, then they probably don't have a Primary Key or
some unique identifier that Access can use to send the correct update
commands to the server. In some cases, you might need to add a Timestamp
field to the table to make it updatable.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
Forms are directly binded to tables and I couldn't add
records in tables, so I added Primary key field with
unique indentifier and it works now.
Thank you very much John
 
Back
Top