How do I export a single record in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Create a Query that selects only the Record you want and export the Query
rather than the Table.
 
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
 
Back
Top