How do I create a table using this form?

[dgrosen]

Hi masters of the Access ray: I need serious help.
This is the puzzle!!!
I have a form that has 7 fields: NAME and 6 text boxes.
The 6 text boxes referes to a small 3x2 grid. I have to input an ID number on each textbox.
The form looks something like this:
NAME:________
--A-B-C
1[ ] [ ] [ ]
2[ ] [ ] [ ] <----------------Textboxes!

I will like to create a table using this form. For example, if I type the number "123" in the location A1 and "111" in A2 and the name of the project is "NEW", I will like the table to look like this:

NAME ID COLUMN ROW
NEW....123..... A.......1
NEW....111......A.......2

Thanks a lot
DAN

 

[Ziggy]

I might be missing something, but i have not heard of this approach in Access. So I am curious if i am wrong, but generally you would create a table and then use a form to enter data to the table.

create a new table and in Design your fields are created as such:

Field Name **DataType**

NameID **Auto number Primary Key**
Name **Text>**
ID **Number**
Column **Text**
Row **Text**

Then with the table created You can create a form that is based on the table, the fields will be windows into the table so to speak.

 

[dgrosen]

Hi Ziggy:
Actually I do have a table that has the following fields

Name
Column
Row
ID

 

[Gates Is Antichrist]

I can't imagine any other approach than to manage the data with code (VBA). Here you would use DAO or ADO code and database objects like Recordset to create multiple records by looping through the form controls looking for nonempty fields. Is that too hairy or do you want to look at that?

By the way, nice job posing the question. I skip over more posts than I answer simply because of [non]clarity in presenting the problem

 

[dgrosen]

Thanks a lot for clarifying the point. Any suggestions or ideas to achieve this without getting into the code nightmare?
Is there any other easy solution?

 

[dgrosen]

Any ideas where can I get an idea how to work it out?
Website, book, whatever!