MS Access 2

Cerrado Publicado hace 6 años Pagado a la entrega
Cerrado

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 .

Instalación de blogs Diseño gráfico PHP Diseño de sitios web

Nº del proyecto: #16320718

Sobre el proyecto

12 propuestas Proyecto remoto Activo hace 6 años

12 freelancers están ofertando un promedio de $27 / hora por este trabajo

leadconcept

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 Más

$22 USD / hora
(117 comentarios)
9.1
mmadi

السلام عليكم بعد التحية 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 Más

$17 USD / hora
(48 comentarios)
7.1
tsebro

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 Más

$24 USD / hora
(11 comentarios)
6.0
gr8tech

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 Más

$16 USD / hora
(8 comentarios)
4.8
antonbashota

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 Más

$15 USD / hora
(0 comentarios)
0.0
Valsodar123

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 Más

$27 USD / hora
(0 comentarios)
0.0