Results 1 to 2 of 2
  1. #1
    Phil Knapton is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2010
    Posts
    19

    Collecting data off a form and adding to 2 tables

    I have linked outlook conatcts to my db. I have a form that shows selected field from contacts (i.e. Business Details and contact details) which I want to add to :-
    Business details to a table call tblClient
    Contact Details to a table called tblCLientContact
    The field names slightly differ between the Outlook link and my tables
    I was looking for 2 buttons. 1 to add the client, 1 to add the contact.
    Can anyone help?

    For Information
    Outlook
    First, Last, Job Title, Phone, Mobile Phone, Email Address


    To
    tblClientContact
    ClientContactID (Primary)
    CC First Name
    CC Last Name
    CC Position
    CC Tel
    CC Mobile
    CC email

    And
    Outlook
    Company, Business Address Street, Business Address City, Business Address Postal Code, Business Fax, Web Page
    To
    tblClient
    ClientID (primary)
    Client Name
    Client Address
    Client Town
    Client Postcode
    Client fax
    Client Website

    I have had a look at the AddFromOutlook command but my db is split and I can find anywhere to specifiy vb code that actually maps the fields.

  2. #2
    Phil Knapton is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2010
    Posts
    19
    I have worked it out.
    Local "Contacts" Table (through wizard)
    Load contact into a form then use code to move it to the table I wanted it in, then delete item out of contacts table on completion.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adding data to tables using queries
    By HunterEngineeringCoop in forum Queries
    Replies: 3
    Last Post: 10-28-2010, 12:42 PM
  2. Adding data to tables
    By HunterEngineeringCoop in forum Access
    Replies: 3
    Last Post: 10-19-2010, 12:01 PM
  3. Automatically Adding New Data to Tables
    By aquarius in forum Import/Export Data
    Replies: 1
    Last Post: 09-15-2010, 07:27 PM
  4. Replies: 2
    Last Post: 04-04-2010, 06:14 PM
  5. Replies: 9
    Last Post: 03-24-2009, 09:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums