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 9 5777
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
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
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
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.
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.
"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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: F |
last post by:
Hi
I have posted the question few days back about problem in inserting the
dates in SQL server and thankful to them who replied.
That was solved and this is a nice solution....
|
by: Christopher M. Pieper |
last post by:
I want to generate a resultset that is just a series of numbers in
ascending order or perhaps a series of dates.. What I mean is, is
there a way to generate a temporary table of dates given an...
|
by: Dale |
last post by:
Hi Everyone,
I've got a form that provides a pop-up calendar for users to select
dates for requesting jobs to be completed. The calendar works great,
but it unfortunately allows users to select...
|
by: Buck Turgidson |
last post by:
The following HTML displays how I want it to, in both MSIE and Mozilla,
howerver, an online validator gives me all sorts of error messages. Can
someone suggest a way to make it more "kosher"?
...
|
by: PromisedOyster |
last post by:
Is there a way that I can get a resultset that contains unique dates in
a given date range without the need to have a temporary table and a
cursor?
perhaps something like:
declare @start_date...
|
by: Steve |
last post by:
Can someone recommend a way to display a one-month calendar view where the month
can be selected and up to six events can be shown in any day of the calendar.
The events and dates would be stored...
|
by: Rachel Suddeth |
last post by:
Is there a way to have the non-selectable dates (those before MinDate and
after MaxDate) draw differently so my users can see right away what dates
aren't allowed? I'm not seeing it...
...
|
by: Nikkie |
last post by:
Hi,
In my asp.net application, I have datagrid control and a calendar control.
The grid has a column for dates. All I want is, when I click on a cell in
that column, the grid comes into edit...
|
by: na |
last post by:
I need to make certain date selectable in a calendar control depending
on records found in a database. For example, if the 10/20/2006 and
11/20/2006 records exist in the database, then only enable...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |