Using the docmd.sendobject in a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andym - 20 Jan 2006 15:28 GMT

Hello,

One of our customers has multiple people using an access 2000 MDE that is
using the docmd.sendobject method to send an email of a landscape report to
an excel spreedsheet. The problem we are having is when people using pc's
with screen resolutions of 800 x 600 instead of 1024x768 (which the report
was developed in) some of the data gets cut out. All of the fields are
shrunk. An example is one of the records is 200,000, the report shows 200
with the last three 0's not being seen, when we look at the spreadsheet, it
shows the 200 instead of 200,000. The only thing we've been able to figure
is that the docmd does a screen preview of the report and uses data from that
preview to populate the excel file. Is this what it does, and if so is there
some way around this?

Thanks,
Andy Mikkalson

Reply to this Message

David Lloyd - 24 Jan 2006 22:02 GMT

Andy:

I don't know all of your specifics, however, have you tried using the
SendObject method to send the query behind the report, rather than the
report itself? Other options, depending on your circumstances, might be a
compressed format, smaller font, a larger paper size, etc.

Signature

David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.

Hello,

One of our customers has multiple people using an access 2000 MDE that is
using the docmd.sendobject method to send an email of a landscape report to
an excel spreedsheet. The problem we are having is when people using pc's
with screen resolutions of 800 x 600 instead of 1024x768 (which the report
was developed in) some of the data gets cut out. All of the fields are
shrunk. An example is one of the records is 200,000, the report shows 200
with the last three 0's not being seen, when we look at the spreadsheet, it
shows the 200 instead of 200,000. The only thing we've been able to figure
is that the docmd does a screen preview of the report and uses data from
that
preview to populate the excel file. Is this what it does, and if so is
there
some way around this?

Thanks,
Andy Mikkalson

Reply to this Message