In Progress

MS Access Project - Bug Fix & Enhancements

I have an existing project which requires a bug fix and 3 new enhancements as described below:

Existing Bug

1. Checking "inactive" to prevent a volunteer from appearing in a shift is not working. We need a "Delete" button on the volunteer scheduler screen to delete a particular shift of a particular volunteer (which deletes the record from the v_volunteer_shift table AND v_volunteer_shift_days table.

New Enhancement:

1. The client wants each shift to have a "normal" shift timing (current shift times are the "normal" shift times) and a "weekend shift times".

For eg. a particular shift (Night Shift) time is 7:00pm - 11:00pm (normal) but that same shift should be 7:30pm - 11:30pm for weekends. Thus, if a person is scheduled for the 25th of every month, and the 25th happens to come on a weekday, then that person would come from 7:00pm - 11:00pm but if the 25th of the month happens to be a weekend, then he would come from 7:30pm - 11:30pm (ie. in the monthly schedule, the shift should show 7:00pm - 11:00pm if it is a weekday and 7:30pm - 11:30pm if it is a weekend.

2. Currently, there is a single report ("View Monthly Schedule" for the monthly schedule having 7 columns (ie one for each day of the week)

The client want a New report ("View Monthly Weekday Schedule") which should have only 5 columns for monday - friday. Thus, all the columns would be slightly wider (and hopefully the text would not scroll to the next line).

3. Currently, there is a single report ("View Monthly Schedule" for the monthly schedule having 7 columns (ie one for each day of the week)

The client want a New report ("View Monthly Weekend Schedule") which should have only 2 columns for Saturday - Sunday. Thus, there would be only 2 columns.

Skills: Microsoft Access

See more: access project bug, volunteer, schedule project, project schedule, one night show, night view, friday night, bug fix, access delete, shift scheduler, enhancements microsoft access, existing project, saturday sunday, scroll fix, time scheduler, fix client, day shift schedule, checking project, want shift schedule, microsoft shift report, fix monday, weekend next, sunday times, fix report access, access report fix

About the Employer:
( 6 reviews ) Mumbai, Canada

Project ID: #2524124

Awarded to:

kulhanekd

I will do the upgrades. Donna

$50 USD in 2 days
(31 Reviews)
5.8

15 freelancers are bidding on average $79 for this job

Prashantskin

Res.Buyer I have gone through your project requirements. I will fix your bugs in will add additional functionalists to your existing db within 2 days only Please see PMB for details Thanks for your time Regard More

$70 USD in 2 days
(459 Reviews)
6.9
torajiv

Access and VBA expert here - please send me your db - regards - Rajiv

$80 USD in 3 days
(58 Reviews)
5.6
instech

12+ years of Access programming experience. Please see the PM for comments and questions.

$65 USD in 2 days
(7 Reviews)
4.7
diegogarcia0531

MS Access, VBA, SQL expert, I am ready to do this job

$35 USD in 1 day
(13 Reviews)
4.4
NourElDeen

Dear Sir, I'm Expert on access. Best Regards, NourElDeen

$65 USD in 5 days
(19 Reviews)
4.2
braghunath

I have been developing applications in MS Access since 2003. I can take up this project immediately.

$135 USD in 10 days
(3 Reviews)
4.1
zkutch

Hello. More 15 years vb, vba, office programming experience. See pmb, please.

$30 USD in 0 days
(0 Reviews)
0.0
CaptainCode

Hi there! I have experience in access database creation and supporting. As well as VBA developing and writing SQL queries.

$30 USD in 1 day
(0 Reviews)
0.0
smilysurvivior

I 'm ready to start the job. Thanks

$50 USD in 10 days
(0 Reviews)
0.0
PITHYD

Hi,please check your mail box.

$100 USD in 5 days
(0 Reviews)
0.0
IppoMits

I need max. 3 days of Access/VBA development for this

$100 USD in 3 days
(0 Reviews)
0.0
MSSQLexperienced

Dear Project Sponsor, I will do it + additional task for free, to get my first review on freelancer.com. I am highly experienced both in MS Access and MS SQL Server. Best regards, Pawel.

$30 USD in 3 days
(0 Reviews)
0.0
abdullahshahid90

I can do this project...its easy...try me...i m new here on freelancer and struggling to get my first job, if you want to negotiate on price i can do that too

$100 USD in 7 days
(0 Reviews)
0.0
DaddyWarbucksEsq

My name is George Panko, dba The Immaculate Cohhection*. I am relatively new to this freelancer site, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining M More

$250 USD in 7 days
(0 Reviews)
0.0