How do I export a single record in Access 2003

[Guest]

I have to fill out a report every week and I'm using Access 2003 for this. I
would like to start to e-mail the report out, but Access will not allow me to
export a single record but want to do them all. Is there a way to export a
single record with out doing them all?

Thanks

 

[Van T. Dinh]

Create a Query that selects only the Record you want and export the Query
rather than the Table.

 

[David Lloyd]

Van's method is one alternative to do this. Another alternative if you want
to email the actual report is to use the OpenReport method to filter the
report for a single record and then use the SendObject method to email this
filtered report. By not specifying an a report name in the SendObject
method, Access will use the active report. For example:

DoCmd.OpenReport "MyReport", acViewPreview, , "ID=10"
DoCmd.SendObject acSendReport, "", acFormatSNP, "(e-mail address removed)",
, , "Email Subject", "Email Message", False
DoCmd.Close acReport, "MyReport", acSaveNo

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

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


I have to fill out a report every week and I'm using Access 2003 for this. I
would like to start to e-mail the report out, but Access will not allow me
to
export a single record but want to do them all. Is there a way to export a
single record with out doing them all?

Thanks