Search results

  1. Y

    "Return Without GoSub" Error

    Hello all, I would really appreciate it if someone could help me out with this nagging problem! (Access 2007-2010) I created a form with a SendObject VBA code so I can simply click a cmd button to e-mail out a report. This process works fine normally, but occasionally and randomly, when I...
  2. Y

    E-mail Current Record on Form

    Ok i'll try using IsLoaded Can you help me figure out the e-maildatabase object problem?
  3. Y

    E-mail Current Record on Form

    Paul, Ok, so the email address is on the same form as the ID. But something is wrong with the macro action "EmailDatabaseObject". It does not populate any of the message details, i.e. To, Subject, Message Text, even if I type something in. It doesn't make sense. Either way, I have no clue...
  4. Y

    E-mail Current Record on Form

    Yes, thanks again. I do have a few last questions if you can answer them. 1. My report works well with my form, and it will e-mail out one record at a time. How can I automate the e-mail with a specific e-mail address depending on the record's ID? I know I can put an e-mail address in...
  5. Y

    E-mail Current Record on Form

    Paul, You are awesome. It all works!! I just didn't understand at first, but now I do. You have to use a form and a report. Genius. Thank you for your help. Much appreciated.
  6. Y

    E-mail Current Record on Form/Command Button Wizard Not Working

    Hello, Ok, so it's still hard to believe that I can't get this process to work. I'm so frustrated. Someone please help! You would be a saint... So, I've created a report which I want to put command buttons on. I want one to e-mail out the current record, and to be able to do this for each...
  7. Y

    E-mail Current Record on Form

    This code is not working: Private Sub Report_Open(Cancel As Integer) Me.Filter = "ID='" & Reports![PantryTierReports]![ID] & "'" Me.FilterOn = True End Sub
  8. Y

    E-mail Current Record on Form

    The magic wand button is pressed down for "Use Control Wizards" The Wizard works for other controls, just not for buttons... what is going on?
  9. Y

    E-mail Current Record on Form

    On a report, how does it know which record has focus? Also, i'm not sure why, but for my report, the command button wizard does not open when I put a button on the report in design view... any idea why?
  10. Y

    E-mail Current Record on Form

    So after changing it to a report, the e-mail macro only attaches the first record, not the specific record I am on.
  11. Y

    E-mail Current Record on Form

    Is there any way to just copy my layout and structure to a blank report? I would hate to have to do all my design work from scratch again....
  12. Y

    E-mail Current Record on Form

    I am emailing a form. I see, so I'll have to change to a report then?
  13. Y

    E-mail Current Record on Form

    Ok I edited the code as you wrote it, and it worked!! One big problem however... Since the VBA is set to On Open event, the form is automatically filtered to the one record when in form view. The macro will work fine and attach the one record to an e-mail because of the filter. But I have to...
  14. Y

    E-mail Current Record on Form

    Private Sub Form_Open(Cancel As Integer) Me.Filter = "ID=" & Forms![PantryTierForm]![ID] Me.FilterOn = True End Sub
  15. Y

    E-mail Current Record on Form

    It says: Syntax error (missing operator) in query expression 'ID=001037P'. 001037P is the ID value of the first record my query recordset
  16. Y

    E-mail Current Record on Form

    I am sorting by ID, and I have named the control on my form as "ID" When I replace "ShipmentsID" and "LoadID" with "ID", it says i have a syntax error
  17. Y

    E-mail Current Record on Form

    Aha, well can you tell me what "ShipmentsID" is naming? And "LoadID"? I use a field named "ID" for the primary key
  18. Y

    E-mail Current Record on Form

    Ok I now understand that part, but if I need to use both a macro and VBA code like you say, how should I set up the command button clicks? I cut and pasted the code, but with my lack of familiarity, I can't exactly tell what names I will have to change. Seems "txtProgress" and "lblStatus"...
  19. Y

    E-mail Current Record on Form

    Ok I'll try it out. How do I put the VBA code into a command button on the form?
  20. Y

    E-mail Current Record on Form

    I can't figure out the SetProperty macro. Ugh this is impossible.
Back
Top Bottom