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

    blnEditMail (2002 SP-2)

    I could have sworn that the attached procedure sent the email to the outbox of OL, before the blnEditMail portion was added. The idea at the time was that I wanted to verify that the correct message and recipient was being sent. Now, having some limited confidence in my own app, I want to just send it without having OL bring it up as a new message. Simple enough, just change "blnEditMail =" from true to false. Nope, same result - brings up the new message window. Am I missing something here? (..besides common sense that is). I don't want to eliminate the bln statement entirely, because it seems a nice testing feature.

    Also, the reason it's an attachment is that I've beat myself up long enough trying to figure out how to break a line in the middle of a quote statement so as not to distort the Lounge. Search result is that I don't know what to search for ("break", "code break", "next line in code", "don't be stupid")
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: blnEditMail (2002 SP-2)

    You've got one comma too many in the DoCmd.SendObject instruction, so that blnEditMail hase ended up in the position of the TemplateFile argument. Remove one comma before blnEditMail:

    DoCmd.SendObject acSendReport, strReportName, _
    acFormatSNP, strRecipient, , , strSubject, , blnEditMail

    Posting medium to long fragments of code in an attachment is a good idea anyway; it makes the thread load faster, and only Loungers interested in the code need to open the attachment.

    When you post code between <!t>[pre]<!/t> and <!t>[/pre]<!/t> tags, you must take care of breaking long lines yourself, manually. There is no special tag for breaking lines. Without the <!t>[pre]<!/t>, the browser takes care of line wrapping.

  3. #3
    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: blnEditMail (2002 SP-2)

    Hans:

    Thanks! That did the trick (along with Express Click Yes). The second part of my question was so poorly put that it hardly bears correction but, I really need to pursue it (some of my/your/our code is really difficult to read in VBE). I want to be able to wrap the very long strings in VBE so they're more easily viewed. Where can I read about the various methods (presuming there's more than one)? I'm not searching the VB help files for the correct term I guess because I'm not coming up with any results.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: blnEditMail (2002 SP-2)

    I'm confused. In your first post, you wrote about "how to break a line in the middle of a quote statement so as not to distort the Lounge", so I thought your question was about posting code. If you mean "how to break a string in the Visual Basic Editor", it is much simpler:
    - Click where you want to break a line.
    - Insert quotes, a space, ampersand, another space and an underscore, then press Enter.
    - If you like, indent the next line a bit more.
    - Insert quotes before the rest of the text.

    Example:

    <code>Dim strText As String</code>
    <code>strText = "This is a rather long piece of text. It is too long to fit on " & _</code>
    <code> "one line, so I have used the line continuation character to " & _</code>
    <code> "break it up into several lines in the editor."</code>

  5. #5
    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: blnEditMail (2002 SP-2)

    Like I said: "...poorly put..." (why is my hand stinging?) <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    I actually tried that method on several occasions and it didn't work. Oh, you mean "spaces" are as important as characters? Well now, that changes everything! Thanks Hans, I'm off to see what code I can destroy. (Don't be surprised to see me on the VBA board).
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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