![]() ![]() ![]() The following would work for European standards but not for US. Therefore the wrong Weekday number is being returned (4 instead of 6) for the start of the month. However under European dates this is being translated as Jan 2nd. StrFirstOfMonth value (for today) is "" which is fine for US dates and will return the correct Weekday. StrFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)īytFirstWeekdayOfMonth = Weekday(strFirstOfMonth) LblMonth.Caption = MonthAndYear(intMonth, intYear) heheĪt the very least, I can create a simple table and sort it by date and they can look at it that way.īy the way, I don't know VBA code very well, so if you were to be kind enough to help me out, could you please give specific instructions?ĭim strFirstOfMonth As String, bytFirstWeekdayOfMonth As Byte, bytBlockCounter As Byteĭim bytBlockDayOfMonth As Byte, lngBlockDate As Long, ctlDayBlock As Controlĭim bytDaysInMonth As Byte, bytEventDayOfMonth As Byte, lngFirstOfMonth As Longĭim lngLastOfMonth As Long, lngFirstOfNextMonth As Long, lngLastOfPreviousMonth As Longĭim lngEventDate As Long, bytBlankBlocksBefore As Byte, bytBlankBlocksAfter As Byteĭim astrCalendarBlocks(1 To 42) As String, db As Database, rstEvents As Recordsetĭim strSelectEvents As String, strEvent As String, strPlatoons As Stringĭim intMonth As Integer, intYear As Integer, lngSystemDate As Long 'CFB added 1-25-08ĭim ctlSystemDateBlock As Control, blnSystemDateIsShown As Boolean 'CFB added 1-25-08 If I can, they'll think I'm really smart. If I can't figure it out, they'll just have to continue using Outlook. They use Outlook now, but want it in the database. ![]() They also have a vpn, which concerns me because I'm not sure how the database will operate with all that traffic. ![]() Yes, the are on an inter-office network so they all have access to the database. mdb.įor most of these systems I know the users are on a distance and have no access to the. Main question is or all people that need to enter their availability do have access to your. Hmm, your comment triggered for me the thought to incorporate a Webbrowser in a page and have that pointing to the Yahoo (or other) web calendar :-) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |