Find Jobs
Hire Freelancers

Access Function to add numbers 1,2,3...n to field values that are duplicates

$10-30 USD

Terminado
Publicado hace alrededor de 10 años

$10-30 USD

Pagado a la entrega
I need a simple VBA function for MS Access (2010) that I can use in an update query to 1) checks the strings in a given field for duplicates 2) then, for strings that have duplicates, add digits to its end. Example of the input and the expected output: K17B8897 --> K17B8897-0 K17B8897 --> K17B8897-1 H19R1234 --> H19R1234-0 H19R1234 --> H19R1234-1 H19R1235 --> H18R1235 P22K4456 --> H22K4456 K17B8897 --> K17B8897-2 (mind the hyphen!) K17B8897 --> K17B8897-3 (mind the hyphen!) The output strings should be put into a new field, which the function should create itself, ideally to the right of the source field. The function will have three parameters: CheckDuplicates(WhichFieldToCheck, NameOfFieldToCreateForOutput; StartWithNumber) The parameters are - WhichFieldToCheck: Name of the field to check - NameOfFieldtoCreateForOutput: Possibility to set a name for the new column that will be created; if not name is given, "Modified" is used. - StartWithNumber: Set a number to start with, e.g. 1000 --> 1000, 1001, 1002...; if not set, counting starts with 0. For delivery, it is sufficient to send me the VBA code; I will myself create a module to store it where I need it.
ID del proyecto: 5325031

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback. I am UK based, a native English speaker, available on Skype and currently on UTC. Basically Prompt for Table Name, Field Name, Output Field Name, Start No with defaults if skipped If initial sort order significant add autonumber so the current order can be restored Sort by Field Name and go first Store value as variable and go next Loop to add sequential numbers and store in output field while value=variable Reset Variable and continue Hope to hear from you, I am very keen to work with employers who use freelancers a lot Regards David
$25 USD en 1 día
4,5 (2 comentarios)
3,6
3,6
9 freelancers están ofertando un promedio de $31 USD por este trabajo
Avatar del usuario
Hello, How are you? Can you remember me? I did one of your project( perhaps 2 years ago) and that was my first project in vWorker.com. Anyway, i am interested to do this work, waiting for a positive response from you. Thanks
$25 USD en 1 día
5,0 (7 comentarios)
3,2
3,2
Avatar del usuario
Hi Chgeiselmann. Your requirement requires a recursive query function that would make a lot of queries and would slow down the system. What if I write you a VBA function in Excel that would do the following with the same parameters. You might convert it to Access query as it suits you. Would this work for you ? Regards. Usman
$30 USD en 1 día
5,0 (3 comentarios)
3,2
3,2
Avatar del usuario
Dear Sir, I'm Expert with access, talent with VBA, and i'm interested in doing your project. I have a part of that function just few modification and it will be ready. Kind Regards, NourElDeen
$29 USD en 1 día
5,0 (9 comentarios)
3,2
3,2
Avatar del usuario
VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check https://www.freelancer.gr/projects/Data-Processing-Excel/data-translation-excel.html and feedback at https://www.freelancer.gr/u/paris2785.html I can start right away. For any questions, please let me know. Paris
$25 USD en 1 día
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
Dear sir, I've read you requirement carefully. With expertise in VBA and much experience working with Acess-SQL, I could be a good fit. Kind regards, LY
$50 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello There, I am excited to do this. I can complete this by today. Why you should choose me? 1.) I am proficient in VB, VBA. I can show you projects I have made if you want. 2.) I give timely updates on the progress of the project. 3.) I create documentation on the things that was done for easier modification when needed. I am from the Philippines but is currently in the US studying. Looking forward to work for you! Sincerely, Derrick
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am a professional software engineer with 9+ years of experience. I am very talented programmer with the following skills c, c++ , java ,VB, UNIX, Linux,SSH, PHP, Jsp , Js , advanced js like jquery, extjs etc. My skill set and experience are best suitable for your requirement. Please assign this task to me I will make sure your work will be completed to your full satisfaction.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(Admin),Oracle PL-SQL,Classic ASP, MS SQL (DBA,T-SQL),VB 6.0,VBA,COM/DCOM,VB Script,MS Access, Excel, Macros, Flash (AS2, AS3), Crystal Reports (Designer and Server), ColdFusion
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de GERMANY
Munich, Germany
5,0
34
Forma de pago verificada
Miembro desde oct 3, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.