Access Database Macro

In Progress Posted 7 years ago Paid on delivery
In Progress

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.

Microsoft Access

Project ID: #11870351

About the project

14 proposals Remote project Active 7 years ago

Awarded to:

Prashantskin

[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

$12 USD / hour
(475 Reviews)
7.2

14 freelancers are bidding on average $12/hour for this job

paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$12 USD / hour
(77 Reviews)
6.4
zu02

Hi, I’m an Access/VB coder, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, A More

$12 USD / hour
(35 Reviews)
5.9
jawadaman

Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines More

$11 USD / hour
(64 Reviews)
5.5
VladimirLilenko

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

$8 USD / hour
(50 Reviews)
5.2
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$11 USD / hour
(26 Reviews)
4.4
point5nyble

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

$11 USD / hour
(3 Reviews)
2.3
RothcoLtd

Hi I am very interested in your project and would like to know more. For background I am a UK-based developer with over 20 years experience of developing bespoke solutions. I am proficient in Visual Basic in a More

$14 USD / hour
(5 Reviews)
2.1
AMTSolutions

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

$8 USD / hour
(1 Review)
1.8
AmeliNaMeli

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

$8 USD / hour
(0 Reviews)
0.0
sergioobici

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)

$14 USD / hour
(0 Reviews)
0.6