Access Form Enhancement & Calculations
Budget: $30 – $250 USD
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
• 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