Re: Multiple Record Inputs with one Form

It all starts with the data. You're describing the forms.

Hint: whenever I see a description of a form "with 12 entries", I suspect
someone has tried to convert a spread*** into an Access database. Access
is not a spread*** on steroids, it's a relational database, and requires
some new ways of thinking about data.

I'm still looking for a description of the underlying business need, rather
than the approach used to satisfy the (as yet unclear) need.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Graffyn" <Graffyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:08E5BF7E-CDC6-4437-A0F4-398A4BD4C363@xxxxxxxxxxxxxxxx
I'm working on a payroll form and there are twelve entries on each "form".
I
want to be able to recreate this form that has been used as paper, which I
have I just can not get the next record of information to be separate when
adding to the table. I actually double posted my problem....sorry about
that,
the other titled Mulitple Record(12 entries) w/ form. She asked me to
look
up an append query but I still have only basic knowledge of this SQL
language
from w3schools.com. Also when i create my form I can not seem to separate
the
information entered in the text box name1 from name2 the same name pops up
on
both text boxes when i enter in of them. Thanks for your time

"Jeff Boyce" wrote:

You've described a "how" ... as in how you are trying to do something
("send
more than one record to the table with one form").

Now, "why" ... as in what will having multiple records generated from a
single form allow you to do (i.e., business need)?

This isn't idle curiosity ... if we knew more about the underlying
business
need, we might be able to offer alternate approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Graffyn" <Graffyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7D0D8222-A344-40E4-99DD-CFD6A6EC850D@xxxxxxxxxxxxxxxx
I'm programming with SQL and can't seem how to figure out how to send
more
than one record to the table with one form.





.

Loading