Neetika said:
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....