MS Access form to capture inputs and or update the database accordingly.

[TheMohitDembla]

Hi,

I have a team of 40 associates and currently, we have one excel based file with multiple columns to capture the data on a daily basis.

These columns are bifurcated into Four parts:

The first part, basic details:

First 12 columns:
Date, Month, Week #, Unique ID ( Aklphanumeric), Tracker ID (Alphanumeric), Client Name, Project Name, Developer, Role( drop down list) , Region (Drop Down List), Country (Drop Down List), Work Type (Drop Down List)

Second part: Productive hours: - Will be in numbers
next 30 columns, grouped into four major headings:
1) Specification:
-Review
-Request for Additional
-Validate

2) Development:
- BA
- DB
-Explorer
-Dict
-DB Select
-Expressions
-Groups
-Conditions
-Data Selections
-Panel Creations
-Report Analysis
-MS VBA / Access
-Datasets
-Formatting
-Conv& Ev
-Validate in User module
- Exporting / Scripting
- Print (look & feel)
- Self QC
- Cross QC

3) Client:
- Client Training
- Client Live meeting/IM/Call

4) As usual
- Transition (Documentation, Instructions etc..,)
- Live Meeting & Call
- Support (Through IM chat, Call etc..,)
- Refresh
- Rework

Then we have the sum of all the above-mentioned production columns.

The Third part, non-productive details:
6 columns:

-Knowledge Transfer
-Project Management
-Awaiting Time (Others)
-Waiting for sign off
-Waiting for database
-Waiting for feedback / Information

Then we have the sum of last four items (Awaiting Time (Others, Waiting for sign off, Waiting for database and Waiting for feedback / Information) labeled as Non-productive columns.

then we have remarks column.



the fourth Part, Company Internal:

-Team Meeting
-Internal Trainings
-Internal Documents
-Internal Process Compliance
-Total Internal Hours (Sum of above four)
-Remarks
-Leave
-Other leaves

The FINAL HOURS COLUMN.


I want to create one MS Access form file with two buttons (described below)


The structure which I think can help and easy to use is:

1) Master form with Two buttons:
Button 1) Create new - When clicked, should land on new form labeled as Entry form with all the relevant text boxes and drop down selection combo boxes and date boxes with a submit button. When this button is clicked, it should get stored in the ms access database at a particular location.

Button 2) Update/Delete Existing - When clicked, a pop-up input box should appear with a button labeled as search where the associate should enter tracker ID and hit the search button. Upon clicking the search button, "Update/Delete Existing" Form should appear.


2) "Update/Delete Existing" Form- This form should appear with an editable list of all the items available in the database with same Tracker ID, with checkboxes on the left before each row and delete and update button on the bottom right-hand side. The idea behind this setup is upon clicking delete/update button, the rows which are checked should get updated deleted in the database.