Report to Excel

[ismailkhannasar]

Dear , i like to export the report from MS Access 2010 to Excel 2010 how to do .. please find the attachment where to click even i can send only into PDF

[June7]

The database is set to hide most of the ribbon. So the External Data tab is not available. That is where the Export to Excel button is located. Without the ribbon, must write code to perform export prodcedure or build custom ribbon to offer the export functionality.

[ismailkhannasar]

dear , i m new in ACCESS how to do ,, should i create new report or import button what to do ,, i really dont know thanks

[alansidman]

Google is your friend. Look here at the many available solutions.

http://lmgtfy.com/?q=Access+VBA+export+report+to+PDF

[June7]

You should first understand why the full ribbon is not displayed. This can be a setting of the database.

File > Options > CurrentDatabse > RibbonAndToolbarOptions

Is this db an mdb or accdb file? Hold down shift key while opening and most of the optional file settings will be ignored and the full ribbon should be available.

[ismailkhannasar]

thanks June