Hi Everyone,
I have inserted fields from a query into a data access page, in the form of a Microsoft Excel Spreadsheet.
The query prompts for certain parameters, which works fine within access.
However, when I utilise the page from the internet, the parameter screen continuously pops up, prompting for information. If I set the UseRemoteProvider option off, then it works fine through Internet Explorer.
I have to, however have UseRemoteProvider switched on so that remote users can utilise the page.
I need the user to be able to import the data onto their system, in the form of a text file etc. and was using the Export to Microsoft Excel Button.
A button to transfer the data contained within the query would be sufficient.
Can anyone help???!!!
Thanks,
Natalie
I have inserted fields from a query into a data access page, in the form of a Microsoft Excel Spreadsheet.
The query prompts for certain parameters, which works fine within access.
However, when I utilise the page from the internet, the parameter screen continuously pops up, prompting for information. If I set the UseRemoteProvider option off, then it works fine through Internet Explorer.
I have to, however have UseRemoteProvider switched on so that remote users can utilise the page.
I need the user to be able to import the data onto their system, in the form of a text file etc. and was using the Export to Microsoft Excel Button.
A button to transfer the data contained within the query would be sufficient.
Can anyone help???!!!
Thanks,
Natalie