Back End Reports

[PC User]

Is there a way to store reports on the backend of a split database and still use them on the frontend? I also need to read from the MSysObjects that is on the backend without linking to it.

Thanks,
PC

 

[PC User]

Ok. I got a little hint about how to do it, but I need some more help with this.

Public Function MyOpenReport( _
            strName As String, _
            Optional strWhere As String = "")

    DoCmd.OpenReport strName, acViewPreview, _
            WhereCondition:=strWhere
    MyOpenReport = (Err.Number = 0)

End Function

 

[elbweb]

im about 99 percent positive there is no way to do this. my best solution would be to have code that builds/adjust a report based on database values, so that you could later change them.. or have multiple sub reports that you can switch where they are.. or something, basically very creative to give the illusion that they are changing, beucase i am almost positive that you cannot have a report on the backend.

one solution may be to have some way of downloading and importing a new report during a startup procedure, but thats beyond what i know how to do, im sure you could probably find some way to do it.. my but idea would be have code that downloads a new mdb file with the updates, then automate the 'import' process to copy them from that mdb, and then remove the downloaded one, but thats awfully complicated, im anxious to hear what happens if you figure a way to do this.

 

[KeithG]

If you want to view it in the FE why don't you put it there?

 

[Banana]

Would shelling out to the BE be an option? Not that I would know how to do that, though.

 

[elbweb]

the reason, which is the same i've thought about it, is that i think he wants to give a front end and then be able to update the front end without acctually giving everyone a new copy...

 

[PC User]

This public function works in the backend, but the command to minimize on view and maximize the form infront of the report on exit doesn't work. I had to set a reference to a backend seperate from the data backend with the reports with it. I put a command button on the form on the FE to call the function. Also I need to read from the MSysObjects that is on the backend without linking to it. So this way partially works and there must be a way to get the rest of what I'm looking for. Someone probably knows how to do this.

Thanks,
PC

 

[Banana]

If that's the case, Bob Larson's autoupdating utility will do the job.

Edit= Just saw PC User's reply. Apparently not. In that case, Shell may be the only way to do that.

 

[PC User]

That's an interesting and useful utility. Thanks for showing it to me. It has some interesting concepts. I'll continue looking for a solution.

Thanks,
PC