Need Help for Automation of Tables and Forms

[Brad_Newman]

Hi Everyone,

First of all, I would like to thank each and everyone who helped me out earlier with regards to my queries on multi user login forms.

I have another query with me, hope anyone on this forum can help me out on this....
I need to create a button on which when I click it should automatically make a new form with the same structure of the default one.
Basically creating forms and tables automatically without any manual input again an again as I need to do it 52 times for each agent and I need to do this for 9 of them which means 52x9....which is quite a time consuming activity..

Is there any other alternative where maybe I can run a macro or do something so that I have to create only one of these and rest 51 can be done sutomatically on just a click of button?

Basic structure is as below:

1. Main form\Parent form
2. then a sub form having 12 diff buttons for each month in the year.
3. and lastly another sub form in every month button ( which will be a navigation form) for all the weeks in the month

Can anyone look into this and let me know if this can be done??

 

[plog]

I'm sure it can, but I'd advise against it. But first, allay my fears: Do you have 52 sets of tables with the same structure as well? Does each agent have his own table system? Please say no.


As for your forms, if you have properly structured tables (not 52 sets of them) you can use the same form system regardless of the agent, you would simply create a new form which opens prior to the other forms. This new form would have the agent select himself and click a button to open the next form and pass his information to it, so in effect its like he is opening his own form.

Again though, this is predicated on a proper table structure, which I fear you don't have.

 

[michaeljryan78]

I'm sure it can, but I'd advise against it. But first, allay my fears: Do you have 52 sets of tables with the same structure as well? Does each agent have his own table system? Please say no.


As for your forms, if you have properly structured tables (not 52 sets of them) you can use the same form system regardless of the agent, you would simply create a new form which opens prior to the other forms. This new form would have the agent select himself and click a button to open the next form and pass his information to it, so in effect its like he is opening his own form.

Again though, this is predicated on a proper table structure, which I fear you don't have.

oh no.... I totally agree woth you. I would also suggest that you can utilize the TempVars collection to store the UserID og the person accessing the system and drive recordsource of the form off that userID.

recordsource = SQL & where tempvars!userID = [whatevertheuserIDis]