If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms into Table
I need to enter information into a form and dump it into a table (no
problem). How do I go about entering information into a form for multiple people to return multiple rows with the table. Do I need a different form for each person??? Thanks |
#2
|
|||
|
|||
Forms into Table
If you are saying you want to return multiple rows for each person, then you
need a form/subform setup. The form should have the information on the person and the subform should have the multiple rows for the person. If you need more specific information, please post back with more detail on what you are trying to accomplish. "Andy" wrote: I need to enter information into a form and dump it into a table (no problem). How do I go about entering information into a form for multiple people to return multiple rows with the table. Do I need a different form for each person??? Thanks |
#3
|
|||
|
|||
Forms into Table
Not quite. I have a form with 8 fields in, linked to a table. When I input
data into the form, this then generates data on the first row of the table. Fine, no problem. What I now need to do, is work out how to generate a second set of details in row 2 of the table. Is there a way I can change the form so that it can be added into this once, or do I have to have a separate form for each rown in the table? Happy to explain more! Thanks "Klatuu" wrote: If you are saying you want to return multiple rows for each person, then you need a form/subform setup. The form should have the information on the person and the subform should have the multiple rows for the person. If you need more specific information, please post back with more detail on what you are trying to accomplish. "Andy" wrote: I need to enter information into a form and dump it into a table (no problem). How do I go about entering information into a form for multiple people to return multiple rows with the table. Do I need a different form for each person??? Thanks |
#4
|
|||
|
|||
Forms into Table
On Tue, 20 Dec 2005 03:26:02 -0800, "Andy"
wrote: I need to enter information into a form and dump it into a table (no problem). How do I go about entering information into a form for multiple people to return multiple rows with the table. Do I need a different form for each person??? Of course not. Access Forms (unless you've customized them) do this automatically - if you enter data into several fields, and then tab out of the last field in the tab order, you should be in a "new record", blank and ready for more input. Or, you can press the * icon in the navigation buttons at the bottom of the form. It is *possible* to set up a form which traps the user on a single record, but you have to do so deliberately. I'm guessing that you have not done so. Note also that you don't need ANY code or macros to "dump" data into a table - a default bound form does so all by itself with no intervention needed on your part. Maybe you're trying too hard! John W. Vinson[MVP] |
#5
|
|||
|
|||
Forms into Table
Spot on, thankyou. Once entering data for one person, I was not tabbing right
the way through the form and hence not able to enter data into the second/nth row of the table "John Vinson" wrote: On Tue, 20 Dec 2005 03:26:02 -0800, "Andy" wrote: I need to enter information into a form and dump it into a table (no problem). How do I go about entering information into a form for multiple people to return multiple rows with the table. Do I need a different form for each person??? Of course not. Access Forms (unless you've customized them) do this automatically - if you enter data into several fields, and then tab out of the last field in the tab order, you should be in a "new record", blank and ready for more input. Or, you can press the * icon in the navigation buttons at the bottom of the form. It is *possible* to set up a form which traps the user on a single record, but you have to do so deliberately. I'm guessing that you have not done so. Note also that you don't need ANY code or macros to "dump" data into a table - a default bound form does so all by itself with no intervention needed on your part. Maybe you're trying too hard! John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |