Option to allow queries and reports from within a menu form

[u0107]

Hello,

I have a menu driven application.

One of the options I want to give to my users is the ability to create and maintain queries and reports.

Is there some way in which a button if clicked on a menu or form will provide the User interface for Query or Report creation?

Thanks in advance.

Uttam

PS: While not mandatory, would this option continue to be available after converting to an MDE file or will conversion result in this option not being available?

 

[Graham T]

Uttam

You could use the following:

DoCmd.RunCommand acCmdNewObjectQuery

DoCmd.RunCommand acCmdNewObjectReport

HTH

Graham

 

[u0107]

This works to provide an option to define a new query.

Would you have something which will show existing queries like we normally see when we open a database in a development mode?

Thanks in advance.

Uttam