ACCESS 2007 Exporting to WORD/EXCEL at runtime

[Neetika]

I have and ACCESS 2007 db. When it is deployed in runtime mode, I cannot use
the Export to WORD/EXCEL options anymore. IS there a solution?

 

[Albert D. Kallal]

I have and ACCESS 2007 db. When it is deployed in runtime mode, I cannot
use
the Export to WORD/EXCEL options anymore. IS there a solution?

Are you sure of the above? I am reasonably sure that if you provide a form
with a button and behind that code call the routines to export?

Check out the

docmd.TransferSpreadsheet

In the help. In other words, the options are there, you just have to provide
a custom ribbon, or form that allows the user to "get at" the option.

when using the runtime, the end user will not have purchased ms-access (and
likely will not have wanted to). So, you as the provider of the application
thus have to provide a means to expose what options the user needs.
Displaying every single access option is likely to overwhelm the user, and
further require them to have some access training which (hopefully) you been
hired to eliminate this need in the first place....

 

[Neetika]

I cannot do a transferspreadsheet on a report. IF I export the query, then it
looks all plain and simple and no. of records can be difficult to interpret
for the end-client.

I want to export the report in the same format.