Creating a schedule

[Tigereyes78]

Hi everyone,
I am creating a database for a maintenance business. There are numerous properties in a table, another with charges for each maintenance type eg cleaning, pool maintenance, gardening etc.
I need to create a schedule to show available dates for each maintenance type into which one or more property references can be added fo work to be carried out.
This was in A LOT of spreadsheets, one for each property/maintenance type and month! With the property portfolio now reaching over 50 I am hoping for a better solution in Access. I was hoping for some kind of calendar table generator with pre-populated dates so the user can see which dates are available or have space for another property!
Oh and this schedule is then used to generate the charges to invoice the property owner.
Please tell me there is a solution or am i banging my head against a brick wall ? :/
Thank you:banghead:

 

[CJ_London]

Ir can certainly be done in access, take a look at some of the scheduling templates within access and online to find one that most closely matches your requirement, then adapt it.

 

[Tigereyes78]

hi, theres only the timecard template for access that comes up in the search which isnt really suitable at all. Thank you though

 

[HiTechCoach]

This was in A LOT of spreadsheets, one for each property/maintenance type and month! With the property portfolio now reaching over 50 I am hoping for a better solution in Access.

I Agree that a database is a better solution that spreadsheets.

I was hoping for some kind of calendar table generator with pre-populated dates so the user can see which dates are available or have space for another property!

Not sure what you me by hoping for.

Please tell me there is a solution or am i banging my head against a brick wall

If by "tell me there is a solution" you are asking if this is possible to program this within Access then I would say yes is possible to create a solution with Access.

 

[HiTechCoach]

hi, theres only the timecard template for access that comes up in the search which isnt really suitable at all. Thank you though

The timecard examples can give you some ideas on how to create the scheduler.

I agree with CJ_London to look online, not just within Access, to see if there is anything that you can purchase to use as "building blocks" to speed up the development.

Have you looked in the Code Repository or the Sample Databases forums here on the site. You should find links at the top of the right above the Sponsored Links (ads)

FWIW: Scheduling is not a simple thing to program. I think of it as a form of inventory control for time. Inventory control is one of the most difficult things to program with any software development platform, including Access. That explains why you will probably will not find complete solutions on the web for free. You can find bits and pieces that you can learn from to build your own.

There are sites that sell stuff built within Access or custom controls that work with Access. These "components" can be used in your database to build calendar and scheduling functionality.

 

[Gasman]

I posted a Calendar db that I modified for a user that might help?

https://www.access-programmers.co.uk/forums/showthread.php?t=275897

I also modified another DB I foundm that we now use to track holidays for employees.
You could use that, one row for each property?

It is quite a clever database and it took me a while to understand how it all works, but I managed to modify it for our needs, The interface, as far as I am concerned is very cleverly put together.

If you think it might be of use I can post up my version, and I might even have the original version.?

Should give you a head start at least.?

 

[HiTechCoach]

TIP: When searching for examples, you can normally use anything for Access 2000 and later up to the versions of Access you have.

FWIW: I post all my example in the oldest version possible (usually 2000) to allow the most people to use them.

I do have this example on my web site that might be helpful:

Schedule Grid - DesGrid (Click Here)

 

[HiTechCoach]

I posted a Calendar db that I modified for a user that might help?

https://www.access-programmers.co.uk/forums/showthread.php?t=275897

I also modified another DB I foundm that we now use to track holidays for employees.
You could use that, one row for each property?

It is quite a clever database and it took me a while to understand how it all works, but I managed to modify it for our needs, The interface, as far as I am concerned is very cleverly put together.

If you think it might be of use I can post up my version, and I might even have the original version.?

Should give you a head start at least.?

I would like to see the original is you still have it.

Thanks.

 

[Gasman]

Hi Boyd,

I managed to locate it. Also uploaded the documentation on how it works.
Had to convert from pdf to doc as file was too large to upload as it was and a zip file was even bigger?

 

[HiTechCoach]

Hi Boyd,

I managed to locate it. Also uploaded the documentation on how it works.
Had to convert from pdf to doc as file was too large to upload as it was and a zip file was even bigger?

Thanks. You ROCK.