Trouble saving data to a form datasheet

[Guest]

I am having trouble saving data into a forms datasheet. It appears that I am
missing a crucial step when trying to save 'new' data to the datasheet.

Steps:

1. I open the form in 'form view' and enter data within the datafields.

2. I save the existing data using the macro 'save.'

3. I reset the datafields and enter new data.

4. I save the form; assuming that the data I have just entered is being
saved as a new row. However, upon reopening the datasheet I find that the
data I had previously saved has only been overwritten by the data I have just
saved.

I would like to save all user input into the forms datasheet unitl enough
data has been collected to export to an Excel database.

Unfotunatley, I don't have the experience with Access to solve this problem.
I have used the Access 'help,' but I could not find an article that relates
to
my situation.

Any ideas?

Many Thanks.

 

[Phillip Windell]

"University of Maine student"

I would like to save all user input into the forms datasheet unitl enough
data has been collected to export to an Excel database.

Excel database? You mean Access Database or Excel Spreadsheet?

Unfotunatley, I don't have the experience with Access to solve this problem.
I have used the Access 'help,' but I could not find an article that relates
to my situation.

Data is not saved to the table until you move out of the record (either
forward or backward).

 

[Guest]

When you create a form in Access the form defaults a datasheet (database) for
that form.

I am trying to find out how I can save several rows of data in that
datasheet. Everytime I try to save new data into the datasheet the previous
data is overwritten by the new data.

Any Ideas?

Many Thanks.

 

[John Vinson]

When you create a form in Access the form defaults a datasheet (database) for
that form.

And you can change the Default View property of the Form to Single
Form, or to Continuous Form.

I am trying to find out how I can save several rows of data in that
datasheet. Everytime I try to save new data into the datasheet the previous
data is overwritten by the new data.

Then you've set up the form incorrectly (or the wizard did something
you weren't expecting, more likely).

What are the relevant Properties of the form:
Recordsource (the table or query upon which the form is based)?
Default View?
Allow Updates?
Allow Additions?

John W. Vinson[MVP]

 

[Guest]

What are the relevant Properties of the form:
Recordsource (the table or query upon which the form is based)?
Default View?
Allow Updates?
Allow Additions?

(Recordsource).....I'd like to create a form that only allows users to input
data in datafields, make selections from controls I have added on the form,
and save their input to the forms datasheet.

Is this possible with the default datasheet?

 

[John Vinson]

(Recordsource).....I'd like to create a form that only allows users to input
data in datafields, make selections from controls I have added on the form,
and save their input to the forms datasheet.

Is this possible with the default datasheet?

A Table stores data.

A datasheet is a method of presenting data.

It sounds like you're assuming that a Datasheet as displayed on a form
is a data repository. It isn't. You need to base your form on a Table
if you want to store data; that table is the Form's Recordsource.

That data can be displayed as a datasheet, as a continuous form, as a
single form, on a Report - however you like - but the data must be
stored in a Table.

Note that I did ask four questions. You answered a different question,
one which did not help me understand your database.

John W. Vinson[MVP]