Re: passing element within form to function. - 1 attachment

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 09/30/04


Date: Thu, 30 Sep 2004 17:28:57 -0400

There was no need to attach the picture: it didn't help.

What's the name of the text box that's storing that text string? You refer
to its content as Me.nameoftextbo

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Steve" <steveb@vanner.com> wrote in message
news:Xns95748A2703505sblake7777hotmailcom@65.24.7.50...
> I am presently trying to pass data, in a form, to a function
> "SendEmailMessage"  I've been able to get the main e-mail generation to
work
> fine but now I need to attach a file to each email I generate.  As you can
> see <in the picture>, when I press the [Send Email Message], I would like
to
> link the {Hyperlink to PCN Document}.  Once I can send that link to my
> "SendEmailMessage" macro, which in turn call the Function "SendEmail()"
> (withing the module SendTheMessage)I'm set up to attach it to the
generated
> email.
>
> Bottom line <See Picture>, I would like to pass the text string "C:\My
> Documents\customers.txt" to the function SendEmail().
>
> Thank you in advance
>
> Steve
>
>


Relevant Pages

  • Re: Pass a string to a macro -> Function... - 1 attachment
    ... "Steve" wrote in message ... > I am presently trying to pass data, in a form, to a function> "SendEmailMessage" I've been able to get the main e-mail generation to work> fine but now I need to attach a file to each email I generate. ... As you can> see <in the picture>, when I press the, I would like to> link the. ...
    (microsoft.public.access.formscoding)
  • RE: Adding Bound Pictures to an Access Database
    ... when the student's picture is missing it is leaving the ... Private Sub Form_Current ... Dim strPath As String ... Private Function pfValidFile(aFile As String) As Boolean ...
    (microsoft.public.access.modulesdaovba)
  • Re: Attachments problems with Redemption
    ... as a file and then attach that file to the item and then delete the temp ... Public Sub cmdEmailwithData(HTMLfile As String, ... Dim msgBase As String ... Dim msg As String ...
    (microsoft.public.office.developer.outlook.vba)
  • Re: English Ivy, training to grow on Smooth Vinyl Fence
    ... One, attaching string to the ground might be easy enough, but I can't ... damaging the fence or nearby bushes and trees...I don't want to attach ... fence--it would be one more thing to contend with, the ivy will end up ...
    (rec.gardens)
  • RE: Adding Bound Pictures to an Access Database
    ... Just add an Else to the If statement that checks for a picture: ... Me.ctlPersonPicture.Picture = strPath ... Private Sub Form_Current ... The Lenfunction returns the number of characters in a string. ...
    (microsoft.public.access.modulesdaovba)