Access Database Macro
$8-15 USD / hour
I have three tables, CMTR, ATPtbl and Events. The form is on the CMTR table. When someone chooses a certain event I want it to update the date on the ATPtbl for that PID.
I have added a more detailed version of the Database. I would like the following things.
1. On the form when PID or FullName is chosen I would like the form to fill in the other from PID or Fullname in addition to filling in Rank, Duty, birthmonth from the Personel Table.
2. Each Event corresponds to a field in the ATPtbl. I would like the date or number filled in when the event is chosen.
Project ID: #11870351
About the project
Awarded to:
[login to view URL] I have gone through your project requirements. I have also gone through your access file. When someone chooses a certain event the date on the ATPtbl for that PID for that event will be updated automaticall More
14 freelancers are bidding on average $12/hour for this job
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and wi More
Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me More
Dear Sir/Madam, I have 17 years experience with Microsoft Access. I have developed many projects using Access as front and back end. I have developed solutions for Customer Relationship Management, Project Tracking, A More
Hello! apparently, you have to change your database structure, set the correct connection between the tables, then the macro is not required. But in any case, I can help you
I can make the job easly but I must say that the db, as it is now, doesn't support the rules of a relational database and therefore future changes might be more difficult to be done. (just for your information)