Recent content by omccartney

  1. O

    Access 2003 email format

    It's been a while, but I belileve you create an HTML Template and point to the file path.
  2. O

    Access 2003 email format

    You'll have to use the last option (which you have not defined, it would be after the "True") to set up and define a template file. This would be the html template for the email. If you double-click on the word "SendObject" and hit the [F1] key while in development mode, you should see the...
  3. O

    Access 2003 email format

    What object are you using to connect to outlook? What does the current code you are using look like?
  4. O

    VBA And Error Routines

    Thanks for your help. I ran a test on another PC here at my office and it works on that PC as it did for you. Must be something specific to that PC. Always make sure the monitor is plugged in first! :o
  5. O

    VBA And Error Routines

    Yes. I get the error number and the error description.
  6. O

    VBA And Error Routines

    I have even tried building a 2007 accdb from scratch and re-typing the code and still have the same problem. :confused:
  7. O

    VBA And Error Routines

    It is the first time. You do not need a resume if the routine terminates after the error.
  8. O

    VBA And Error Routines

    When I have it set to "Break on All Errors" I get the dialog box with the End/Debug/Help answer buttons. If I have it set to "Break in Class Module" or "Break on Unhandled Errors" I get the dialog box with only the "OK" answer button.
  9. O

    Query and SQL?

    If I understand correctly, to normalize this, put a sequential key on the Individual table and make the group table only access the individual keys. Then remove the key from the group and the record from the individial. table A group 1 - key 1 group 1 - key 2 group 2 - key 3 table B key 1-...
  10. O

    VBA And Error Routines

    Break on all errors
  11. O

    VBA And Error Routines

    Chris0 - I am having the same problem with every routine that has an on error. Not all of my routines have an on error. BobLarson - That would lead me to believe perhaps I have some option turned on/off in 2007. :p Any ideas?
  12. O

    How to update sequential number?

    Your sequential number is what data type?
  13. O

    Combo Box After update

    Why is the text field unbound? Is this data recorded in a seperate table? What does the code look like that you are using to do this?
  14. O

    VBA And Error Routines

    I have some code that worked in 2000 but does not work in 2003/2007. It is the On Error Statement. When I run the code, it seems to ignore my On Error Statement and opens a VB Dialogue box that shows my error "Microsoft Office Assistant can't find the object 'SynnexMultiContact5'. I know why...
See more
Back
Top Bottom