Access 2010 Scheduling Forms/Tables

Completado Publicado Apr 1, 2013 Pagado a la entrega
Completado Pagado a la entrega

We need to automatically create a schedule for multiple users for completing a daily audit.

We have a database with Users in a users table. Each user is assigned a "Layer" and an "Area". We need a form that will fill out tblScheduledAudits. This will consist of adding a new record for each day for each user with the layer "Supervisor" only. The record will list the User Name, AuditForm reference, and the ScheduledDate.

The AuditForm variable will be an randomly chosen from the table tblAuditFormDefinitions, however, it must choose from the audits that are within the specific users "Area" (these are found in tblCustomizeAuditLocations). (For example: A supervisor that is in BUA (Area) will be assigned a random cell (LocationOfAudit, or LocationName) that is linked to that area in the tblCustomizeAuditLocations). For records in the tblAuditFormDefinitions that have the same Location_Of_Audit, the last record with that audit location should be chosen.

The ScheduledDate will be a date, Monday through Friday for the next 2 months starting from "today". (the day the user chooses to run this with a Form button).

In the case a user area is changed, or a new user is added, we need an option (a form button) to "refresh" the scheduled audits table from "tomorrow" through the next 2 months without losing any existing data from the beginning through "today" .

Microsoft Access Visual Basic para aplicaciones

Nº del proyecto: #4388694

Sobre el proyecto

6 propuestas Proyecto remoto Activo Apr 1, 2013

Adjudicado a:

swapnilchavan18

I can do this please check private message.

$120 USD en 3 días
(11 comentarios)
4.6

6 freelancers están ofertando un promedio de $205 por este trabajo

winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$230 USD en 10 días
(17 comentarios)
5.1
PerfectSquare

Hi I am interested please see the PM

$264 USD en 35 días
(17 comentarios)
3.5
MaanKB

I am able to build this tool I can start now

$253 USD en 3 días
(0 comentarios)
0.0
RayyanTahir

I can do this project for you.

$165 USD en 5 días
(0 comentarios)
0.0