Posts by 990405

    Could anyone assit in how to remove duplicates?


    exact duplicates or "near" duplicates do appear at times for example:


    If you like I could send you the excel file to give you a better understanding.


    But essentially, the company can operate in different product sectors or can be located in different provincial locations:



    AlmasPelliSasDiMassaroAlessandroC
    AlmasPelliSasDiMassaroAlessandroEC
    AlmasPelliSasDiMassaroAlessandroEC
    AlmasPelliSasDiMassaroAlessandroEC


    ApisSRL
    ApisSrl
    ApisSrl
    ApisSrl
    ApisSrl



    AIPASpaAgenziaItalianaPerPubblicheAmministrazioni
    AIPASpaAgenziaItalianaPerPubblicheAmministrazioni
    AIPASpaAgenziaItalianaPerPubblicheAmministrazioni


    AFiorDiPelle
    AFiorDiPelle
    AFiorDiPelleDiReginatoSonia
    AFiorDiPelleDiReginatoSonia


    3PRappresentanzaCommercioEsteroSRL
    3PRappresentanzaCommercioEsteroSRL
    3PRappresentanzeCommercioEsteroSrl


    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPierachilleECSAS
    ConfartDiTosanaPierachilleECSAS


    thanking you in advance

    I am still a bit of a novice with Access.


    Apparently because the indexing/ processing is much more efficient if done on a numeric code and I was tryingto associate a unique company code, which could also be used in other operations.


    I am also having a problem in removing duplicates.
    as shown by data given below:


    AlmasPelliSasDiMassaroAlessandroC
    AlmasPelliSasDiMassaroAlessandroEC
    AlmasPelliSasDiMassaroAlessandroEC
    AlmasPelliSasDiMassaroAlessandroEC


    ApisSRL
    ApisSrl
    ApisSrl
    ApisSrl
    ApisSrl



    AIPASpaAgenziaItalianaPerPubblicheAmministrazioni
    AIPASpaAgenziaItalianaPerPubblicheAmministrazioni
    AIPASpaAgenziaItalianaPerPubblicheAmministrazioni


    AFiorDiPelle
    AFiorDiPelle
    AFiorDiPelleDiReginatoSonia
    AFiorDiPelleDiReginatoSonia


    3PRappresentanzaCommercioEsteroSRL
    3PRappresentanzaCommercioEsteroSRL
    3PRappresentanzeCommercioEsteroSrl


    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPierachilleECSAS
    ConfartDiTosanaPierachilleECSAS



    the comapnies can also have other fields which may have duplicates, such as:
    product sector
    address
    telephone


    Could you suggest an efficient method to remove duplicates, but retaining the unique record.


    I can send you a sample excel file to give you a better understanding if you like.



    Any suggestions?

    On how to put me on the right track?

    I would appreciate the best method to input images corresponding to unique images.


    Product name:
    Product code:


    Each product code, has 3 images
    1 image in GIf
    2 image in Jpeg


    If I establish a table with fields:


    Product name
    Product code
    Image name (format) xxxxxx.gif or xxxxxx.jpeg
    Image code


    How do I get it to equate the correct image to the correct product name and code?


    Preferably I would like to do this with hyperlinks and not stick the image directly into the


    Access database.


    based on my understanding:
    a) I have to create a folder and stick the images into it
    b) stick hyperlinks into Excel and link this to Access table


    I need a method where hundreds of these images will be processed.


    thanking you in advance

    Is it possible to convert or transform a text string into an associated "unique" numeric code, I have seen many examples of the inverse process, but few regarding this option.



    The origin of the text data is company names, so at times it may appear as an alphanumeric string, but the resulting conversion must correspond to a "unique" code.


    spaces & nonalphanumeric characaters contained in original company data have already been removed.



    Examples:


    3PRappresentanzaCommercioEsteroSRL
    44GattiDiScandroglioMartaAlziatiDSnc
    900UomoSRL
    2ElleDiLapadulaLucia
    CoRe1920SPA
    IndustriaMinuterieMetallicheGerosaGBSrl




    Please keep all coding simpe, as I am a novice in functions, subroutines etc.


    thanking you in advance