Using the Tab Control to create a new table.

[PurpleGod]

Hi there,



I am a student and i'm taking a course on access 2010. I'v been stuck on this assignment for a long time and haven't found any help on the Internet. The assignment is due in 3 days, I have most of it finished, but I am stuck on one part. Here's what I need to do:

Create a tab control, in a form, that when you add a new tab, it automatically creates a new table. In that table there are fields that should be automatically created as well.

I know how to create a tab control in a form, and I also know how to link data from a table to a tab control. But I have NO IDEA how to create a new table (with fields) just by adding a new tab! Is this even possible? Please help!

[ItsMe]

Sounds pretty crazy. Is it possible? Probably is ...

Why don't you post, verbatim, the part of the assignment that is requesting the table to be created.

[June7]

Very weird assignment. Don't see how it relates to real-world situation. Users should not be able to modify db structure (create tables, modify forms, etc). And implementing a procedure that routinely builds new tables smacks of non-normalized data structure.

I have never tried to build code that would run from Design or Layout view. Since Access/VBA is event driven, just what event would this code be associated with?

Suggest you challenge the instructor for more guidance.

[PurpleGod]

He showed us an example he created, doing exactly that. So I know it's possible :/ I might just have to take a 0 for this part cause I have no idea how to do this. I even tried integrating a module into my tab control but that was hopeless

[June7]

So just how is user allowed to create the new 'tab'? Is this actually a Navigation form? I don't like and don't use.