1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2012
    Rep Power

    Search function + Merge w/ Outlook


    I am trying to create a database which will store "Call logs" for a clinical trial. This will include name, phone number, date subject called, return attempt #1, return attempt #2, return attempt #3, and result. I was able to create this table and a form in Access 2007.

    I am very new to database creation, and I am looking for some assistance with the following items:

    1. I need to create a search function by phone number, so that the technician can look up if the person had already called in and to avoid entering the same person multiple times. I can successfully develop queries for the phone number category, but what I would like to do is search for a phone number and if it is already entered, the form with the information would pop up automatically. If it was not entered, it would just go to a new form for entry.

    2. I would like this to sync with an Outlook calendar. For example, if a subject needs to be called in 1 month, this data entry could appear on the specified date and time in an outlook calendar.

    I have made many attempts on both of these. The first item is really the only one that is completely necessary, but the other would make things much more convenient.

    Any help on any of these issues would be great. Thank you for your time.

  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Feb 2008
    Lake County, IL
    Rep Power
    For item nr 1, you might consider looking at the video below as an option

    Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

    Just use the phone field as your search criteria.
    Alan Sidman
    Office 2010, 2007, 2002

    If I helped you, then click "give rep" button in the lower left corner.
  4. #3
  5. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    The Great Land
    Rep Power
    Doubt Item 2 will be easy. You want the appointment saved to a calendar that is available for all staff to view? Not sure how easy it is to share Outlook calendar nor how easy/hard it is to manage a shared calendar through Access.

    Is this a multi-user split database? Each user runs their own copy of frontend?

    Review http://www.officecalendar.com/produc...dar_share.aspx
    Last edited by June7; December 12th, 2012 at 05:24 PM.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
  6. #4
  7. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    South Jersey
    Rep Power
    If you are trying to manage a shared calander for all employees, outlook has no built in ability to do this. You have two basic options. 1. Use an exchange server if you already have one in place. 2. Get third party software. We use CodeTwo and it works fairly well. You'd only have to get access to update one calander then all of the others would show the changes as well. Do a search on google for "Access update outlook calander" should give you a bunch of hits with specific code on how to add or delete items on an outlook calander. (Don't bother trying to modify items on a calander, it's not an easy feat.)

Similar Threads

  1. Search function and update function
    By beanbeanbean in forum Microsoft Access Help
    Replies: 1
    Last Post: November 4th, 2008, 01:57 PM
  2. Search function?
    By JustXtreme in forum ASP Development
    Replies: 2
    Last Post: February 14th, 2007, 05:32 AM
  3. I would like to add a search function.........
    By deadfish in forum Microsoft Access Help
    Replies: 1
    Last Post: September 7th, 2004, 07:27 AM
  4. automating outlook function
    By sentme_mail in forum HTML, JavaScript And CSS Help
    Replies: 0
    Last Post: October 25th, 2003, 11:35 PM
  5. how to do a search function?
    By Steve Schofield in forum ASP Development
    Replies: 1
    Last Post: October 24th, 2001, 10:52 AM

IMN logo majestic logo threadwatch logo seochat tools logo