Recent content by wnicole

  1. W

    Combo box set focus

    I have a combo box (drop down list) of projects on top of my form. I also have the "prev record" and "next record" buttons as well. However, when I move to next or prev record the combo doesn't change and is confusing to some. Is that any way I can make sure the Combo box is set to whatever...
  2. W

    Tab Control

    I have a tab control form with about 5 tabs. However when I move to the tab that has a datasheet form, the page moves down. You have to scroll up to see the above tabs. Is there something I'm missing on this simple tasks? Is it better to have it as a basic form for easier interface. Its so...
  3. W

    Question You do not have exclusive access to the database at this time

    When you say you copy and paste to another location and it went away. Are you speaking of the actual database? I'm experiencing this problem as well
  4. W

    emaildatabaseojbect to [Email] to send multiple

    See pic below. I haven't been able to find right vba and wondering if I can use this macro set the Email field to link to my query Q_InspectorDailyDispatch. I need the macro to send to each individual person its jobs. (I prefer not to use VBA just too hard for me and I'm only frustrating more...
  5. W

    Sending Email with multiple recipients

    Ok I did it at the bottom it says False False False then the email addresses. Questions 1. It appears the employees without email addresses may be trigerring it. Is there a Is Null statement you can send me. I dont know how to create one in VBA. 2. I notice the email addresses was everybody...
  6. W

    Sending multiple email code not working

    I have this code below its giving me the RUntime 2295 error. Unknown message recipients. I have check all email addresses and they are fine. Everything else works except when it gets to Outlook and do not send email. Can you take a look let me know what you think? I did a Debug Print but...
  7. W

    Sending Email with multiple recipients

    I dont understand. All my email addresses are correct. Not sure why it will send that code. I put the Debug.Print there but nothing appeared at bottom. Is there something to hit to run it?
  8. W

    Sending Email with multiple recipients

    I have a question. This seem to be working great for me...however right before it goes to Outlook it says "run time 2295 unknown message recipients" and does not send. When I hover over the email section of code, the email addresses are correct. Any suggestions?
  9. W

    calculate the driving distance between 2 zip codes

    Hi, I just have one question. Instead of entering the postal code continually. How do I set zipcode 1 and zipcode 2 based on to fields in a form. I would like to use the current FROM (Default zip based on the current job in form) and TO zipcode [Project Postal Code] that is on the form at...
Top Bottom