Calendar

[Viper]

Does ms access have any built in function that is based on a calendar.
I am building a DB that will make a schedule for the month. The
schedule depends on a lot of factors such as day of week and month.

Is there anything in access that will bring up the day of week for a
certain month.


I want to be able to run the schedule DB at the begining of month to
make a schedule and output the schedule or print the schedule.


Can this be done?
or am i using the wrong program?


what are your suggestions?


Thanks a lot

 

[ruralguy via AccessMonster.com]

Maybe some of Jeff's links will be helpful.
http://home.bendbroadband.com/conradsystems/accessjunkie/calendars.html

 

[Larry Linson]

Does ms access have any built in function
that is based on a calendar. I am building a
DB that will make a schedule for the month.
The schedule depends on a lot of factors such
as day of week and month.

Access has a number of built-in functions dealing with date and time.

Is there anything in access that will bring up
the day of week for a certain month.

You need to clarify because every month contains every day of the week,
multiple times.

If you want the day of the week for a specific date, the function you'd use
is "DatePart." The Access 2003 Help on DatePart is very good, and you reach
it easily by placing your cursor in the DatePart statement in a Module, and
pressing F1.

I want to be able to run the schedule DB at
the begining of month to make a schedule
and output the schedule or print the schedule.

Again, there would be many ways to "output or print a schedule." Access can
output or print a schedule, but whether it will do so in the way you want
depends on the details.

Can this be done?
or am i using the wrong program?

We don't know enough about your requirements. It's possible that project
management software, such as Microsoft Project, may do "out-of-the-box" what
you want, but it's also possible that it would be enormous overkill for what
you want.

Larry Linson
Microsoft Access MVP

 

[Viper]

Larry,

The problem that i have is i have a list of Audits that need scheduled
for the month.

I need access to look at many variables such as...
1. The Audit can't be scheduled on the same day of week as last
audit
2. The audit can't be scheduled in the same week as the last audit
exp. if scheduled in week 1 .... audit can't be
scheduled in week one.
3. The auditor cannot go on the same audit 3 times in a row
4. I also need to look at the distance between audits... exp. time
it takes to get there

These are some of the variables i must program in.
The PROBLEM is:
Say for Jan 07
Say i have [auditor1] picked to be scheduled at [AuditA] on
the 12th of the month.
and [auditor2] picked to be scheduled at [AuditB]
on the 22nd
How do i get access to put that into the calendar (Auditor1 on twelth
day) and (Auditor2 on the 22) and do nothing in the rest of the days
of the month.

The whole month will be scheduled but i need to know how to do it on a
small scale so i can apply it to a larger scale.

I don't know how to input values into the calendar report....

Does this explain it any better?

Thanks again

 

[Larry Linson]

The design of a scheduling application seems to be what you are seeking.
I've never designed one, and wouldn't presume to be able to do so "off the
top of my head here." There have been scheduling components in some apps
I've worked on, but the scheduling was all manual.

Design of an application from a set of requirements, whether stated loosely
or strictly, is more than is appropriate for a newsgroup response.

Just remember, you are modeling the "real world" but you only need to model
it in sufficient detail to solve the problem with which you are dealing.

At the least, I think you'll need three tables:

Audit -- audits to be performed, including start and complete dates
Auditor -- information about the person
AuditAuditorJunction -- foreign keys to Audit and Auditor tables,
to show which Auditor is assigned to which Audit.

Larry Linson
Microsoft Access MVP

Larry,

The problem that i have is i have a list of Audits that need scheduled
for the month.

I need access to look at many variables such as...
1. The Audit can't be scheduled on the same day of week as last
audit
2. The audit can't be scheduled in the same week as the last audit
exp. if scheduled in week 1 .... audit can't be
scheduled in week one.
3. The auditor cannot go on the same audit 3 times in a row
4. I also need to look at the distance between audits... exp. time
it takes to get there

These are some of the variables i must program in.
The PROBLEM is:
Say for Jan 07
Say i have [auditor1] picked to be scheduled at [AuditA] on
the 12th of the month.
and [auditor2] picked to be scheduled at [AuditB]
on the 22nd
How do i get access to put that into the calendar (Auditor1 on twelth
day) and (Auditor2 on the 22) and do nothing in the rest of the days
of the month.

The whole month will be scheduled but i need to know how to do it on a
small scale so i can apply it to a larger scale.

I don't know how to input values into the calendar report....

Does this explain it any better?

Thanks again

Access has a number of built-in functions dealing with date and time.


You need to clarify because every month contains every day of the week,
multiple times.

If you want the day of the week for a specific date, the function you'd
use
is "DatePart." The Access 2003 Help on DatePart is very good, and you
reach
it easily by placing your cursor in the DatePart statement in a Module,
and
pressing F1.


Again, there would be many ways to "output or print a schedule." Access
can
output or print a schedule, but whether it will do so in the way you want
depends on the details.


We don't know enough about your requirements. It's possible that project
management software, such as Microsoft Project, may do "out-of-the-box"
what
you want, but it's also possible that it would be enormous overkill for
what
you want.

Larry Linson
Microsoft Access MVP