i would like a software soloution for some booking charts. at the moment, i have a pen and paper based system. i work on a campsite, where by i need to show who is in each pitch and for how long. i need to be able to print out a list the days arrivals. and the days visits. We visit all our customers the day after they arrive and the day before they leave, howver if they are only here for 1 night we do not need a visit. if they are here for 2 nights we only do there departure visit.
i would also like to be able to assign members of staff to each item. for instance when i know who is leaving and who is arriving, i assign a staff member to go and clean that accomadtion. so i would like it somehow log who has done what and when, the same goes for each of the visits.
I have added a quick mock up of the chart layout we currently use. As i said before, we currently have a pen and paper based system. So this is only a mock up.
What i am after is to be able to input the customer onto the chart using some sort of form. i would then like the ability to drag the customer from one accommodation to another. All our bookings are sent to us 3 weeks in advance rather than on the day of arrival. however visits and cleans are only decided the day before they are to be done. as you can see from the mock up, i would like some way of being able to run a report that shows everyone that is arriving that day. i would also like to run a report that shows that days cleans. Cleans are done the day the customer leaves. we also re-clean the accommodation the day the next customer arrives - however both are done the same time if the accommodation is to be reused the same day. i would like to be able to assign a clean to each staff
visits are worked out the day they are to be done, so i would need some sort of form that shows me all the visits due for a selected day (selected as i work them out a day before, in order to have a day off), then be able to assign them to each staff
then after all work is assigned i would like to be able to print a report for each staff that shows them,
visit ggg (day after arrival visit)
visit hhh (day before departure visit)
I originally stated i would like it in excel, as i would need it to run on both mac and windows. i was originally planning on storing the excel file on a network attached storage drive in order to access it from both, however i am open to suggestions.
I must add swell, we have different types of accomodation which need to be kept seperate from each other. so once i have assigned a customer to an accomodation, i would to only be allowed to move them into another accomodation which is of the same type.
also the application needs to be able to have accomodation added or removed at any time. As the campsite im on is seasonal, i only want the current year stored. Then next year i would like to almost "reset it" and start over, as i will have all new staff, different customers, different accommodation and so on
11 freelance ont fait une offre moyenne de 172 £ pour ce travail
Hi, A very simple application, we can deliver the expected solution. Kindly request you to refer your private message board for further details.
Hi This is Piyush Patel I have 7 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Please Check My PM