New user problems-new record

[Guest]

I am in a marketing class. I opened a new Access database and created a form
that was based on a survey created in Word. I started from scratch creating
a nice looking survey and intended on entering the information gleamed from
the Word document survey in this new form I created, one record at a time. I
do not have any of the information linked to tables or anything. I just
created the form in the design view of forms, this is all I've done. I got
done with this and went to enter information and I am unable to bring up "new
records" once I've entered in one survey's info. My form itself is being
saved, but the information isn't, and I can't get to "record 2". Any help
someone can give to a newbie with some frustrations?

 

[Tom Lake]

I am in a marketing class. I opened a new Access database and created a

form
that was based on a survey created in Word. I started from scratch
creating
a nice looking survey and intended on entering the information gleamed
from
the Word document survey in this new form I created, one record at a time.
I
do not have any of the information linked to tables or anything. I just
created the form in the design view of forms, this is all I've done. I
got
done with this and went to enter information and I am unable to bring up
"new
records" once I've entered in one survey's info. My form itself is being
saved, but the information isn't, and I can't get to "record 2". Any help
someone can give to a newbie with some frustrations?

Your problem is that you haven't created a table and linked it to the form
so there
are no records at all! If you have no records, you can't create a new
record.
You'll have to make a table use it as the form's record source in order to
store data.

Tom Lake

 

[Vincent Johns]

Tom Lake wrote:

[...]

Your problem is that you haven't created a table and linked it to the form
so there
are no records at all! If you have no records, you can't create a new
record.
You'll have to make a table use it as the form's record source in order to
store data.

Tom Lake

Maybe you have no choice in this, but are the data you already have
collected stored in some form in which you can import them into a Table?
Having the computer enter the data would be less error-prone than
doing it via the keyboard.

If you already have several MS Word documents containing the data, for
example, maybe you could make copies of them, delete most of the
extraneous material (such as pictures and instructions) and save what's
left as a collection of *.txt files (the kind that Notepad creates).
Then you might be able to use, in Access, File --> Get External Data -->
Import... to read those data into a new Table. There are some
restrictions; for example, it helps if you can line up the data in your
source documents into columns. But it often beats having to retype all
that stuff.

Of course, if you have only two or three survey forms, it's probably not
worth all this effort, but if you have 50 or 100 or more, you might be
able to save yourself a lot of work.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.