Auto crate table

[Slade2000]

what i want to do is:

I have a "create user form" if i click add i want the program to automatically create a new table with certain fields for each new user added?

Tnx

 

[John Big Booty]

Are you sure you want to create a new table for each new user? Or do you just want to add new users to an already existing table?

If it is the latter you can set defaults for any filed you like in a table, by setting the field default value in the table design view.

If it is the former, there are ways of doing that to, but at this point I can't understand why you would want a new table for each user, your DB would quickly grow to an unmanageable mess.

 

[Slade2000]

I c. It is basicly a work hour overtime system i want to write. What will work the best?

 

[John Big Booty]

Check out the templates within Access, also check the templates available here, there may be other sources on line as well.

Whilst you may not find exactly what you are looking for you might find a template that does something similar that you can get some ideas from, and implement in your own design, or simply modify the one that most closely matches your requirements.

 

[Slade2000]

Grate tnx allot