Find Jobs
Hire Freelancers

Microsoft Access: Change the format of Form Fileds.

$10-30 USD

V teku
Objavljeno pred več kot 5 leti

$10-30 USD

Plačilo ob dostavi
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 projekta: 17301384

Več o projektu

23 ponudb
Projekt na daljavo
Aktivno pred 6 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
23 freelancerjev je oddalo ponudbo s povprečno vrednostjo $24 USD za to delo
Avatar uporabnika
Hi! Can you send your database? Regards, Branislav Mihaljev
$15 USD v 1 dnevu
5,0 (289 ocen)
7,8
7,8
Avatar uporabnika
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 v 1 dnevu
4,7 (82 ocen)
7,4
7,4
Avatar uporabnika
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 v 0 dnevu
4,9 (199 ocen)
6,9
6,9
Avatar uporabnika
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 v 1 dnevu
4,8 (42 ocen)
6,7
6,7
Avatar uporabnika
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 v 1 dnevu
4,7 (56 ocen)
6,3
6,3
Avatar uporabnika
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 v 0 dnevu
5,0 (55 ocen)
5,5
5,5
Avatar uporabnika
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 v 1 dnevu
4,9 (31 ocen)
5,7
5,7
Avatar uporabnika
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 v 1 dnevu
5,0 (19 ocen)
5,0
5,0
Avatar uporabnika
Interested Relevant Skills and Experience Extensive
$25 USD v 1 dnevu
5,0 (8 ocen)
4,7
4,7
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hi I'm working daily with access and excel and vba on daily base
$15 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
Altamonte Springs, United States
5,0
49
Plačilna metoda je verificirana
Član(ica) od jan. 5, 2017

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.