Devam Ediyor

Access 2010 Scheduling Forms/Tables

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" .

Beceriler: Microsoft Access, Uygulamalar için Visual Basic

Daha fazlasını görün: access scheduling form, starting with visual basic, daily access, audit reference, need an audit, audit forms, completing the case, automatically fill forms, access linked table, microsoft visual basic applications, access 2013 create button, create button access 2013, visual schedule, access form record, date monday, table linked access, microsoft access quot, access 2010 example database, visual basic applications 2013, visual basic multiple forms, database data access layer, within today today tomorrow, access daily, microsoft access 2010, visual basic scheduling

İşveren Hakkında:
( 1 değerlendirme ) Columbus, United States

Proje NO: #4388694

Seçilen:

swapnilchavan18

I can do this please check private message.

3 gün içinde 120$ USD
(0 Değerlendirme)
0.0

7 freelancer bu iş için ortalamada 214$ teklif veriyor

Prashantskin

[url removed, login to view] I have gone through your project requirements and the access file. I will develop the things mentioned in your request within 3 days only Please see PMB for further details Thanks for your time Regards Daha fazlası

in 3 gün içinde200$ USD
(462 Değerlendirme)
6.9
winnet21

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

in 10 gün içinde230$ USD
(10 Değerlendirme)
4.7
PerfectSquare

Hi I am interested please see the PM

in 35 gün içinde264$ USD
(11 Değerlendirme)
3.2
bgriffin001

I am currently doing VB.NET with both Visual Studio 2008 and 2012 for the state of Virginia and Georgia State University in Atlanta,Georgia. I can send you COMPLETE vb.net aplications I have written. Please look at my Daha fazlası

in 3 gün içinde264$ USD
(1 Değerlendirme)
1.0
MaanKB

I am able to build this tool I can start now

in 3 gün içinde253$ USD
(0 Değerlendirme)
0.0
RayyanTahir

I can do this project for you.

in 5 gün içinde165$ USD
(0 Değerlendirme)
0.0