Recent content by Shinsuke

Hi again. I managed to solve the miscalculation part a few days ago. I simply changed the DayMax to Me.ScheduledStartDate and it finally works. I still have the other problem I'm still not able to solve. In one of the tables, I have a list of jobs that have different time schedule and...

Thanks for the help again John. I've a couple of problems with my database which I hope you'd able to help. Firstly, when I incorporate the codings into my database application, there's some calculation problems. For example, the start date is 25th May 09, and I set the interval to 1 day. So...

Hi again. The database sample is really useful, but is it possible to automate the date as long as the current system date reaches the next date? It's not really a life and death situation, but its something that can be improved.

That's it! This sample database will definitely help out alot for my project. Thanks alot John!

Thanks for the link, but I don't think that's what I'm looking for. Let me rephrase my question. What I'm looking for is to automate scheduled start date according to the schedule. For example, a halfyearly job which is done on 1st Jan 09, will automate the date 1st June 09 on the Scheduled...

Hi there. I'm currently on a project which takes care of preventive maintenance scheduling. The job operations are such that they can occur once a year, once every 6 months, once every 3 months, once a month, once a week and one-off jobs. The requirement is that I'm supposed to make a...