Report list

[Bladerunner]

I have several reports that are in the Report section of Access 2010. Is there any way I can access those reports from a cbo on a form. If so, will this have an effect on the program when it is in .exe format?

Thanks in advance

Have a nice day :>)

Blaerunner

 

[CJ_London]

You can't convert Access to .exe so not sure what you are trying to do?

 

[Bladerunner]

OK, Am use to VBA, Lets say a standalone or other type access programs.

While using Access of course you have a tbl, qry, frm and rept listings. Can a cbo pull from the rept listings instead of listing every rept in a tbl and then use the cbo.

thank you


Bladerunner

 

[CJ_London]

Are you are asking 'can I run a report in another access database?' or asking 'can I list the reports in another access database?'

If the latter then yes you can you would use SQL like this

SELECT [Name] 
FROM [FONT=Calibri][C:\Test Databases\TData.accdb;PWD=mypassword].[/FONT]MsysObjects
WHERE [Type]=-32764

if the db is not password protected then remove ';PWD=mypassword'

 

[David R]

I don't even think he's asking about another database. I think he just wants his switchboard to have a combo of all Reports in THIS database.

Per http://allenbrowne.com/ser-19.html

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

 

[Bladerunner]

NO, not for use in another DB. Just wanted to pull up a list of reports that are listed in the Access objects (report) section instead of re-writing each report name into a tbl and then pulling them up in a cbo.

Appreciate your help

Bladerunner

 

[CJ_London]

On rereading, I do believe you're right

 

[Bladerunner]

David R. you response was posted after I started writing my response. Did not see it until my response was posted... Thanks for your help.

Bladerunner

 

[Bladerunner]

I don't even think he's asking about another database. I think he just wants his switchboard to have a combo of all Reports in THIS database.

Per http://allenbrowne.com/ser-19.html

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

do you know if this needs to be compiled first or will it work in open Acess. Is I cannot get either one of them to work? They do not fill the List box.

Thanks again

Bladerunner

 

[David R]

Start simple. Build a blank query and put that in the SQL. Run it and see if you get the desired results. It works on my system (Access 2010), and I trust Allen Browne. It should work in 2003 as well, based on http://perfectparadigm.com/tip001.html which was written back then.

 

[Bladerunner]

Start simple. Build a blank query and put that in the SQL. Run it and see if you get the desired results. It works on my system (Access 2010), and I trust Allen Browne. It should work in 2003 as well, based on http://perfectparadigm.com/tip001.html which was written back then.

forgot about having to make a query for everything/. Thanks again.
It does work.