Access Report Calendar

[ghoti811]

Hello.
I have ben trying to create a report in MS Access that fills in a
calendar of job/project schedules. I have been searching this topic in
Google groups with no luck, i have been given 1 address over and over
again that does not work, it has no sample calendars as everybody says
(http://www.invisibleinc.com/download.cfm?filFilID=6). I need a
Calendar report for job names and it be filled in for a duration of
days, multiple jobs on days. I have a table tith information like
JobName, StartDate, EndDate. Can I create a calendar in access to work
like outlooks?
Can anyone help?
Thanks.
Ben

 

[Duane Hookom]

That was my former employer site and I haven't worked there for almost 5
years. They recently removed all my samples. I have started moving some to
my web site at http://www.access.hookom.net/Samples.htm.

 

[ghoti811]

That was my former employer site and I haven't worked there for almost 5
years. They recently removed all my samples. I have started moving some to
my web site at http://www.access.hookom.net/Samples.htm.

Thanks a bunch Duane.
it is greatly apprecciated.
Ben

 

[ghoti811]

Duane.
I have a question on how to populate the report, do i need code? or how
do i go about that. the reports look great, I am just not sure how to
populate them. is done with a quary? any help would be great. thanks in
advance.
Ben

 

[Duane Hookom]

All of the calendar reports are based on records from tables/queries. These
records were typed or otherwise appended to the tables.

 

[ghoti811]

Thanks for the help. Is it possible to show scheduling over a series of
days?

 

[Duane Hookom]

Isn't that what a calendar report is? If not, you need to be more specific
for this old guy to understand.

 

[ghoti811]

sorry for not being clear. to show the same event on a series of days.
or to show the same event on say every tuesday and thursday for a few
weeks.
this calender ideal is giving me trouble, thanks for the help.
Ben

 

[Duane Hookom]

I have a "recurring" demo at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
allows you to quickly schedule recurring events.

 

[Guest]

Here's an alternate question. Is there a way to flag at date. I'm trying to
create a database to maintain a service schedule for people (not using
outlook). There are three people doing service, one must be the office at
any given time. I want some type of pop up that will warn someone that they
have to choose another time should two of the three already have the same
time periods scheduled.

 

[Duane Hookom]

The recurring sample stores temporary records into a table. You could create
a query that identifies conflicts so you could manually adjust the schedule.