Running Reports from Different DBs

[crpjaviman]

I am in the process of creating a form in one Access 97 db that will require to call upon creating reports in a different Access 97 DB. The reports are already created in the second DB, I just need to run them without opening it separately.

Is this possible? I have been told that it is not possible.

I am pretty sure that it will need to be done through code, but how?

Any suggestions?

Thanks,
crpjaviman

 

[Darrylles]

Hiya,

I know what you want to do, 'cos I've had the same idea in the past: you want to stop duplication of code, forms, reports etc by re-using them (just like you do by 'linking' tables).

I've asked many people the same question, but have always been told 'not an Access feature'.

The logical way around this is to incorporate one 'front-end' into another to make it more 'centralised' and singular.

If the front-ends are so closely related (obviously use the same data) - can't you do this?

Regards,

Darrylle







"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[TrojanRabbit]

I'm not sure if you can open the report without the db.

You can, however, import the record into the current db via VBA. If the report is opening with data from the current db, that would be a way to do it. The following command will do that:
DoCmd.TransferDatabase acImport, "Microsoft Access", "D:\CRMReports.mdb", acReport, "QuoteReport", "QuoteReportTest"

You may need DoCmd.SetWarnings False to turn warnings off, but I'm not sure.

 

[ken39]

hello everyone,

I am very new to VBA in fact I am learning as I type been a Java Prog for too long... I hope you guys can help me out on this.

errmm...if I asking too much pls tell me so...I will apologise

1)I wanted to create a button in a form that when clicked for example will get all id's entered and query my database and retrieve the needed data to generate my report.

2)I want to create a click, print and go (automation) for my access report.

Can someone show me a direction of where I can get a head start on this?

thank you very much!