Results 1 to 3 of 3

Thread: How To Prevent Adding Duplicated Record In A Table Using VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-08-2013, 10:58 AM #1
    adfo
    adfo is offline
    Junior Member
    Join Date
    Apr 2013
    Posts
    4
    Rep Power
    0

    How To Prevent Adding Duplicated Record In A Table Using VBA

    I need to prevent adding duplicated record in a table .. I attach sample file
    I input date on the left.. when I click a button, the range of records are copied and added to the table .. I need to check if the record has been added before adding it .. The duplicated record is a combination of name and date .. the same account should not be entered twice in the same day .. I appreciate your help .. thanks
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Export data from Excel to Access Table (ADO) using VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 02-24-2015, 07:53 PM
  2. Excluding Records of one Table from the Other Table
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  3. Copy Table Range Till Last Row Using VBA
    By ivandgreat in forum Excel Help
    Replies: 2
    Last Post: 05-09-2013, 05:41 PM
  4. Vlookup Multiple Values By Adding Formula With Loop In VBA
    By Safal Shrestha in forum Excel Help
    Replies: 15
    Last Post: 04-22-2013, 04:49 PM
  5. Adding Scroll bar to image box in vba
    By princ_wns in forum Excel Help
    Replies: 1
    Last Post: 12-13-2011, 09:47 PM

Tags for this Thread

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
  •  

Forum Rules