Solved

My form won't save to a new line (record?) on my table.

Posted on 2011-02-11
14
717 Views
Last Modified: 2012-05-11
I am new (obviously) to Access. I have built my tables and have built my form for data entry to the table. But I'm having problems with my form 1-It won't save to a new line(record) on the table it just keeps rewriting over the first record. 2- It won't reload a blank form. 3- I can't get my combo boxes to come up blank when the form loads. Thanks for your help on this.
0
Comment
Question by:CindyDD
  • 7
  • 7
14 Comments
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34873100
Please upload the database so we can look at it.
0
 

Author Comment

by:CindyDD
ID: 34873292
copy and paste the code?
0
 

Author Comment

by:CindyDD
ID: 34875487
I apologize but I don't think I know how to upload a database.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:CindyDD
ID: 34889166
0
 

Author Comment

by:CindyDD
ID: 34889192
If I need to treat this as 3 separate questions I'm happy to do that. I just need help!
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34889339
A general comment:  it is a good idea to use standard prefixes for database objects and controls.  This can be done semi-automatically using my LNC Rename add-in.  The Access 2007-2010 version can be downloaded from this link:
http://www.helenfeddema.com/Files/code63.zip

I made a new record on the form, and it was saved to a new table record.  The form seems to be working, though I think the embedded macros (not one of Microsoft's best ideas) can be dumped.  You don't really need a Save button, since there is no error trapping.  If you need error trapping, this is best done in VBA code.

You don't need Next Record and Previous Record buttons either, since they are built in to the navigation bar.

Can you be more specific about the problem you are experiencing?


0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34889379
Also, I think that this form might be a good candidate for the new Split Form type, which has a form section for displaying the current record and a datasheet section for a quick view of multiple records.
0
 

Author Comment

by:CindyDD
ID: 34889774
I was trying to create a modal form that comes up when the person opens the database and all they have to do in enter the info. I don't want them to have to mess with any of the tables. Just a data entry form.
0
 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 500 total points
ID: 34899851
If the form is just used for data entry, then it is a good idea to set its DataEntry property to Yes.  This ensures that it opens to a new record.  Otherwise, users might start typing into the first record (that might be why you had new data going into an old record).  The DataEntry property is on the Data tab of the form's properties sheet.
0
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 500 total points
ID: 34899872
Select the form as the Display Form in the Current Database sheet of the Access Options dialog.  How you get there depends on the version of Access you are running.  Let me know what your version is, and I can give specific directions.
0
 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 500 total points
ID: 34899887
The Display Form will open automatically when the database is opened.
0
 

Author Comment

by:CindyDD
ID: 34899922
Access 2007
0
 

Author Comment

by:CindyDD
ID: 34900327
I did find that setting and the form displays perfectly. Your first answer regarding the data entry control was exactly what I was missing. That IS why my form wasn't going to a new record and was rewriting new information over old. Thank you.
Just one more quick question and I can submit it separately for your points if you like.
All my controls are saving to the table except two. They are set up in the query just like the others. I can't see anywhere on the properties sheet where the record source is listed. I know it's here somewhere but I'll be hanged if I can see it. It's the only thing I can think of to look at. What do you think? Please tell me if you want me to submit this question independantly of the others.
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34902561
Yes, since this question is closed, start a new one, and let me know which controls are not saving to the table.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access report groups with sums 5 24
Dlookup MSACCESS 5 24
VBA SQL statement - 2 "OR"s and 1 "And" 4 24
Access check if a table is open 4 38
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…

815 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

13 Experts available now in Live!

Get 1:1 Help Now