Roster Application

I need an aplication to be created solely in VBA(Excel) and Microsoft SQL.

Frontend need to be a few Forms with some minimal functionality in the excel sheet and all the backend database in MS SQL 2005.

It may be easier If I list the Backend Tables First (I will provide full schema once job is agreed which may require a few modifications):

• Employee (Id, NTLogon,Name, LocationID, Email, ManagerID, Perm/Temp/Contract, ISActive, etc)

• Location (LocationID, Location, Region)

• EmployeeCover (CoverID, Orignal_EmployeeID,Covering_EmployeeID, IsActive )

• State (StateID, StateName, StateDesc, IsApprovalRequired,Color,IsActive)

• ShiftPattern (PatternID, EmployeeID, StateLevelID, Start, End, DayOfTheWeek, ISActive)

• Shift (ShiftID, Start, End, EmployeeID, Status, Comment)

• YearlyHolidayAllowance(ID, Year, EmployeeID, StartDate, EndDate , Hours)

• Holiday(HolidayDate, Holidaydesc, Region)

• Admin(employeeID, IsActive) – This stores the IDs of the Admins.

Next, Let me clarify on the application purpose and GUI Components:

Main purpose is to track people’s shifts (Start/End) and allowing the Employee or the manager’s the ability to add holidays and then an Admin GUI to manage different aspects and also ability for the Employee or their Manager to be able to easily see the team availability.

Evner: Excel, SQL, Visual Basic for Apps

Se mere: shift manager, microsoft excel VBA, end vba, email temp, application vba, microsoft contract database, schema sql, gui vba excel, status list excel, vba add excel, Vba sql, modifications excel, employee excel vba, excel contract database, excel gui vba, vba provide, add tables sql, frontend backend database, vba excel add, track email excel, excel list holidays, state region list excel, email database region, list status excel, gui backend

Om arbejdsgiveren:
( 0 bedømmelser ) United Kingdom

Projekt ID: #4044877

11 freelancers are bidding on average $253 for this job


We had implemented a very similar Excel + external SQL DB application before. Based on the previous experiences the implementation takes a bit of time, especially the set up of the database on the external server. Chec Flere

$960 AUD in 14 dage
(21 bedømmelser)

Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.

$199 AUD in 7 dage
(6 bedømmelser)

Programming EXCEL VBA from Year 2000. This can be done. Need morw discussion on detailes of functionality required. Please see PMB.

$250 AUD in 15 dage
(2 bedømmelser)

Dedicated expert in programming to include VBA ready to take care of this Project ...

$98 AUD in 7 dage
(2 bedømmelser)

looking forward to work on this project

$150 AUD in 10 dage
(1 bedømmelse)

Hi, I have looked at your project and have similar experience in my previous job where I built a shift tracking system using a SQL backend and had the front end in Access as that was the only tool available. I wonde Flere

$250 AUD in 20 dage
(2 bedømmelser)

I am interested to develop this application. I have vast experience for VBA.

$200 AUD in 15 dage
(4 bedømmelser)

hi, i have developed employee management system earlier and ready to start this please check your pm to start.

$250 AUD in 7 dage
(0 bedømmelser)

Just finished a project regarding a sales and customer management software...We are a team of 4 programmers, will deliver best quality for a reasonable cost...

$250 AUD in 7 dage
(0 bedømmelser)

Ready for the Work

$150 AUD in 15 dage
(0 bedømmelser)

hello sir i am best for this

$30 AUD in 10 dage
(0 bedømmelser)