Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    send object question (access 2003)

    I use the command below to created a report based on a query using the strwhere statement. This works great to filter ther report in line 1 but I want to send the same report filtered in an emai using sendobject. Is there a way I can filter the attached report using my strwhere statement? Thanks...

    Line 1:
    DoCmd.OpenReport "NSReschedules", acViewPreview, , strwhere, acNormal

    DoCmd.SendObject acReport, "NSReschedules", , , , , , "test", "test2:", False, ""

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: send object question (access 2003)

    You'll have to change the report's record source. You'll find some sample code in <post:=275,460>post 275,460</post:> that could be adapted for your purpose.

    PS It would be nice if you acknowledged the replies to your questions, so that others know whether they were helpful.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts