MS Access 2

I’m working on Microsoft Access to create a desktop database application, where it is supposed to :

1. Allow the students to input their ID, and then automatically print them a late slip

2. Automatically saves the lateness information (Student ID, student name, student grade and time of arrival)

3. Generate daily late reports, which can be achieved through one click, and then inputed into the school’s information system.

I have already created all the tables with the required information, created the relationship between them and the forms for each table - there are four main tables -. However, I am not able to create a function (which I was told to create through the code builder) for one of the forms called “Lateness Record”. The table of this form “Lateness Table” includes the fields [Lateness ID (auto number), Student-Id, Student-Card-ID, Family-ID, system-date and system time] and this form is supposed perform the following:

Once the student enters his Student ID into the appropriate field:

• The system has to show the following fields on the same form [Student-Name, Student Grade, Student-Photo, System date and system time]. The fields [Student-Name, Student Grade,Student-Photo] are fields in another table named “Students Table” that is linked to the “Lateness Table”.

• Then a record has to be inputted automatically into the “Lateness Table” with the values of [Lateness ID (auto number), Student-Id, Student-Card-ID, Family-ID, system-date and system time]

• Then the lateness slip (report) will be printed automatically showing [ Student name, Student Grade, System date and system time)

• Right after the print, the system has to clear the form (create a new record) for the following student.

The image below is a template code which I have been instructed to work with in order to create the function but its not working

Kindly find the Access database I am working on attached below .

Skills: Blog Install, Graphic Design, PHP, Website Design

See more: i need a ms access programmer, ms access database with scripts 2, search project code ms access, how to use microsoft access, microsoft access 2013 free download, what is microsoft access used for, access microsoft, microsoft access 2013, microsoft access online, microsoft access download, microsoft access 2016, microsoft access, sample ms access point sales source code, sample code reading ms access desktop application, project source code online advertising agency asp net vb net ms access, ms access vba code ftp download, ms access vba code copy paste subform form, ms access code whois html page, form level validation code ms access, email vb code ms access examples

About the Employer:
( 0 reviews ) United Arab Emirates

Project ID: #16320718

13 freelancers are bidding on average $26/hour for this job


Dear Sir, I have read everything & interested to work on this Access Application, so please let me know if you want me to give you total cost or you want to work on hourly basis? Please let me know how do you wan More

$22 USD / hour
(106 Reviews)

السلام عليكم بعد التحية Hey AbduDroo, I have gone through your project MS Access 2 Thanks for posting this job, which comes under our expertise area. We are happy to offer you our dedicated services if you can share More

$17 USD / hour
(45 Reviews)

Hello I am MS Access expert please check my review and past work. i can provide you quality work let's discuss. thanks

$22 USD / hour
(15 Reviews)

I can help you with your project and carry out all your requirements. I’m a professional database administrator with more than 10 years experience and professional Web Developer and co-owner of a web-development te More

$24 USD / hour
(11 Reviews)
$27 USD / hour
(10 Reviews)
$22 USD / hour
(7 Reviews)
$22 USD / hour
(3 Reviews)

Hello Your job post caught my attention and I have all skills required for this job. Can we have further discussion regarding your project? I assure you that I will provide you quality work as per your requirements. More

$15 USD / hour
(0 Reviews)

Hello, I will provide the additional required VBA/Macro for the required additional functionality and will providing printing functionality, updating of records and other functions. I have gone through part of your acc More

$16 USD / hour
(0 Reviews)

Hi, I have already done following test code based on your access file: Private Sub Student_ID_Change() Dim str As String Dim db As Database Dim rs As [login to view URL] str = "select * from [Students Table] wh More

$100 USD / hour
(0 Reviews)

Hi There, I understand the problem you need solved, therefore I believe I can help. Lets do it like this, Give me 24 hours to solve the issue, If i do not succeed you pay me only the Freelancer fee and we call it e More

$15 USD / hour
(0 Reviews)
$15 USD / hour
(0 Reviews)

I was working in MS Access for 10 years and made multiuser relational MS Access application which has been used by more than 50 user at the same time in two cities and covered all service activities of employees in se More

$27 USD / hour
(0 Reviews)