Re: Multiple Record Inputs with one Form

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.



.

Relevant Pages

  • Re: Multiple Record Inputs with one Form
    ... whenever I see a description of a form "with 12 entries", ... I'm still looking for a description of the underlying business need, ... Also when i create my form I can not seem to separate ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.formscoding)
  • Re: Multiple Record Inputs with one Form
    ... The underlying business need is to recreate the payroll form, making data ... "Jeff Boyce" wrote: ... whenever I see a description of a form "with 12 entries", ... I'm still looking for a description of the underlying business need, ...
    (microsoft.public.access.formscoding)
  • Re: Multiple Record Inputs with one Form
    ... For intCount = 1 To Me! ... the entries from the form inputed. ... "Jeff Boyce" wrote: ... database will let you do. ...
    (microsoft.public.access.formscoding)
  • Re: Help with Query Calculation
    ... I did take a look at the DCount function and I am ... Here is the query I am using to calculate on ... "Jeff Boyce" wrote: ... places are tied if there are 6 or more entries in the class. ...
    (microsoft.public.access.queries)
  • Re: Help with Query Calculation
    ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... places are tied if there are 6 or more entries in the class. ... If there were only 5 entries in the class, the spread would look like ...
    (microsoft.public.access.queries)