Reports & MDE

[johny678]

Hi!!!
I am using VBA to generate a Report depending on the fields that the user will choose to show up in the report or to group records by.
It all works ok, the thing is that I want to deliver the DB as a .mde file for all the known reasons, and this is where the problem is! I cannot open the report in desing view (using code) to change the report according to the user's will.
Any ideas on how to generate reports in a mde DataBase?
Thanks!

 

[RV]

You can't.....
You need to make your changes in your mdb file.

RV

 

[johny678]

Great!!!
The fact is that an old db that we were using (developed by a firm) was doing such a thing. Is it possible to generate the report in the db (which is .mdb) that holds the data for the front end and then import it for preview in the .mde file? although I think that you also can't import or export objects in mde files, right? Anyway there must be a way to do it! We just have to find it!!!
Thanks anyway RV..