I have a table of events -
EventID Auto
EventDate Date
EventType Integer ' Social, Sport, Meeting etc
EventDetail Text
I am looking for a calendar routine that will scan this table and colour
those dates that are relevant according to the EventType. Special colour for
more than 1 event on a single date
There will be a main form showing Dates and a subform for the various events
Also click on the calendar to open the form either in the selected date or,
if nothing on that date at a new record
Any ideas
Thanks
Phil 2 2206
Phil,
I do something similar to this to record student attendance.
I started with an "Attendance Calendar" that I downloaded from http:// www.mvps.org/access/resources/downloads.htm .
It color-codes dates of attendance on a monthly calendar form. If the
student is present, the date is green and attendance code in table is
"1", attendance code 2 is red, code 3 is black. In this form, if there
is not already a record for a given date, you click on the date once
and it turns it green and adds a record with attendance code 1 to the
attendance table, click on it twice and it turns it red and adds a
record with code 2, etc. I had to add more codes and colors, so I put
a key on the bottom of the from showing what each color stood for, and
a tally of how many of that code there were in the month. By default
it pulls up the current month's calendar, and you can page up and down
through the months. It is a wonderful way to visually see what's going
on in a month.
The tricky thing for you will be the dates with the multiple events.
HTH
Mary
On Feb 1, 4:42 pm, "Phil Stanton" <p...@stantonfa mily.co.ukwrote :
I have a table of events -
EventID Auto
EventDate Date
EventType Integer ' Social, Sport, Meeting etc
EventDetail Text
I am looking for a calendar routine that will scan this table and colour
those dates that are relevant according to the EventType. Special colour for
more than 1 event on a single date
There will be a main form showing Dates and a subform for the various events
Also click on the calendar to open the form either in the selected date or,
if nothing on that date at a new record
Any ideas
Thanks
Phil
Brilliant Mary.
I expect it will need tweeking, but it's 99% of the way there
Thanks a lot
Phil
"Mary" <mm**********@m sn.comwrote in message
news:11******** **************@ l53g2000cwa.goo glegroups.com.. .
Phil,
I do something similar to this to record student attendance.
I started with an "Attendance Calendar" that I downloaded from http:// www.mvps.org/access/resources/downloads.htm .
It color-codes dates of attendance on a monthly calendar form. If the
student is present, the date is green and attendance code in table is
"1", attendance code 2 is red, code 3 is black. In this form, if there
is not already a record for a given date, you click on the date once
and it turns it green and adds a record with attendance code 1 to the
attendance table, click on it twice and it turns it red and adds a
record with code 2, etc. I had to add more codes and colors, so I put
a key on the bottom of the from showing what each color stood for, and
a tally of how many of that code there were in the month. By default
it pulls up the current month's calendar, and you can page up and down
through the months. It is a wonderful way to visually see what's going
on in a month.
The tricky thing for you will be the dates with the multiple events.
HTH
Mary
On Feb 1, 4:42 pm, "Phil Stanton" <p...@stantonfa mily.co.ukwrote :
>I have a table of events - EventID Auto EventDate Date EventType Integer ' Social, Sport, Meeting etc EventDetail Text
I am looking for a calendar routine that will scan this table and colour those dates that are relevant according to the EventType. Special colour for more than 1 event on a single date
There will be a main form showing Dates and a subform for the various events Also click on the calendar to open the form either in the selected date or, if nothing on that date at a new record
Any ideas
Thanks
Phil
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Andi |
last post by:
Greetings all,
I wish to include an ASP calendar that connects to a back-end MS Access
database on a web page, to be run from my computer (running WinXP Pro, with
IIS5). I have downloaded a free calendar that fits the description from the
internet, and followed the install proceedures included in the
documentation, however when I enable the web site, and navigate to the
folder where the calendar is, instead of loading "default.asp" (the...
|
by: gregory stevenson |
last post by:
I am looking for a calendar program or script to set up calendars for my low
income business based site. I want to put regular events and such. I want
to make it available to most web audiences (so would have to be simple
programming wise). Trying to find a free source that will be easier then
hard coding a table to do the job.
Any ideas?
thanks,
|
by: Mike Stephens |
last post by:
Can someone please point me in the direction of a resource that focuses on
this information. Alternatively, does anyone have any code examples?
Regards,
Mike.
|
by: Filips Benoit |
last post by:
Dear All,
How to store a separated company-calendar for each client-company (about
500).
Company-calendar: workingdays, non-workingdays, meetings, etc.
Thanks,
Filips
|
by: Paul Mendez |
last post by:
I was wondering if there is an add-on or a feature in ms access that I
can create some type of timeline or calendar to track projects that I
have going on within my organization? If I need to create it from
scratch, are there any suggestions on where and how to start?
Thanks
Paul M
| |
by: Antoni Massó Mola |
last post by:
Hi,
I have included the calendar control to a web project. It all works fine,
but I can't jump from one year to another (2004 to 1992). I need to click on
the months at the left side until I reach 1992. Is there a way to jump to a
given year?
Thanks
|
by: Mariano Padilla |
last post by:
I have a form that has 12 Calendar, 1 for each month. I am retrieving
information from a database separately, assigning them to an array and then
in the DayRender Event, itterating through the array to mark the days that I
have in the database for each calendar. Basically a year view of what dates
are blocked and what days are free. Booking calendar.
The problem is that when the page posts back, the first 11, Jan-Nov,
calendars work. ...
|
by: Mariano Padilla |
last post by:
I poste the below on 11-28-05 and got no answer. Could anyone please help me?
I have a form that has 12 Calendar, 1 for each month. I am retrieving
information from a database separately, assigning them to an array and then
in the DayRender Event, itterating through the array to mark the days that I
have in the database for each calendar. Basically a year view of what dates
are blocked and what days are free. Booking calendar.
The...
|
by: federicog |
last post by:
I'm using this calendar: http://www.dynarch.com/projects/calendar/.
I have three calendars on a page, and I need to "link" them together so that if I select a month in one calendar, the two following months are selected in the other two, so that you always get three correlative months in the calendars.
Is that possible somehow?
Also, I need to add a new row at the end of the calendar with an "OK" button to close the calendar, how can I...
|
by: =?Utf-8?B?QXJ0aHVyIFBhcmtlcg==?= |
last post by:
I have been looking for information on creating new custom calendars; not the
control, but the class that manages dates and date calculations. The only
thing I've been able to find in any of the MS documentation or newsgroups is
that you _can_ derive custom calendars from System.Globablization.Calendar,
but not a word on what you would need to do to accomplish that. Has anyone
ever done or seen any custom calendar implementations? I'd...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |