Unwanted duplicates in table

[ksayers]

When data is entered into the form manually it creates duplicate records in
the table.

For example:
I fill out the form. I check the table the information goes to. That form
shows four different records for the same participant. Some information is
in one row, other information is in another row, etc.

I want it all in one row; in one record. It must have something to do with
how the form is set up or how the table is set up.

Does anyone know a change I could make to stop this?


Thank you,

 

[Jeanette Cunningham]

Hi,

Create a new form. You can select the table in the database window and use
the autoform button or you could use the wizard to design a new form. If the
new form is giving you the same problem, post back.

Jeanette Cunningham

 

[John W. Vinson]

I want it all in one row; in one record. It must have something to do with
how the form is set up or how the table is set up.

Does anyone know a change I could make to stop this?

Correct the error in how the form is set up or the table is set up.

Since you don't post any information about either, nobody here can really help
you very much! Care to post the table structure (representative fieldnames), a
description of the form, and perhaps the SQL view of the form's Recordsource?

John W. Vinson [MVP]

 

[ksayers]

Microsoft Access is our database where we store all of the data we have
collected from participants that are in our study. Unfortunately we no
longer have an IT person and we will not for a long time and thus, I have to
figure these things out on my own. I know very little about the database
other than how to make basic changes. If I could get some direction of where
to look for the problem I might be able to figure it out by trial and error.

The problem is that this form is very large. Scrapping the old form or
making a similar one to check is not an option.


Our database is set up to work with a scanning software program called
"teleforms"
Unfortunately that system is broken at the moment.
When using the scanning software it would automatically dump the data into
our database and it would all come out correctly.
However, when we switch to manually entering the data into the form it
creates 4 lines instead of 1.
The form consists of 8 tabs and approximately 230-300 questions/boxes and
thus about 300 variable names.
These boxes are combo boxes, text boxes, and yes no check boxes.

This data from this form is placed in two separate tables. One table works
just fine. The other table is the one creating duplicates.

I'm sorry I can't give better answers to your question but I don't know much
about access.

Thank you

 

[ksayers]

Microsoft Access is our database where we store all of the data we have
collected from participants that are in our study. Unfortunately we no
longer have an IT person and we will not for a long time and thus, I have to
figure these things out on my own. I know very little about the database
other than how to make basic changes. If I could get some direction of where
to look for the problem I might be able to figure it out by trial and error.

The problem is that this form is very large. Scrapping the old form or
making a similar one to check is not an option.


Our database is set up to work with a scanning software program called
"teleforms"
Unfortunately that system is broken at the moment.
When using the scanning software it would automatically dump the data into
our database and it would all come out correctly.
However, when we switch to manually entering the data into the form it
creates 4 lines instead of 1.
The form consists of 8 tabs and approximately 230-300 questions/boxes and
thus about 300 variable names.
These boxes are combo boxes, text boxes, and yes no check boxes.

This data from this form is placed in two separate tables. One table works
just fine. The other table is the one creating duplicates.

I don’t know what exactly what an SQL is but it seems to be some sort of
programming language and I know nothing about that.


Sorry I can’t give more details but I’m at a bit of a loss when it comes to
these things.


Thank you

 

[John W. Vinson]

Sorry I can’t give more details but I’m at a bit of a loss when it comes to
these things.

I think you will have to get someone who knows Access to look at the database,
either locally or by sending the file to someone remote. It's *absolutely
impossible* for anyone (not to speak of unpaid volunteers like us) to solve
your problem without being able to know anything about what's in the database.

"Doctor, I don't feel good, what should I take?" doesn't lend itself to
accurate diagnosis after all!

John W. Vinson [MVP]

 

[Jeanette Cunningham]

Hi,
If it were me with the problem, I would go with creating a new form. The new
form is just for testing and doesn't have to look good. A new form can be
created in a jiffy using autoform. You can add some new data using the new
form and see if it saves the data into the table without adding duplicates.
If it does this, then we can think that the table is working OK. If it
doesn't, then we can look at how the table works.

Jeanette Cunningham