Solved

Send a report using Access Runtime by mail.

Posted on 2004-10-05
3
189 Views
Last Modified: 2010-05-18
I succesfully developed an application using access 2000 and installed on my en user machine using
access run time 2000 however when they create a report they want to send it by mail.

And the only option they have is to print it to a printer.
Is there a way to enable the  following commands in ART?

FILE -> Send to
FILE-> Export
0
Comment
Question by:TOPIO
  • 2
3 Comments
 
LVL 10

Author Comment

by:TOPIO
Comment Utility
Programatically I tried to change the code by using
docmd.transferspreadsheet  acexport, acspreadsheetTypeExcel9, "RPT_TopRespiratory", "c:\temporal\temporalfile.xls"
but this method only works for a table and I have all the information in a query
0
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 500 total points
Comment Utility
The SendObject command can be used to send a report - but try to avoid it unless absolutely necessary.

You could also create a right-click (shortcut) menu for the report which has the send to and export options on it, and make that into the report's shortcut menu.
0
 
LVL 10

Author Comment

by:TOPIO
Comment Utility
I ended up using
DoCmd.OutputTo acOutputReport, , acFormatRTF
this will output the current report to a word file and you can
do wathever is necesary with that
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now