CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: Chad Jackson

Search: Search took 0.02 seconds.

  1. Re: Run Time Error '3021' : No Current Record

    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...
  2. [RESOLVED] Run Time Error '3021' : No Current Record

    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....
  3. Re: Attaching Sub Form to SMTP Message

    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...
  4. Re: Attaching Sub Form to SMTP Message

    Tried that, and I'm still getting the same error code, only it says "can't find the field 'l'..."
  5. Re: Attaching Sub Form to SMTP Message

    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...
  6. [RESOLVED] Attaching Sub Form to SMTP Message

    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...
  7. Re: Outlook 2003 Automatic E-Mail

    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...
  8. Re: Outlook 2003 Automatic E-Mail

    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...
  9. [RESOLVED] Outlook 2003 Automatic E-Mail

    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...
  10. Replies
    6
    Views
    17,336

    Re: Run-time Error 2498

    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...
  11. Replies
    6
    Views
    17,336

    Re: Run-time Error 2498

    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...
  12. Replies
    6
    Views
    17,336

    Re: Run-time Error 2498

    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.
  13. Replies
    6
    Views
    17,336

    Re: Run-time Error 2498

    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...
  14. Replies
    6
    Views
    17,336

    [RESOLVED] Run-time Error 2498

    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,...
  15. [RESOLVED] Access 2003 Visual Basic Run Time Error '424'

    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...
Results 1 to 15 of 16





Click Here to Expand Forum to Full Width

Featured