Automatic table creation

[dgrosen]

I've been trying for a long time to solve this puzzle but I am stuck!!!
I need help from the masters!

I have three text boxes. One prompts for the name of the table, one for the number of columns and the other for the number of rows.
I want to create a macro that will create a table with the given columns and rows.

Is that possible do to in Access?

Dan

 

[Joe4]

I imagine something along these lines can be programmed in VBA, but there are some important points you need to be aware of and would need to clarify.

The traditional Rows & Columns lexicon that is used in Excel really doesn't apply to Access. Instead of "Rows & Columns", Access has "Fields & Records". They require different criteria.

In setting up the "Fields", you need to specify what kind of record each field is (Text, Numeric, Note, etc.).

To enter a specific number of "Records", you physically need to put at least one value in one of the Fields for each record. You cannot have a completely blank record. You might be able to accomplish this by setting up an Autonumber field.

Armed with this knowledge, how does it change your request?

 

[Norie]

It can be done in VBA but I still don't see what you are trying to do.

 

[dgrosen]

What will you suggest?
Should I create an individual field for each spot? For example one field named A1, A2, A3...Z14 and so on?
More or less, what I am trying to create is a grid similar to an appointment calendar, where you have days within a month and you can browse back and forth. Instead of having months I will name it according to the project and each day will be a spot (A1, B2..)

I am open to suggestions. Thanks

 

[dgrosen]

Hi Norie:
I am a stone and sea shell collector.
I have created a database using access where I input the name of the box, the ID of the sample and its location in the box (A1, B2..). I would like to have it in a more visual display.
I am trying to have this database for my own personal use to keep track of them.
I put the samples in boxes. The boxes have a grid and each spot contains one stone or sea shell with a unique ID#. Each boxes are named different and have different number of spaces.
Hope this helps
Thanks a lot
Dan