Type: Posts; User: Chad Jackson
Search took 0.01 seconds.
January 7th, 2013, 12:05 PM
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:
' If both...
January 7th, 2013, 11:23 AM
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....
January 3rd, 2013, 09:54 AM
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...
January 2nd, 2013, 02:45 PM
Tried that, and I'm still getting the same error code, only it says "can't find the field 'l'..."
January 2nd, 2013, 11:57 AM
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...
December 31st, 2012, 10:30 AM
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...
December 14th, 2012, 10:06 AM
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")
If .EOF And .BOF Then...
December 13th, 2012, 03:33 PM
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...
December 13th, 2012, 11:01 AM
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...
September 28th, 2012, 04:03 PM
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...
September 28th, 2012, 03:56 PM
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...
September 28th, 2012, 02:52 PM
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.
September 21st, 2012, 03:36 PM
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...
September 21st, 2012, 03:33 PM
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,...
August 16th, 2012, 05:19 PM
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...
Click Here to Expand Forum to Full Width