Re: Can one open a report in another mdb? (by RLi)

Check out the TransferDatabase method or action. Of course, there may be a
better way to accomplish what you're after, but this may work for you.

Using TransferDatabase, you name the report in the source location (the mdb)
and the target location (your mde). You could have several reports stored
in the mdb that the user can mess with. When importing them into your mde
for execution, you may wish to retain the report's name, or you could give
them all the same name (within the mde) so that only the latest would be
retained. Upon completion of the import, you would issue an OpenReport to
perform the desired result.

Bob


"Rob" <Rob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3024ABF6-9C16-42DA-BFA7-3B3E50138024@xxxxxxxxxxxxxxxx
You mean importing it on the fly in the mde? How do you do that?

What i want is distributing a mde with forms/queries/modules etcetera and
a
separate mdb with only the report definitions. In that way i could easily
send updates to customers (simply a new mde) without them loosing their
personnalisations of the reports.
So i would like to be able to call reports in the (open) mdb from the
(protected)mde.
Importing them first might be nice, but since the mde does not allow for
any
VisualBasic changes i expect an automatic import might fail.
Am i wright, or did i misunderstand you suggestion?

"Bob Howard" wrote:

How about importing it and then executing it?

Bob

"Rob" <Rob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1AF0FD30-FD65-443A-9FCD-6BA65D538B1C@xxxxxxxxxxxxxxxx
I have a split database, front end/back end.
The front end contains the form/reports/modules/queries etc.
The back end the tables and data.
The front end is distributed in mde format (so vba and design mode are
non
accessible).
I would like users to be able to see and freely modify the report
design,
but not the forms design.
So i thougt: maybe store the reports in a separate (open) mdb.

But can anyone tell me if one can call a report in a mdb from a form
stored
in another mde? And parsing filters from the form to the report?

Thanks for any reply,
Rob





.

Relevant Pages

  • Re: Cant update a Report fiels
    ... The logic works in the *.mde version, but not in the *.mdb version. ... I'm able to return the filter string back to the ... >> announce to the report readers that the report is filtered. ...
    (microsoft.public.access.formscoding)
  • Re: Design not working for reports
    ... Nowhere is this post does it say I'm trying to edit the report in the mde. ... its an mdb test file. ...
    (comp.databases.ms-access)
  • Re: Open External Database Form
    ... on a report, each time I close the report it forgets the size. ... an MDE it forgets it. ... You could have the mdb application open the report automatically via an autoexec macro or | You could follow a hyperlink to the report in the mdb application. ... You could set a reference to your mdb file from your mde and open the report (or form that opens the report) from a standard module in the referenced mdb. ...
    (comp.databases.ms-access)
  • Re: Open External Database Form
    ... on a report, each time I close the report it forgets the size. ... an MDE it forgets it. ... You could have the mdb application open the report automatically via ... standard module in the referenced mdb, which I believe is the usual ...
    (comp.databases.ms-access)
  • Re: Lock / Unlock VBA project
    ... "Alex Dybenko" wrote: ... make MDE? ... library MDB - create ne mdb, import forms/modules from your app, which ... have to make MDE of it and add reference to library MDE in order to make MDE ...
    (microsoft.public.access.modulesdaovba)