469,621 Members | 1,696 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

Display several dates on a calendar


Hi,

I have a table with "dates", i'd like to display those dates on a calendar.
I've put a calendar in a form, linked to my "date" field, and it works, but
only showing one "date" per calendar.
I can see all "dates" moving to next records, but one per calendar. :-(

Ex: 17/06 on one claendar, then if i click on next record, I can see my
calendar with 24/06 ...etc ...

How can I do to have all the recorded "dates" of a month on the same
calendar ?

Tks.
Regards.

Greg

Jun 10 '06 #1
9 5596
How is the table laid out? From your description you could have a nicely
laid-out normalized relational table or you could have a messy,
many-dates-per-record flat file implemented in Access.

Larry Linson
Microsoft Access MVP

"Greg" <gr**************@wanadoo.fr> wrote in message
news:44**********************@news.orange.fr...

Hi,

I have a table with "dates", i'd like to display those dates on a
calendar.
I've put a calendar in a form, linked to my "date" field, and it works,
but
only showing one "date" per calendar.
I can see all "dates" moving to next records, but one per calendar. :-(

Ex: 17/06 on one claendar, then if i click on next record, I can see my
calendar with 24/06 ...etc ...

How can I do to have all the recorded "dates" of a month on the same
calendar ?

Tks.
Regards.

Greg

Jun 10 '06 #2
Just thought that you will need some other 'calendar' or need to change the current one.
But for now I stopped to think about it... I find your multi-posting a bad idea ...

Good luck,
Arno R
"Greg" <gr**************@wanadoo.fr> schreef in bericht news:44**********************@news.orange.fr...

Hi,

I have a table with "dates", i'd like to display those dates on a calendar.
I've put a calendar in a form, linked to my "date" field, and it works, but
only showing one "date" per calendar.
I can see all "dates" moving to next records, but one per calendar. :-(

Ex: 17/06 on one claendar, then if i click on next record, I can see my
calendar with 24/06 ...etc ...

How can I do to have all the recorded "dates" of a month on the same
calendar ?

Tks.


Regards.



Greg


Jun 10 '06 #3
It's an access table with several kind of data, including one unique date
field.

I's a table for my music band concerts :
Each record including : date, place, zipcode, and the reference number of
the client (to link to my client's table)

There's one unique date per record, and no records can have the same date.

In access, I can print a clean list from the table, but I'm unable to
dysplay the list in a calendar (or i'll need one calendar per day !)

So, is it possible to display several dates in a calendar ?

Many thank's

GReg
"Larry Linson" <bo*****@localhost.not> a écrit dans le message de news:
a8Eig.713$h46.113@trnddc07...
How is the table laid out? From your description you could have a nicely
laid-out normalized relational table or you could have a messy,
many-dates-per-record flat file implemented in Access.

Larry Linson
Microsoft Access MVP

"Greg" <gr**************@wanadoo.fr> wrote in message
news:44**********************@news.orange.fr...

Hi,

I have a table with "dates", i'd like to display those dates on a
calendar.
I've put a calendar in a form, linked to my "date" field, and it works,
but
only showing one "date" per calendar.
I can see all "dates" moving to next records, but one per calendar. :-(

Ex: 17/06 on one claendar, then if i click on next record, I can see my
calendar with 24/06 ...etc ...

How can I do to have all the recorded "dates" of a month on the same
calendar ?

Tks.
Regards.

Greg


Jun 10 '06 #4
Arno R wrote:
Just thought that you will need some other 'calendar' or need to change the current one.
But for now I stopped to think about it... I find your multi-posting a bad idea ...

Good luck,
Arno R
"Greg" <gr**************@wanadoo.fr> schreef in bericht news:44**********************@news.orange.fr...
Hi,

I have a table with "dates", i'd like to display those dates on a calendar.
I've put a calendar in a form, linked to my "date" field, and it works, but
only showing one "date" per calendar.
I can see all "dates" moving to next records, but one per calendar. :-(

Ex: 17/06 on one claendar, then if i click on next record, I can see my
calendar with 24/06 ...etc ...

How can I do to have all the recorded "dates" of a month on the same
calendar ?

Tks.
Regards.

Greg



I solved this by using Moxilla's calendar program, and making Access
save a text file using the calendar's native format, (it's unobfuscated)
then launching the calendar.
Jun 10 '06 #5
Tks for trying.

But I 'm trying to do it in access, offline. simply.

Tks your help.
G

"news.shaw.net" <ad***@null.net> a écrit dans le message de news:
L7Fig.5056$iF6.4253@pd7tw2no...
Arno R wrote:
Just thought that you will need some other 'calendar' or need to change
the current one.
But for now I stopped to think about it... I find your multi-posting a
bad idea ...

Good luck,
Arno R
"Greg" <gr**************@wanadoo.fr> schreef in bericht
news:44**********************@news.orange.fr...
Hi,

I have a table with "dates", i'd like to display those dates on a
calendar.
I've put a calendar in a form, linked to my "date" field, and it works,
but
only showing one "date" per calendar.
I can see all "dates" moving to next records, but one per calendar. :-(

Ex: 17/06 on one claendar, then if i click on next record, I can see my
calendar with 24/06 ...etc ...

How can I do to have all the recorded "dates" of a month on the same
calendar ?

Tks.
Regards.

Greg



I solved this by using Moxilla's calendar program, and making Access save
a text file using the calendar's native format, (it's unobfuscated) then
launching the calendar.

Jun 10 '06 #6
"Greg" <gr**************@wanadoo.fr> wrote
It's an access table with several kind of data, including one unique date
field.

I's a table for my music band concerts :
Each record including : date, place, zipcode, and the reference number of
the client (to link to my client's table)

There's one unique date per record, and no records can have the same date.

In access, I can print a clean list from the table, but I'm unable to
dysplay the list in a calendar (or i'll need one calendar per day !)

So, is it possible to display several dates in a calendar ?


Access' reporting handles "banded" reports with different sections (lines or
groups of lines) very well, very simply, and very easily. If you want some
other arrangement, you may have to be "inventive" or you may be "out of
luck."

If you want a _standard wall calendar arrangement_, with days of the week
across and one row per week, I'd guess you could do that with a Subreport
for the month and an across-then-down multicolumn layout. But, that wouldn't
leave much room for a list in each date.

I've been giving some thought to a report for a "pocket calendar" about a
quarter-sheet of letter-size paper per page, with the list on the following
page, but I'm "not quite there" in figuring out how to do it. Perhaps that
would work for you... a calendar page for the dates, perhaps color-coded,
and then the facing page for the list or schedule? If you didn't have to be
concerned about printing them so the pages could be cut and folded in a
particular order, it'd be a lot simpler.

Larry Linson
Microsoft Access MVP
Jun 11 '06 #7

Greg,

I don't know if this will help, but it may:

There is an "attendance calendar" access db that you can download at:
http://www.mvps.org/access/resources/downloads.htm.

It color codes dates of attendance on a calendar that is created with
VBA code . If just highlighting the dates is what you need, I think you
could easily modify this to suit your purposes.

Mary

Jun 11 '06 #8
THANK YOU MARY !

It seems I can do something out of it !

:-)

Thank's again.

Greg
"Mary" <mm**********@msn.com> a écrit dans le message de news:
11**********************@f6g2000cwb.googlegroups.c om...

Greg,

I don't know if this will help, but it may:

There is an "attendance calendar" access db that you can download at:
http://www.mvps.org/access/resources/downloads.htm.

It color codes dates of attendance on a calendar that is created with
VBA code . If just highlighting the dates is what you need, I think you
could easily modify this to suit your purposes.

Mary

Jun 11 '06 #9

You're welcome. Glad to have helped. I modfied this code to track
attendance for a school I work for and thought it was pretty cool.

Mary Kay

Jun 11 '06 #10

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Christopher M. Pieper | last post: by
4 posts views Thread by Dale | last post: by
5 posts views Thread by Buck Turgidson | last post: by
24 posts views Thread by PromisedOyster | last post: by
7 posts views Thread by Steve | last post: by
2 posts views Thread by Rachel Suddeth | last post: by
5 posts views Thread by na | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.