Recent content by fralippolippi

Worked like a charm. It was those quotation marks....Thank you so much!

Hello, I am trying to create a 'start page' form - from which you will launch into other forms as needed. In this case, you will either create a new Purchase Request (PR), Edit or View an existing PR, or Approve a PR. While for the Edit/View an existing PR I have this code working...

So, the weird part is as long as I have some sort of manually entered text prior to the Form data - it works like a charm. The good news is that "" works just fine. So, in the end this is what will work: MailDoc.Subject = "" & [Forms]![PRSubmits]![JustificationTextBox] Maybe somebody will...

This seems to be working: MailDoc.Subject = "TEXT" & " " & [Forms]![PRSubmits]![JustificationTextBox]

I've updated the db. So, I tried again - rebooted my desktop and such - even made a new record. I can get the email...it just shows up with out any subject?!? So, the script doesn't error - it just doesn't grab the text. I'm sure I'm doing something rather silly - and so I apologize upfront...

I'll check that out when I return to the office. I'm in Baltimore, USA. There is data in the fields, I tried multiple text boxes, even labels. I don't know....maybe a reboot or a new record would help. :) Thanks for the quick replies

I guess I kind of buried that I have tried that. It is in the code, I have the comment there, that I've done that. What happens is the email is sent, no error, but the subject line is blank. I've even tried "text" & Me.Textboxname & "text" And the "text" parts show up but the content of the...

So, I'm very new to Access and not all that skilled in VBA. I have, through trolling the internet found some code that does allow me to send an email on the click of a button on a form through Lotus Notes. However, I cannot get any of the data on the form to show up in the email. How do I...