Search:

I fixed my own problem, and made the code much simpler in the process. Double win!

For anyone experiencing a similar problem, here is my solution:

With r
Do
' If both...

I'm getting the infamous Run Time Error '3021', and am having no luck resolving the issue. I have browsed countless forums and tried many different solutions, but none of them have worked for me....

I figured out a solution. When the user clicks the button to send the e-mail, the subform is automatically exported and later attached to the e-mail message in the "With msg" loop. It works like a...

Tried that, and I'm still getting the same error code, only it says "can't find the field 'l'..."

Ok, so I've done that, but now it's telling me that it can't find the form. I've checked the name many times, and copy and pasted the name of the form and subform into my vba code, so I am SURE there...

I'm having a problem attaching a subform to an e-mail message. Before, I was sending the e-mail through outlook using DoCmd, but recently re-wrote the code to send through an SMTP server in order to...

Private Sub btnSendEmail_Click()
Dim rs As DAO.Recordset
Dim stDocName As String
Dim StrAttach As String
Set rs = CurrentDb.OpenRecordset("5-Day E-Mail Addresses")
With rs
If .EOF And .BOF Then...

Thanks for the reply!
So here's what I'm going to try..
In the table containing the e-mail addresses, I'll assign a "type" to the names in the table (5-Day addresses will be type 3, 10-Dayers will...

Hello all,

I have a working module that will send an e-mail through Access via Outlook, so this post isn't another one seeking code to get something like that working.
What I'm wondering, is if...

Figured it out.
My table had an extra line item at the end with no data in it. VB was finding this "record" despite there being no data, and didn't know what to do with it, so it would throw that...

But wait! It gets weirder...
I have another program that is almost identical to this, only it sends an email out for tickets that have been out for 10 days instead of 5. The code for the 10 day...

It sends the email to all the people in the table just fine.
The issue I'm having is the annoying error message that pops up regardless of the fact that the program runs just fine.

Sorry, forgot to specify in the code which line is causing problems.
It is the line that starts with, "DoCmd.SendObject acSendForm,..."
It comes directly after the comment " The next line sends the...

I am working on some code that will send an e-mail through Outlook 2003 "On Click" of a button inside of a form in my 2003 Access db. The code was in a different database, and was working just fine,...

I am experiencing the infamous Run Time Error '424' like many others have. I have surfed several forums, to no avail, and am now turning to you guys for some help!

This application was created in...