Solved

Access 2003 Form- only add records

Posted on 2011-02-12
8
344 Views
Last Modified: 2012-05-11
Is there a property on a form would only allow new records on the form. I have a table  and 1 form.  when I open the form it will only allow a new record to be added.  I am assuming its a form property.  I am opening the form without any vba coding or macros.  ??
0
Comment
Question by:ml-sd
  • 4
  • 4
8 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 34878573
set the Data Entry property of the form to YES
0
 

Author Comment

by:ml-sd
ID: 34878884
It was on Yes
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 34878887
so, what is the problem?
did you make table1 as the record source of the form?
0
 

Author Comment

by:ml-sd
ID: 34878892
Yes i Did.   I dont understand why the form is doing that..  I created another form,  it worked fine...  
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 119

Expert Comment

by:Rey Obrero
ID: 34878901
check the setting of

Allow Additions      the default for this property is Yes  and must be set to Yes
0
 

Author Comment

by:ml-sd
ID: 34878908
set to yes
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 250 total points
ID: 34878913
then, that form is corrupted. just delete the form and create a new one.
0
 

Author Comment

by:ml-sd
ID: 34879196
Thanks for your help....
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now