PC Review


Reply
Thread Tools Rate Thread

Access Calendar Control

 
 
=?Utf-8?B?Sm9l?=
Guest
Posts: n/a
 
      2nd Mar 2006
I would like to extract the day from the calendar control to a form.


 
Reply With Quote
 
 
 
 
PC Datasheet
Guest
Posts: n/a
 
      2nd Mar 2006
Install the calendar control on a popup form named PFrmCalendar. Name the
calendar control My Calendar. I will assume the name of the Date field on
your form is MyDate.
Put the following code in the Click event of the calendar control:
Me.Visible = False
Put the following code in the click event of a button on your form:
DoCmd.OpenForm "PFrmCalendar",,,,,acDialog
Me!MyDate = Forms!PFrmCalendar!MyCalendar.Value
DoCmd.Close acForm, "PFrmCalendar"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1125 users have come to me from the newsgroups requesting help
(E-Mail Removed)




"Joe" <(E-Mail Removed)> wrote in message
news:47B183B7-D180-44D3-9E05-(E-Mail Removed)...
>I would like to extract the day from the calendar control to a form.
>
>



 
Reply With Quote
 
StopThisAdvertising
Guest
Posts: n/a
 
      2nd Mar 2006

"PC Datasheet" <(E-Mail Removed)> schreef in bericht news:nxCNf.5304$(E-Mail Removed)...

--
> PC Datasheet
> Your Resource For Help With Access, Excel And Word Applications 'Resource ????
> Over 1125 users have come to me from the newsgroups requesting help '1125 users ????
> (E-Mail Removed)
>
>


--
To Steve:
Over 440 users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R
 
Reply With Quote
 
=?Utf-8?B?TWlrZUpvaG5C?=
Guest
Posts: n/a
 
      2nd Mar 2006
See

http://allenbrowne.com/ser-51.html

One of the simplest versions I have seen

Also Steven Labans Site has a good calendar but a little more programming
required

"Joe" wrote:

> I would like to extract the day from the calendar control to a form.
>
>

 
Reply With Quote
 
=?Utf-8?B?Sm9l?=
Guest
Posts: n/a
 
      2nd Mar 2006
I have the calendar control in the form. When i click on a new day on the
calendar i have a box which tells me the date selected.
Is there a way which when i click on a new day i can have a box in the form
which says what day has been selected?

Thanks

"MikeJohnB" wrote:

> See
>
> http://allenbrowne.com/ser-51.html
>
> One of the simplest versions I have seen
>
> Also Steven Labans Site has a good calendar but a little more programming
> required
>
> "Joe" wrote:
>
> > I would like to extract the day from the calendar control to a form.
> >
> >

 
Reply With Quote
 
James A. Fortune
Guest
Posts: n/a
 
      2nd Mar 2006
Joe wrote:
> I have the calendar control in the form. When i click on a new day on the
> calendar i have a box which tells me the date selected.
> Is there a way which when i click on a new day i can have a box in the form
> which says what day has been selected?
>
> Thanks
>
> "MikeJohnB" wrote:
>
>
>>See
>>
>>http://allenbrowne.com/ser-51.html
>>
>>One of the simplest versions I have seen
>>
>>Also Steven Labans Site has a good calendar but a little more programming
>>required
>>
>>"Joe" wrote:
>>
>>
>>>I would like to extract the day from the calendar control to a form.
>>>
>>>


For the calendar control that comes with Access 97, here is what I do:

http://groups.google.com/group/comp....64d683ede98f8c

James A. Fortune
(E-Mail Removed)

Our business is to establish peace and order on a satisfactory basis,
start the new government, and then leave the Island; the Cuban
Government taking the reins into its own hands; tho of course it might
be advisable for some little time that some of our troops should stay
in the Islands to steady things.


--- Theodore Roosevelt 1907
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calendar Control works in Access 2003 but not Access 2007 kware100 Microsoft Access 5 15th Sep 2009 03:35 PM
Access Calendar Control katz Microsoft Access Forms 1 7th Sep 2006 03:18 AM
Calendar Control in Access Project in Access 2002 =?Utf-8?B?VG9t?= Microsoft Access Form Coding 0 18th May 2006 05:41 PM
Calendar Control In Access =?Utf-8?B?VHJpbmkgR2Fs?= Microsoft Access Forms 5 7th Jul 2005 04:43 PM
Cannot set value of calendar control in Access 97 Kirk Speen Microsoft Access Form Coding 6 17th Oct 2003 09:20 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:10 PM.