Unable to Create Dynamic Report in accde file of VBA access

[Maya16]

I have created one application in access using VBA. In this project I am creating Dynamic Report. I am able to create and open report in development environment i.e. when the project is in accdb format but when I try to run the same project using accde format it gives me an error. "The command you specified is not available in an .mde, .accde or .ade database. Does that mean, I cannot create report in accde or is there some other porblem?

[Rabbit]

The purpose of an accde is to prevent people from making changes to the design of the database.

[Maya16]

Is there any soln to open reports in ACCDE format? Or How can i Create report in ACCDE format?

[TheSmileyCoder]

Lets first look at why you want a dynamic report. Most likely you can achieve the same by using the built in available methods of access, without resorting to creating the report from scratch each time.


Usual approaches involves designing the report, and then either modifying its recordsource, or supplying a filter (essential a SQL where clause without the WHERE keyword) while opening the report.

The more info we have regarding what you want to achieve, the better guidance we can supply.