Find Jobs
Hire Freelancers

Microsoft Access: Change the format of Form Fileds.

$10-30 USD

In Progress
Posted almost 6 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 17301384

About the project

23 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average $24 USD for this job
User Avatar
Hi! Can you send your database? Regards, Branislav Mihaljev
$15 USD in 1 day
5.0 (289 reviews)
7.8
7.8
User Avatar
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 in 1 day
4.7 (82 reviews)
7.4
7.4
User Avatar
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 in 0 day
4.9 (199 reviews)
6.9
6.9
User Avatar
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 in 1 day
4.8 (42 reviews)
6.7
6.7
User Avatar
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 in 1 day
4.7 (56 reviews)
6.3
6.3
User Avatar
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 in 0 day
5.0 (55 reviews)
5.5
5.5
User Avatar
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 in 1 day
4.9 (31 reviews)
5.7
5.7
User Avatar
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 in 1 day
5.0 (19 reviews)
5.0
5.0
User Avatar
Interested Relevant Skills and Experience Extensive
$25 USD in 1 day
5.0 (8 reviews)
4.7
4.7
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I'm working daily with access and excel and vba on daily base
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Altamonte Springs, United States
5.0
49
Payment method verified
Member since Jan 5, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.