Find Jobs
Hire Freelancers

Microsoft Access: Change the format of Form Fileds.

$10-30 USD

Em Andamento
Publicado há mais de 5 anos

$10-30 USD

Pago na 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 do Projeto: 17301384

Sobre o projeto

23 propostas
Projeto remoto
Ativo há 6 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
23 freelancers estão ofertando em média $24 USD for esse trabalho
Avatar do Usuário
Hi! Can you send your database? Regards, Branislav Mihaljev
$15 USD em 1 dia
5,0 (289 avaliações)
7,8
7,8
Avatar do Usuário
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 em 1 dia
4,7 (82 avaliações)
7,4
7,4
Avatar do Usuário
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 em 0 dia
4,9 (199 avaliações)
6,9
6,9
Avatar do Usuário
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 em 1 dia
4,8 (42 avaliações)
6,7
6,7
Avatar do Usuário
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 em 1 dia
4,7 (56 avaliações)
6,3
6,3
Avatar do Usuário
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 em 0 dia
5,0 (55 avaliações)
5,5
5,5
Avatar do Usuário
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 em 1 dia
4,9 (31 avaliações)
5,7
5,7
Avatar do Usuário
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 em 1 dia
5,0 (19 avaliações)
5,0
5,0
Avatar do Usuário
Interested Relevant Skills and Experience Extensive
$25 USD em 1 dia
5,0 (8 avaliações)
4,7
4,7
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi I'm working daily with access and excel and vba on daily base
$15 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Altamonte Springs, United States
5,0
49
Método de pagamento verificado
Membro desde jan. 5, 2017

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.