Listing Forms In Listbox

[desireemm]

One Form To Rule Them All

I several forms from different tables and I would like to put all the names of the forms in a list box which in turn will pull up a form for each department. Been researching how to do this but finding no answers

Help please

 

[Mile-O]

Is each department so different that you need separate tables for them?

Link

 

[desireemm]

Forms

No I have joined the tables after making some alterations through queries,

 

[desireemm]

ONE FORM TO SHOW THEM ALL

Is there some kind of coding I can use to do this task, I'm new SQL student so I still have alot to learn

Would appreciate any advice you may have

 

[Oldsoftboss]

Hope this is what you are trying to achive

Dave

 

[Cosmos75]

Really Handy!

Oldsoftboss,

Wonderfull! Two Thumbs Up!

You've even included code for showing Tables, Queries, Reports, Macros and Modules!!


Now, if you'll only create code to build the database as well that would be just perfect!

 

[desireemm]

Thank you

I want to thank you for your awesome reply I have been banging my head up against the wall for weeks on this. YOur awesome thanks again.

 

[WayneRyan]

List of all object types (courtesy of Pat):

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=7463&highlight=msysobjects

Wayne

 

[Oldsoftboss]

Have had a bit more of a fiddle around. If someone could add the code to open a macro in design view ???
Dave

 

[Oldsoftboss]

If the Access wizard can build a Db, I'm sure it can be done.

Anyway, I got sick of designing forms and the having to go through and set all the form properties so I made this....

I use this Db as a template for a new project, then delete the form at the end.
Dave