Calendar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form to input data that corresponds to specific dates throughout a calendar year. The form's control source is a table within the same database. When data is inputed into the form it is saved on the table. I am trying to create a calendar on a form in Access 2000 that interacts with the same form within the database. The individual dates on the calendar need to be able to open the form to the date specified by the calendar choice.
How can I do this?
 
Hi,

Without knowing all the details if you are using the Microsoft Calendar
Control (ActiveX Control) you can implement something like the following:

Name of Calendar Control: "Calendar0"

Private Sub Calendar0_AfterUpdate()
DoCmd.OpenForm "Name of other Form", acNormal, , "[field in table] = "
& Calendar0
End Sub

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Calendar
| thread-index: AcQJDARGaMg8Zgr+T2iiBkpsOWSqNA==
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
| From: "=?Utf-8?B?REh1Z2hlcw==?=" <[email protected]>
| Subject: Calendar
| Date: Sat, 13 Mar 2004 07:01:08 -0800
| Lines: 2
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:77100
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| I have created a form to input data that corresponds to specific dates
throughout a calendar year. The form's control source is a table within the
same database. When data is inputed into the form it is saved on the table.
I am trying to create a calendar on a form in Access 2000 that interacts
with the same form within the database. The individual dates on the
calendar need to be able to open the form to the date specified by the
calendar choice.
How can I do this?
|
 
Back
Top