Page 1 of 4 123 ... LastLast
Results 1 to 15 of 59
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    Take a look at this thread: <post#=324461>post 324461</post#>
    It asks a very similar question, and points you to a free, though somewhat limited, version of a PDF printer. AFAIK, all PDF is generated by directing output of a report to a pseudo-printer that creates a file which you can then email.
    Wendell

  2. #2
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    Thanks Wendell.

    I did manage to find that thread, but (because it took place between people who actually know what their doing) most of it is way over my head. Perhaps Pat or HansV will notice my post and offer a more detailed explanation of how he resolved the issue. I'm (unfortunately) going to need some hand-holding.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    Well, the steps aren't that complicated.<UL><LI>Download the free PDF generator referenced in that thread.<LI>Install it on your PC - it should have some instructions in the package (I've not actually downloaded it but my partner has).<LI>After installation, you should see a new printer which is the PDF generator - try printing your report to it and you should end up with a PDF file in the location you choose.[]li]Open the PDF with Internet Explorer and you should see a PDF that looks like your report.<LI>The last (and hardest part) is to modify the code Hans gave you to send the object by email - but it shouldn't be that bad - the biggest trick is to set a file location where you want to put the PDF before it is emailed.[/list]I'll let others amplify how they would go about it, particularly on the last step.
    Wendell

  4. #4
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    Yeah, the first three aren't that difficult (downloaded free trial of Acrobat 6.0 Pro), but there are too many manual steps to run through to send the file as an attachment (and then there is the file clean-up issue afterwards - these aren't small files!). Thanks for the feed-back. . .I'll keep at it and hope someone else has some advise on the issue. I really don't know enough code to understand, or modify, Han's attachment in the aforementioned post.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    When you say a rather limited version of a PDF printer, were you referring to PDF995? In what way is it limited? Is there a better alternative and what is the cost?

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    The file cleanup should not be too difficult as long as one could get at the date created of the PDF files. Maybe someone else could help here.

    I used PDF995 to generate PDF files on disk before emailing them using the routine Hans suggested called SENDMAIL.

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    Yes, I was - and must confess I'm not much of a PDF expert. As I understand it, if you really want all the features you should look at Adobe Acrobat 6.x or whatever the current version is. But looking at the web site for PDF995, it sure looks like it would do most anything I am likely to do. We've used it on a couple of projects and were quite happy with it - I believe you used it and found it satisfactory as well.
    Wendell

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    I think you should go back and read that thread carefully - it will cost you 9.95 to not get the ads with PDF995, but all the steps and code are there to do exactly what you want. Patt appears to have done it successfully too.
    Wendell

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    I thought I would ask as to what were the limitations, however you have answered that one. Yes I used it on a project quite successfully, the only hassle I had was to clean up the directory where the PDf files are generated as Bryan points out.

    While I'm on this, is there a way to get the date of a file on disk, I will need this to do an automatic cleanup.

  10. #10
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    Pat:

    Thanks for the reply! I'm actually miles away from file clean-up. I know pretty much nothing about code so I've been trying to just set it up to print to Acrobat (BTW, I am considering it for far more than e-mail, but if PDF995 will create custom forms I might consider it). It's not as if money weren't a concern, but I don't mind spending on something that can do all I want it to.

    The "reports" I need to send are a single page document to the shipper, carrier, and consignee (sent seperately) This can amount to nealy 150 "reports" a day. I really need to fine a single-click solution! I have not tried Han's code yet because I don't understand it. Maybe I should just go at it and see what I can crash; at least that way I might have some questions to ask. Right now I can print the report to a file in PDF, but the Acrobat window pops before my query requesting the unique Pro# of the order. I have to slide windows around to enter the number and then Acrobat continues to write the file. When I get the file view I need to assign it some name or number (because there will always be a default to the same file name), save it, then Acrobat window gives me the option to e-mail. I'd have blisters on my fingers before 9:00AM!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  11. #11
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    <P ID="edit" class=small>(Edited by bfxtrfcmgr on 25-Jan-04 14:51. (Deleted derogatory comment about Mr. G))</P>Thanks Wendell:

    Your right, I really need to absorb that thread and maybe just take a shot at crashing a copy of my db several time so I can get a little understanding.
    Hi-ho. . .hi-ho. . .it's off to. . .

    <img src=/S/bouncenburn.gif border=0 alt=bouncenburn width=31 height=31> Why can't Microsoft and Adobe just learn to get along?
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  12. #12
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    What you can do in PDF995 is to create files by 1 of 3 different methods:
    1. Allow a Save As dialog box popup and you enter the name.
    2. Let PDF995 automatically assign the filename for you.
    3. Save all prints as the same name.

    I would tend to use option 3 and then just delete the file after use. But if that's too sudden death why not have a cleanup program once a day, like first thing in the morning, to delete all files from the PDF995 directory. Or you could use a one-click solution as you suggest, all you need to do is put the delete code behind the button, if you require help on this please let me know,it's not difficult when you know how.

    If you pay the $9.90 to PDF995 then when you print you don't even notice anything as it's all automatic.

  13. #13
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    Pat:

    I really appreciate your help with this (I'm looking through Han's code now). As I think of it, I am leaning toward op-3 also. The reports will all still exist in access, so deleting the file (or just letting it stay there continually over-written) shouldn't be an issue (I don't think). I also looked at the PDF995 site and didn't see where it had the custom forms capability that Adobe has - which I was considering for other reasons before this "e-mail" issue raised its ugly head after we had already resolved it (SNP and Han's code was simply beautiful!).

    As the governor of this state would say. . .I'll be back! (I still can't believe he's gov.)
    Thanks again for your offer of assistance.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  14. #14
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    Let's hope he doesn't turn into the Terminator, else heavon help California.....

    >>The reports will all still exist in access, so deleting the file (or just letting it stay there continually over-written) shouldn't be an issue (I don't think)<<
    You are absolutely right of course (about being continually overidden, DUH), it should not be a problem as long as you don't overide it too quickly especially if you are emailing them.

    What do you mean by Customer Forms capability?

    Here is an example that I did for a ** Possible SPAM post - please alert a Moderator (2)**:

    sWhere = "WeekEnded = #" & Format(TextFromDate, "mm/dd/yy") & "#"
    DoCmd.OpenReport stDocName, acNormal, , sWhere
    Dim blsend As Boolean
    blsend = SendMail(strEmailAddress, "Stock Unavailable Report", ".", "cdf995Outputqry rpt Unavailable Product List.pdf")

  15. #15
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Change SendObject format (SNP to PDF) (2002 SP-2)

    LOL. . .custom, not customer forms. I send out a great many forms that are filled out by hand (by truckers generally) and, well, some don't have the best handwriting. E-mailing a form they can fill-out on screen (with combo and list boxes) and fax or mail back is one of the considerations.
    (Still "munching" away at trying to figure the code out. . .I shall return)
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Page 1 of 4 123 ... LastLast

Posting Permissions

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