+ Reply to Thread
Results 1 to 1 of 1

Duplication of data

  1. #1
    Registered User
    Join Date
    12-31-2013
    Location
    Madrid, Spain
    MS-Off Ver
    Excel 2003
    Posts
    21

    Duplication of data

    Good afternoon ,
    As you will see , among others, use two UserForm : one for data entry ( UserForm1 ) and , the other , ( UserForm2 ) to modify . The problem arises me in changing records (using UserForm2 ) because when the registry change is duplicated , but with different dates (say one dated 2013 and one from 2014) , all records are duplicated . However, if the record is unique modified without problem.
    example:
    In the sheet "INICIO " execute "Modificación de Informes" in the form that opens , run "Modificación de Datos", and in the ComboBox "Número de Registro" , deploy and chose the "4" . One, dated , 10/01/2013 , and immediately in the ListBox , the records associated with this issue , in this case two listed, and another , dated , 01/02/2014 , both, with their corresponding records.
    Select the record date 01/02/2014 , then the various fields of this record in the corresponding TextBox and combos in order to be able to modify any of them are loaded.
    Choose, for example, change the "Tipo de Documento" field, change the Documento 5 for everyone else, we deploy the ComboBox and select, for example, Documento 8 (we could modify any other field) and run "Modificación de Datos". Theoretically , the record ID . 4, dated 01/02/2014 , it should only be modified by Documento 5 Documento 8 , the rest of the fields as they were. Well here comes the problem , rather than this particular data have changed , What you have done is this:
    We headed to the "DATOS" sheet , and we check that all fields have disappeared for the Registration No. "4" , dated 10/01/2013 , and the Registration Number "4" , corresponding to 01/02/2014, has doubled , one 5 and the other documento with Documento 8 .
    However, if we choose a no. registration is not duplicated , modified normally. Incomprehensible , at least to me .
    Whichever way I have given the code in this form , I can not find the solution to this problem. Grateful , honestly, any contribution that contribute to its resolution .
    Thank you .
    As the file is heavy and I can not get on the forum, I leave this link for download :
    https://www.dropbox.com/s/vhhbyicluw...rmesPrueba.xls
    Note InformesPrueba.xls to open the file :
    USUARIO : Usuario 1
    CONTRASEÑA : Clave 1
    To open Visual Basic editor
    Password: 123
    Last edited by Aretradeser; 03-26-2014 at 04:45 PM.

+ 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] Check existing data before copying in new data to avoid duplication
    By lordterrin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-06-2013, 02:15 PM
  2. Duplication data every time macro is run, instead of updating newly found data only
    By Lostinxcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2010, 03:41 AM
  3. Excel 2007 : Data duplication
    By baloch in forum Excel General
    Replies: 2
    Last Post: 03-05-2009, 12:33 AM
  4. Combining Data without Duplication?
    By Waynesworld in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-12-2006, 05:49 PM
  5. data duplication check ?
    By Anthony in forum Excel General
    Replies: 4
    Last Post: 07-01-2005, 05: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