Is there a way to open a report in another mdb file

[rewdee]

I'm trying to open a report from my current mdb file in another mdb file.

Does anyone know how to do this?

Thanks,
Rewdee

 

[rewdee]

Found another way to do this- Just import the report using docmd and delete the object after I am finished.

 

[JoaoTL]

Hi, can you tell me what you are trying to do? Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access/eng/FAQE.htm

 

[rewdee]

I am documenting a database. I know Access has a wizard ("Documenter&quot to do this but this database is such a mess that it doesn't give the information that is helpful. I.E. the database has over 30 some tables but only three are linked, hence what I am trying to document is not only the properties of the objects but also were the objects are used.

In my contract, I have seven databases like this to document so rather than trying to manual put something together manually I am trying to build this wizard.

My particular question was related to iterating through the documents of a specific mdb of a specific container but to get some properties like recordSource the object needs to be open. Initially, I was wondering how to open an object from another mdb file (wizard file) but I will just import the object, get the relevant properties and delete the object.

If you have any suggestions, I am very open to hearing them.

Thanks,
Rewdee

 

[Databaseguy]

When you use the documentor, there is an option for "Save as Table" after the report is geneasted )It's in the file menu.). Once you have your table, and study it, you can figure out the parents and children and query against it accordingly.

Or, I've got some simple sample code for browsing objects. 97 or 2000 ?? The basics are on my web page. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[JoaoTL]

Hi, in this link you have a function to get a report frm an external DB:

http://www.mvps.org/access/reports/rpt0012.htm.

If you whant i can post some functions to manage Data in an external DB.

Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access/eng/FAQE.htm

 

[rewdee]

Thanks JoaoTL the code is great.

As for why I am not using the documenter save as table function is because as far as I can see even when I use the document all, it does not show where a query is used. For example in which modules and which procedures.

If someone knows how to get the documenter to do this, I'm all ears.

Bill N

 

[JoaoTL]

Hi Again, try this

http://www.mvps.org/access/queries/qry0002.htm.

Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access/eng/FAQE.htm