Find Jobs
Hire Freelancers

Microsoft Access: Change the format of Form Fileds.

$10-30 USD

En curso
Publicado hace más de 5 años

$10-30 USD

Pagado a la entrega
I have a concatenated calculated Filed on an Access table (Left([Emp_LastName],5) & Left([Emp_FirstName],2) that "Some times" gives me an #Invalid value. I need this fixed so it doesn't go #Invalid. PS I want This value in the table. I don't want to be calculating it on the Fly when its need..... This is a small 2 minute job if you know what you're doing so please don't bid with some crazy amount.
ID del proyecto: 17301384

Información sobre el proyecto

23 propuestas
Proyecto remoto
Activo hace 6 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
23 freelancers están ofertando un promedio de $24 USD por este trabajo
Avatar del usuario
Hi! Can you send your database? Regards, Branislav Mihaljev
$15 USD en 1 día
5,0 (289 comentarios)
7,8
7,8
Avatar del usuario
Dear, we are Team of French + US. I checked your project description, and I confirm I can change your format fields Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$24 USD en 1 día
4,7 (82 comentarios)
7,4
7,4
Avatar del usuario
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$20 USD en 0 día
4,9 (199 comentarios)
6,9
6,9
Avatar del usuario
I cannot open the database at the moment. let me look at it and If it's a true under 10 min job. I will send back at no cost. I looked at the database! If the Employee last name has less then 5 letters then that is the reason for an error. What would you want that field to do if it has less then 5 letters. Donna
$35 USD en 1 día
4,8 (42 comentarios)
6,7
6,7
Avatar del usuario
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects. I do what it takes. Thank you for your consideration. Zura
$30 USD en 1 día
4,7 (56 comentarios)
6,3
6,3
Avatar del usuario
Hello sir. I would like to help you on your project. If you want to store it in a table then you can make a calculated field or the better way is to use a query. This one is pretty basic just like what you say and I believe that my bid is enough to finish this project as fast as I can. Thanks and have a nice day. Reproducing the error is necessary so that we can really pinpoint what's the problem.
$10 USD en 0 día
5,0 (55 comentarios)
5,5
5,5
Avatar del usuario
Hi, There is a small issue in the formula. Please use as below. Left(nz(EMP_LastName,""),5) Just add nz(). If field value is null then its throw the error.
$15 USD en 1 día
4,9 (31 comentarios)
5,7
5,7
Avatar del usuario
Hi, MS Access doesn't allow all the functionalities in a calculated field in tables. Please send me your sample database so that I can look into the issue in a real environment. Thanks
$20 USD en 1 día
5,0 (19 comentarios)
5,0
5,0
Avatar del usuario
Interested Relevant Skills and Experience Extensive
$25 USD en 1 día
5,0 (8 comentarios)
4,7
4,7
Avatar del usuario
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I'm Abu Gosia. I'm interesting your project very well. Let me try. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi I'm working daily with access and excel and vba on daily base
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
if you are just need the correction and and saving data in table i will do this in one day and cost will be 5 $
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I'm an expert of excel, access and visual basic. As you noticed "this is a small 2 minute job if you know what you're doing". Maybe I'll need 10 minutes or something more, but I think you are right. Please if you want just send me your database, I'll try to fix the problem and if it's really easy I'll not ask for money. Best regards Andrea
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi: I'm VBA Programmer and a loyal user of MS-Access since 1998. I had the same problem you mention in your advice. Please, take as an example this line an probe if it function: Left([Table1]![Field1];5) & Left([Table1]![Field2];5) You change the , for a ; between the field and the long you need. Have a nice day, and thank you for your attention.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Altamonte Springs, United States
5,0
49
Forma de pago verificada
Miembro desde ene 5, 2017

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.