How to get List of Objects in Combo Box

[mba_110]

Hi everyone,

I would like to have following objects in each separate combo box, Control Source of combo box can be filled with some SELECT type SQL but i am not sure about this.

1. Forms
2. Query
3. Modules

If it's possible you to provide SQL than it will be great!.

I have already table and reports, but missing the above.

Thanks & regards,

MA

 

[bob fitz]

I have already table and reports, but missing the above.

Perhaps you could modify whatever you did for these two, to get the other three.

 

[mba_110]

Tables
SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=6) AND ((Left([Name],4))<>'MSys')) ORDER BY MSysObjects.Name;

Reports
SELECT [MSysObjects].[Name] FROM MsysObjects WHERE (Left$([Name],1)<>"~") And ([MSysObjects].[Type])=-32764 ORDER BY [MSysObjects].[Name];

I am a learner and I don't know for remaining three because the above are totally different with each other format.

Any help without cross answering will be appreciated.

 

[Minty]

If you simply use

SELECT MSysObjects.Name , Type FROM MSysObjects

You will get everything in the MSysObjects Table with its object type. Choose what you want to see.

 

[mba_110]

Please if you don't want to help than no problem, each of this SQL is totally different from other.

As you can see in my previous post, in control query it giving lot of names & type which i don't know how to filter it.

 

[Minty]

It's not that I'm not trying to help, just guide you to a possible solution.

A 2 second google search bought up this thread on here https://www.access-programmers.co.uk/forums/showthread.php?t=222584 which I think answers all you needs.

 

[mba_110]

Yah That make sense a great resource of knowledge, thnks Minty...