Search results

Hi Mary, Welcome to AWF. Wayne

Just my terminology that was confusing. Sorry. But with your help, I got it to work. Wayne

I am not sure about SQL Server, but I do store them in access. I store them in a field on a subform, as a hyperlink, using the full path and file name (i.e. "C:\...\Documents\Filename.pdf"). The user simply clicks on the hyperlink and the file will open in it's native app (Adobe Reader, or...

June 7: What I meant by single quotes outside the <a></a> was that in VBA, the HTML code must be surrounded by double quotes like "<a href>"blah, blah, blah"</a>", but it doesn't seem to accept '<a href>"blah, blah, blah"</a>'. As soon as I use the single quotes outside the HTML code markers...

We the north!!!!!

Hi Guys, Thanks for your help. I got it to work with this code: "<a href=""https://www.google.ca/maps/place/+" & Me.ClientStreetAddress & "+" & Me.ClientCityName & "+" & Me.ClientState & """" & ">View on Map</a>" June - it works with either double or single quotes, just not the quotes outside...

I have created a command button to email each technician the details of their jobs for the next day. It gives the scheduled time, client's name, address, and contact numbers, and the scope of work required, all in the body of the email. Everything is working perfectly, and as they say, if it...

Welcome to AWF! Wayne

And the music in New Orleans.......amazing. Wayne

At least you guys have won a Stanley Cup within recent memory. Can't say that for my Leafs! Wayne

Hi Melody. Welcome back. Where in Canada? Wayne

Hey Gasman, Could you please show me an example of your split signature template? In my database, I have seven different emails to send out, and a template would work better than individual coding. Wayne

Actually, I should have thought to ask him that. Thanks Micron. Wayne

In Design View, in the Properties sheet, simply put in the number of inches (or cm if you've selected metric measurements), and Tab to the next property. It should save it to that width. Auto Resize should have a default setting of "Yes", and should not affect it. What is the Picture Size Mode...

Where are you trying to change the width parameter? And what are you trying to change it to? Wayne

When you are writing the email in HTML, vbCrLf doesn't work. You have to use "<br><br>" to skip two lines. In any event, I got the code to work. The problem was the signature part. When I put a literal file path and file name, it works. When I used this code: Set Signature =...

This part of the code seems to be the problem. It says I have a syntax error on the first line. Do While Not EOF(#intFile) Input #intFile, strLine strBodyText = strBodyText & strLine & "<br><br>" Loop If I take out the hashtag on the first line, the code...

Okay, I tried what you said, and now I get an error message "Syntax Error" on this line (Highlighted below): Private Sub btnEMailTechnician_Click() On Error GoTo Err_btnEMailTechnician_Click 'Define some object variables for Outlook Dim olApp As Outlook.Application...

It seems to run okay to the highlighted point. Private Sub btnEMailTechnician_Click() On Error GoTo Err_btnEMailTechnician_Click 'Define some object variables for Outlook Dim olApp As Outlook.Application 'The NameSpace object allows you to reference folders Dim...

That's the weird part. It is not telling me. Usually, it will highlight the code that is not working, or that is the problem, but not this time. Wayne