Exporting reports from Access?

[klintsovi]

Hi,

Is there a way to export reports from access database within vb app so that they later can be imported to a different DB? or is there a way to create reports from vb app?

Thanks

[JamesM]

Is there a way to export reports from access database within vb app so that they later can be imported to a different DB?

You can transfer reports between Access databases using the transferdatabase method of the DoCmd object:

 

DoCmd.TransferDatabase acImport, "Microsoft Access", _
    "C:\DBS\Test.mdb", acReport, "Sales for April", _
    "Corporate Sales for April"

[GenePester]

I have successfully use the DoCmd.Transferdatabase for Tables and Queries, but Reports and Macros I get an error msg ""MS access can't save the design changes ... because an other user has the file open. To save your changes .... You must have exclusive access." on the destination database. I have tried making the destination database exclusive and it didn't make any difference.

Both the Source and Destination database are on the same PC, no external users. Any body have any ideas? Thanks

Gene

[mcsmba1]

or is there a way to create reports from vb app?

Yes, you can create reports through DataReport which is included in vb 6, or you can also create reports through CrystalReport, you can install it and can use with vb

[gep13]

Moving to the Reports Forum.

Thanks for the report mcsmba1

Gary