Recent content by Gregory Long

OK. After several iterations I have finally got code that actually works as intended. I would like to thank everyone for their help because I would not have been able to solve this without them. Below is the final version of the code. Private Sub SendEmailWithAttach_Click() ' check to make...

The ID field is an autonumber field and it is the primary key. The CSE_Assigned field is where the users name is stored in the Lastname, Firstname format.

Oh, I'm so close. I'm getting a run-time error 3075: Syntax error (comma) in query expression '[ID] = Long, Gregory'. from the following line of code. I think this is caused from where the field CSE_Assigned contains record date in the format Lastname, Firstname Note that I changed the reference...

I was able to download only the attachments for a specific record instead of all the records. I used this code. I think once I add all this together that it just might work. Thanks for all the help. Public Function GLL(strPath As String, Optional strPattern As String = "*.*") As Long...

Hi Vlad, Here is the code that I have to send emails. It sends the email when a task is given an assigned date. I had to remove the actual email addresses for security reasons. The emails come from a multi-column combo box along with the users name. I was able to successfully attach an...

OK. So using the examples that Bastanu and theDBguy provided I created a parent and a child recordset. The parent recordset is for the table RCSE and the child recordset is for the MVF column that is named attachments. I am so close to getting this to work but I keep having trouble going back to...

Reside in Tennessee but currently working in Ohio.

Hi Everyone. I am in need of help from someone that is way smarter than me. I created a simple database to keep track of personnel and their assigned tasks. I have an attachment MVF field in this database. I know they aren't recommended but it keeps everything in one place. Most of the...

Hi, My name is Gregory Long and I am a new member. I have been using access for many years but I am still learning when it comes to VBA. I currently live in the USA.