+ Reply to Thread
Results 1 to 4 of 4

Wanted to know if data already exists in Table

  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    20

    Wanted to know if data already exists in Table

    Hello, i am working on a project where the end user enters data to following columns...

    VendorName VendorNumber Country



    Now i wanted to find a way to alert the user if the vendor name he is entering is already existing in the access database.

  2. #2
    Registered User
    Join Date
    08-24-2014
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Wanted to know if data already exists in Table

    this is Excel Forum...

    where does the end user enter data in Excel or in Access ?
    ☚ Don't forget to rate person who helped u Click ★

  3. #3
    Registered User
    Join Date
    08-28-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Wanted to know if data already exists in Table

    User enters data in a VBA form... this inturn saves the data to an access database..

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Wanted to know if data already exists in Table

    In the table properties for the field, select the Indexed property and change it to "Yes, No duplicates." An error message will popup if the user tries to enter an existing Vendor Name. Be aware it will not kick out this type of example. ABC Co. if ABC Company is already in the table. It must be an exact duplicate.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Stat table with formulas for each data element but only when the element exists in table
    By stevemills04 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2013, 05:50 AM
  2. [SOLVED] Macro Wanted VBA Table to List with more than 3 columns
    By carpediem_3112 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-18-2013, 12:50 PM
  3. [SOLVED] Stop overwrite of file if it already exists, no popup wanted
    By LoneWolf3574 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2012, 07:24 AM
  4. [SOLVED] Finding MAX Date in table where data exists
    By heatherromo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2011, 12:41 PM
  5. No Pivot Table Totals Wanted
    By robertjtucker in forum Excel General
    Replies: 1
    Last Post: 08-02-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1