Reports in a list.

[cap.zadi]

Helllo there,



I have now many reports in my data base for each section or unit. so i am planning to have some kind of comobox or list which can contain my names of reports. so when we go to the form of that section and report should open by clicking on the text (Report Name).

How is it possible?

thanks

zee

[rpeare]

make a list box with this as it's control source

SELECT [Name] FROM MsysObjects
    WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like "MSys*"))
    ORDER BY [Name];

[Robeen]

Hi rpeare,
Your SQL works in a query but in the List Box it says "This control has an invalid control source."
Any idea why that is?
I'm using Access 2010.

[rpeare]

I don't have access to your version so I couldn't say

[Robeen]

I plugged the SQL into Row Source and I get all my Reports in my Combo Box now.

I'm also getting "#Name?" as the first Value in the Combo Box when the Form Opens.

[rpeare]

The original poster is not using your version of Access, nor has he posted back that it didn't work for him. Please don't hijack his thread. If it works in a query, it will work in a list box.

[cap.zadi]

Hello Man,

Thanks to be here always. Yeah let me try for this bcz i have the original sample db of that type but i did not try becz was worried how to get the things in query. let me try and i am sure it will work. will revert u soon. thanks

[cap.zadi]

Hello Man, please can you explain little bit more how to do with this VBcode? thanks

zee

[rpeare]

It's not VB code, it's a SQL statement. IF you cut and paste the SQL statement into a query SQL window then run the query it will show you a list of all the reports in your database. Once you know that works then you can use the exact same query as a control source for your list box.

[cap.zadi]

hello there, its working. thanks a lot. bye

[cap.zadi]

Hello there, sorry have got the problem with reports.

The Error is Runtime Error 2103

The Report Name"abc" you entered in either property sheet or the marco is misspelled or reffers to a report which does not exist.

please advise?

thanks

zee

[rpeare]

You'll have to be more specific about what you are doing or what code you are running.