Search results

Don't know where the <be> slipped in because I had it as <br> in my code. I run it again, just to make sure, and it's not adding the image.

I don't need to use default signature cards. I have a jpg file that I want to insert at the end of my email body as per your first example. This is what I've done but it does not include the jpg and no error messages. .htmlbody = strBody & "<br><br><IMG...

I've added my signature section at the end of the HTML file, which includes a picture. If I create a jpg file which includes both the text part of the signature and the picture, is it possible to add the jpg file to the body, for example .htmlbody = strBody & picture.jpg

Thanks June7, I figured it out and it's working. One more question.... I have a jpg file which is part of my signature. How would I incorporate that into my code? Private Sub CmdEmailNewBuyer_Click() Dim chkGuaranteeSent As String Dim OutMail As Outlook.MailItem Dim OutApp As New...

Thank you for helping me out again. I do want to take this further by adding a HTML file as the body. I got code from https://thedbguy.blogspot.com/2016/05/how-to-read-text-file.html but just want to check if I got it right. The code in blue are the bits I've added but there's something not...

Thank you, that worked 😊

Hi everyone I'm sending emails to customers selected from a listbox (Arnelgp was so kind to help me with this one 😉) I have two reports to create for each customer to be attached to the individual email. Each set of reports has data specific to each customer. I've added the report creating lines...

Sorry, I don't quite understand what you mean. Do you have an example of what you suggest?

Thank you so much for the help and advice, everyone. As always on this forum, I learned something valuable today!

My limited knowledge might cause confusion. Let me explain. I have a form with command buttons that serves as a menu. Some of the command buttons open a form with data selected through a query for a specific date, for example, the date of birth for a specific litter. It does happen sometimes...

The form is bound to a query and it prompts for a date. When the user chooses to cancel I want to eliminate the error message. If a date is typed in it works fine.

I've tried the following but it still gives the error. Private Sub CmdPuppySearch_Click() DoCmd.OpenForm "frmPuppySearch" If InputBox("Ask for user input") <> "" Then Exit Sub End If End Sub

I want to eliminate the 'OpenForm action was cancelled' Run-time error when the user press cancel on an InputBox. I found a thread, https://www.access-programmers.co.uk/forums/threads/help-with-cancel-on-inputbox.298736/#post-1569434, where one of the moderators referred the OP to the following...

When I read your message I knew exactly what the problem is. Thanks for pointing it out. It's working 🤗 Thank you so much, Arnel 😊

I saw that and I fixed it. There was another one as well, Next Dog should've been Next Puppy. So those are not the problem.

Hi Arnel, I've copied your code which creates a record but does not update the MCTrfLodged field, which is a date.

I need some help again, please. I want to insert a record into tblDogCheckList . If a record for the DogID does not exist do an Insert. If a record with the same DogID already exists then do an Update only. MCTrfLodged is a date field. When I run it and I check the table, nothing happened. I...

I'm not very familiar yet with VBA but I see now what the problem is. I changed it and is working now. Thank you so much, I do appreciate your help. DoCmd.RunSQL "INSERT INTO tblDocument (DogID, Filename, FilePath) " & _ "VALUES (" & DogID & ", """ & Filename & """,""" &...

Hey Guys, I have another issue. I'm trying to save the filepath to the table and I'm getting the error below. I thought it would be the same as for saving the filename. I don't understand why the field has to be mentioned twice, eg """ & Filename & """,""" & Filename & """ Thank you in...

His training is excellent and I learnt a lot from him. I would highly recommend him to anyone. Unfortunately, he doesn't give the support as you guys do.