Access Runtime 2003 Export to Excel Toolbar gone - replacement options?



I have just upgraded my front end from access 97 to Access 2003 runtime. A
few users have complained that the ability to export reports to excel (the
excel icon in the toolbar) has disappeared. From reading around I
understand this is one of the drawbacks to the runtime. Apart from this my
app runs fine. Is there a way to replace the export to excel function - I
know I can use code to output a specific report to excel but how can I
create a button in the toolbar to export any report?

thanks in advance


You can create your own custom toolbar or menu bar and add the relevant
button to it. See the Access help for 'custom menu' or 'custom toolbar'.

It's pretty easy to do but if you need any more help just post back.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question