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

    SendObject (Access 2000)

    I am writing a macro to attach to a command button on a form. I would like to send the current record via email. Using the SendObject command I can see how to send the entire form with all records, but I just to send the active record.

    Any hints?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SendObject (Access 2000)

    Define the "active record". Are you talking about exporting a spreadsheet containing the current record, or what?
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SendObject (Access 2000)

    yes - the current record.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SendObject (Access 2000)

    But in what format?
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SendObject (Access 2000)

    Sorry - here's the scenario. There are some users (who through security) are not allowed to update or delete records on a form and it's subforms. If they make a mistake that they find needs to be corrected, I want to be able to send a snapshot of that record via email to someone who has permission to make changes. it could be in HTML or it could be certain fields (like Valve #, Serial # and Job #) in a text file. When receiving the email message the person (with full permissions to the db) would make the appropriate corrections. Maybe there is a better way that I'm not thinking of.

    Thanks!

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SendObject (Access 2000)

    I'm still confused. If they can't update or delete records, how did they make a mistake in the first place?

    Anyhow, you can use code to create the snapshot:

    DoCmd.OutputTo acForm, frm.name, acFormatSNP

    Where frm is the Screen.ActiveForm. This is aircode, since my Access installation is insisting that the registry keys for exports are missing. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Charlotte

Posting Permissions

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