MS Access Calendar

[Dalia Allencher]

Can you tell me how the query 'qrypatients' is connected to the form 'calendar'?

[ADezii]

Could you please tell me how the calendar is connected to the table/query?

Look at the Code in the PopulateCalenda r() Event in the Code Module of frmCalendar.

[Dalia Allencher]

Thank you for the quick response.

I'm using the calendar given in the path: http://www.access-programmers.co.uk/...=103747&page=2

You can see a zip file here: Input2000.zip

This calendar suits my need becuase I need to print the calendar in Outlook format and paste it on wall.

I looked into the code module of this calendar, but I couldn't find PopulateCalenda r().Could you please help me to find out how the calendar form is connected to the table 'tblInput'?

[ADezii]

@Dalia - PoulateCalendar () is in the Code Module of frmCalendar.

[Teddis]

Hi ADezii,

I saw that you have done a really good job, this is pretty impressive and it works!
I would like to us this calendar but I just noticed a problem: the dates in the calendar are wrong, for example the 9th of may is a thursday but is meant to be a monday. I noticed that there are several problem like the 31st of January is a monday and the 1st of february is a sunday, same problem between the month of May and June 2011. I looked through your code but I don't know how to solve this.
Can you tell me where the problem is from and how to solve it?

Thanks a lot,

[ADezii]

I double checked the Calendars, and the Dates appear to be in sync. Where, exactly, do you live, country wise?

[Teddis]

Wrong date

I am in Sydney Australia. The time in the upper part of the window is right, it shows the right and it matches with my computer's time.
Just the display of the days are wrong.

Attache is a screenshot of the calendar.

[imgnothumb]http://bytes.com/attachments/attachment/5138d1304945990/screenshot.jpg[/imgnothumb]

[ADezii]

In the PopulateCalenda r Sub-Routine, swap Code Lines 3 and 8:

1. Current Code State:
   

   '*********************** Code intentionally omitted **********************
   
   strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)
   
   '*************************************************************************
     'ADezii
     'NOTE: Will work in the UK (United Kingdom) and other European Nations
     'strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)
   '*************************************************************************
   
   '*************************************************************************

2. Change to:
   

   '*********************** Code intentionally omitted **********************
   
   'strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)
   
   '*************************************************************************
     'ADezii
     'NOTE: Will work in the UK (United Kingdom) and other European Nations
     strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)
   '*************************************************************************
   
   '*************************************************************************

[Teddis]

Thanks!

That was easy, the date is right now.

Cheers for your help,

[NeoPa]

Would it be appropriate to suggest that the date format could be determined in the code by referring to the following Registry key? :

HKEY_CURRENT_USER\Control Panel\International\sShortDate

Module to Read From the Windows Registry may help if you need it.

[NeoPa]

Due to the size of this thread, it has been closed to posting until we can sort something out.

ADezii, you can get in touch with me if you want to post something here.

Anybody else, please be patient until we get this issue resolved.