Problem due to no design view support of mde DBs

[fugifox]

I have a DB in .mde where I want to anagrammatically open some Reports in Design view
to change the ControlSource property of some Controls in the Report.
The problem is that opening in Design View is not supported for .mde databases,
so I am looking for suggestions on how to change the ControlSource property
without having to open the Report in Design view.

 

[RuralGuy]

You will probably need to create different reports for each condition. Either that or create the query with the data you need in the fields you need them in.

 

[fugifox]

You will probably need to create different reports for each condition. Either that or create the query with the data you need in the fields you need them in.

That is exactly what I wished to avoid!
Basically, I have a few Reports with some Controls each.
I want user to be able to set criteria for each of the Controls.
If I implement this with different queries I'll need one query/report
for every combination of the criteria!
That's why I'm stack with this way which unfortunately doesn't work on mde.
Any other suggestions?

 

[RuralGuy]

Only the suggestions I've already posted. Sorry.

 

[gemma-the-husky]

can you not change the reports record source with code even in a mde. Offhand I believe I do this,

in a report

me.recordsource = "whatever"

 

[Rabbie]

Can you actually change VBA in an mde. Isn't it already pre-compiled?

 

[boblarson]

You can change the recordsource, but you may not be able to change a control's CONTROL SOURCE, which may be their problem.

 

[pbaldy]

You can change a report control's control source in the report's open event. I do it all the time for dynamic crosstab reports.

 

[fugifox]

You can change a report control's control source in the report's open event. I do it all the time for dynamic crosstab reports.

Thank you pbaldy!
you save me from many hours of work!

 

[gemma-the-husky]

thinking about it again - of course you can do it in vba, (although you cant open the design directly in an mde)

if you have code that does it in vba, it will still compile into an mde.

-------
there are probably some things you cant do in code, where you HAVE to edit the design, but I suspect you can change permanently a lot of things in an mde through code, that you owuld normally do in design mode

 

[Rabbie]

thinking about it again - of course you can do it in vba, (although you cant open the design directly in an mde)

if you have code that does it in vba, it will still compile into an mde.

Reading the original post it is not clear that the original poster actually has the .mdb so unless he has this I fail to see how he can modify the VBA directly in the .mde. Perhaps I am missing something.

If he has the .mdb then there is no problem in amending the design and compiling a new .mde but if he hasn't how does he amend the VBA

 

[pbaldy]

Thank you pbaldy!
you save me from many hours of work!

No problem; glad it helped.