Access Form Enhancement & Calculations

$10-30 USD

Käynnissä

Julkaistu 8 päivää sitten

$10-30 USD

Maksettu toimituksen yhteydessä

I have a Microsoft Access database that is used through a single data-entry form. I now need a small precise upgrade: • Add a new “Target Price” field to the form and to the underlying table. It is simply a numeric entry—no embedded formula, just the ability to store the value. • Add a “% of Current Value vs Target” field that automatically calculates the percentage difference every time the record is saved or the Current Value or Target Price changes. This calculation should reference the existing Current Value field and must update both on-screen and in the table so it remains query-friendly. • Extend every numeric field in the form and table (including the two above) to 13 decimal places so we can capture the precision our reporting now requires. The form already works well, so I’m looking for someone who can slip these adjustments in cleanly, keep all existing VBA or macros intact, and return a ready-to-use database file. If any queries, reports, or validation rules break because of the added precision, please patch them as part of the job. A compact, well-commented solution is all I need; no redesign or extra features. My budget for the form enhancement is $40

Projektin tunnus (ID): 40352039

Tietoa projektista

19 ehdotukset

Etäprojekti

Aktiivinen 5 päivää sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@fanninson45

$0 USD 7 päivässä

4,9

(30 arvostelut)

6,6

19 freelancerit tarjoavat keskimäärin $123 USD tätä projektia

@ParisPallas

Hi! Are you struggling to add new calculated fields and higher precision to your Access database without breaking existing logic? I will implement these upgrades cleanly so your form, table, and calculations work seamlessly. I focus on precise, minimal-impact Access modifications—adding fields, updating calculations, and adjusting data types while preserving existing VBA, forms, and workflows. I’ve helped clients enhance live databases without disrupting current functionality or introducing errors. Clients value working with me because I’m methodical, careful, and detail-driven. I take pride in making targeted changes that integrate smoothly and remain fully maintainable. For your project, I will: Add the “Target Price” field to table and form Create the “% of Current Value vs Target” calculated field (auto-updating and stored for queries) Extend all numeric fields to 13 decimal places Ensure calculations update on change/save events Fix any affected queries, reports, or validations Preserve all existing VBA and functionality With almost 1,000 projects in 13 years, I am confident I can complete this quickly and safely. I am available 8 a.m.–9 p.m. Athens time and ready to review your file.

$40 USD 1 päivässä

5,0

(859 arvostelut)

9,0

@vano101

Hello I have several years of experience with Microsoft Access. I checked project requirements and attached file, and everything looks clear. I estimate I can complete project in few hours of working time,

$23,37 USD 1 päivässä

5,0

(605 arvostelut)

7,1

@mkh559a5a1fd66e9

As a Full Stack Developer with an extensive background in Database Management, I am supremely well-equipped to undertake your Access Form Enhancement & Calculations project. I have over a decade's worth of experience in using Microsoft Access, and I am well-versed in working with both forms and underlying tables. Not only will I be able to add the new "Target Price" field along with the "% of Current Value vs Target" field that you require, but I can also extend each numeric field to 13 decimal places with precision to meet your reporting needs. In addition to my expertise in Microsift Access, my proficiency extends to VBA and macros as well. Therefore, I can assure you that all your existing functionalities will remain intact throughout the process. Also strong Excel skills means that any querying or validating tasks that may require patching as part of the added precision will be executed seamlessly. More than just completing tasks, I'm dedicated to providing clean, efficient solutions. I value maintainable code and can take your project all the way through deployment, ensuring its ready-to-use without any hassle. As a Full Stack developer with experience across various industries including healthcare systems for which precision is paramount, I'm confident my skills can deliver a database that not only meets your needs but surpasses them. Give me a chance and you won't regret it!

$140 USD 2 päivässä

5,0

(1 arvostelu)

4,3

@edwarddzi8f

Hi! I can help you with the Access form enhancements. Pretty clean scope here. Adding the Target Price field, wiring up the percentage calculation to fire on change and save events, and extending all numeric fields to 13 decimal places. I'd make sure any existing queries or reports that reference those fields still work after the precision change. I'm Edward, been working with databases and VBA for over 10 years. I'll keep your existing macros intact and comment everything clearly so it's easy to maintain. Happy to chat more about this.

$110 USD 7 päivässä