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 5792
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*****@localh ost.not> a écrit dans le message de news:
a8Eig.713$h46.1 13@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**********@m sn.com> a écrit dans le message de news: 11************* *********@f6g20 00...legro ups.com... 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.
http://www.aspfaq.com/show.asp?id=2023
Now I am facing another problem.
I have to get data between two dates. That dates user has to provide and in
|
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 input of a
start date and an end date.. This table would then contain an entry
for each date in ascending order from the start date to and including...
|
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 dates earlier than today
(which they should't be allowed to do). I've started coding some
validation scripts, but I'm stuck now and my approach...
|
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"?
It is generated from a Unix script that I wrote
<HTML>
<FONT SIZE = 10>
<PRE>
|
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 as datetime
declare @end_date as datetime
set @start_date as '1/1/2005'
set @end_date as '1/1/2006'
| |
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 in an events table and any event may be for
one day or multiple days.
Thanks!
Steve
|
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...
Otherwise, anyone know of a cheap 3rd party calendar control I could use
that would provide that ability?
Thanks,
Rachel
|
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 mode, and then when I select a date on
the calendar control, it should be displayed in the grid's column.
I am not able to retrieve this value from...
|
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 and
highlight thoese two days in the calendar control. Also, I need to
disable all weekends. Is this doable? How do I do this in the
calendar...
|
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...
|
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...
| |
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...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |