Access 97 Runtime Problem 1

[tlister82]

I have been asked to implement an Access 97 database that I created across our organization (approx. 150 users). In order to do this I will be using an Access 97 runtime version of the application. Since I have always had Access on my system I didn't realize until after I installed a runtime version of my application on someone's PC who did not previously have Access that the Print/Save options do not exist.
This is an MDE file and everything else works fine but I need for the users to be able to Print/Save and email output from this database if they so desire.
I have tried several forums and have come up dry.

Can someone help?

 

[jfischer]

You could use the DoCmd.OutputTo method invoked by a command button click to write the results of a report to a file in various formats, e.g., HTML, RTF, TXT. Your users could then e-mail that file by procedures that you've set up in your organization.

If you want to program the e-mail function directly into your MDE and your organization uses Microsoft Outlook, use the DoCmd.SendObject method and make sure to include the Microsoft Outlook 9.0 Object Library (MSOUTL9.OLB for Outlook 2000) in your References for the MDE. Each user of your MDE must have Outlook installed on their local PC. If you have remote users who connect to your network using NT Terminal Server, make sure that Outlook is installed on it and MSOUTL9.OLB is accessible to each user in a common directory as defined in your References.

The Access online Help for both of these methods/actions is pretty good and should help you set up what you need.