Access selecting specific date on a calendar
I'm pulling my hair out because everything I've found through my research says my VBA code should work, but it doesn't! Here's the story. I have a calendar (form) that shows events going on for each month. What I want is for a person to click on a specific day and have a pop-up form appear showing more details of the events for whatever day they clicked on. I used the below code, which mostly works... When I click on a date, the month and year will be correct, but not the day of the month. The day of the month is always today's day. For example, let's say I click on the day Feb. 2, 2024 and today's date is May 21, 2026. My pop-up form will show the events for Feb. 21, 2024. This is the code I have: Private Sub lblTue3_Click() Dim txtSelectDate As Date (probably don't need this) Dim iDayOfMonth As Integer Dim iMonth As Integer Dim iYear As Integer Dim dSelectDate as Date iDayOfMonth= Format(Me.txtSelectDate.Value, "d") iMonth = Format(Me.txtSelectDate, "mm") iYear = Format(Me.txtSelectDate, "yyyy") dSelectDate = CDate(iMonth & "/" & iDayOfMonth & "/" & iYear) DoCmd.OpenForm "frmThatContainsMyData", acNormal, , "[DateOnFormUsedForFilter]=#" & dSelectDate & "#", , acDialog Update: I think I figured out where the problem is. When the calendar form is loaded, that's where txtSelectDate is defined. However, I don't know how to define txtSelectDate to whatever date I click on in the calendar. It defaults to today's date when I load the form. When I change the month or year, those number change in the txtSelectDate box, but not the day. This is the code I currently have. (DisplayMonthName displays the month and year; don't think it's part of my issue) Private Sub Form_Load() Me.txtSelectDate = Date Call DisplayMonthName End Sub Any help is greatly appreciated!
Attachement date of outlook classic
when i download the attachment from old email, the date of the file, should be today date, but that doesn't happen, it appears the old date of when it was created. In a big folder of downloads i cant find it. This happens in outlook 365, outlook 2016 and Outlook 2024 classic with email 365 account. But in Outlook 2019 classic works perfectly it sava with today date. Should be some configuration?
Wrong completion date: after Ctrl+D, the task's completion date turns a day earlier than curr.date
Hi, everybody! I have an annoying issue - well, I thinks is a bug. When I check a task as ended (Ctrl+D on keyboard), the completion date is wrong. Look at it: Can you help to solve that? Best regards, Marcela.
Calculate date based on current years week number and specific week day
Hi, Is there any way to, in a sharepoint list, calculate a date based on 2 columns containing (1)current years week number and (2)a specifik week day. Current year=2023 Column1: 28 Column2: Tis (Tuesday) The calculated date for current year would be 11072023 (DDMMYYY). This is for a planning tool, presented in powerapps, where a great deal of the events repeats every year. In order for me to highlight events in future I need a date. I was able to do it in PowerApps (calculate date based on said columns) but I have problem using/reaching that date more than presenting it, if I had that date in a column from the data source I thought it would be easier.Windows 10 v1909 (19042.1586) Missing Set time zone automatically
A user who recently traveled requested that we setup Windows so that the time zone would update automatically the next time she traveled. In checking our machines (Win 10 v1909 19042.1586) we're noticing that the "Set time zone automatically" option in Settings > Time & Language > Date & Time is missing. Was this feature removed in some version of Windows? If yes, which version and where is it documented? If no, Any thoughts as to why it might be missing? I checked this article "https://docs.microsoft.com/en-us/troubleshoot/windows-client/shell-experience/cannot-set-timezone-automatically" but my "Start" value is already set to "3" and "Value" is already set to "Allow".
Training System
I created the training booking system using Sharepoint List with date selection. I wanted on each day, once the number of booking reached to 20 Message will appear that is session is full you can register the training other days. With limitation of Weekends. Any Validation formula, Presave JavaScript. Thanks In advance.Booking System - SharePoint
I created a Booking System using List of Sharepoint, the requirments are as follow Booking Date: This is set to select the desire Date but not today Date or Past Date "I added the Enforce unique values and add the Column validation for it =[Booking Date]>TODAY() with the message to appear as "The date entered cannot be today or in the past." Booking Time: This is set as (Dropdown List) Morning: 07:00am-03:00pm Evening: 04:00pm -11:30pm All day: 07:00am- 11:30pm Now the requirement is If someone wanted to book Lets say on 31-12-2021 can able to book Morning and if someone/Same Person wanted to book on same day evening time can be done but the Uniqe Value of booking date is the issue, it dont allow double booking and if i removed this uniqe value then many ppl can book at same Day and time. And if someone click one All Day even then no one can book Morning and Evening. If anyone knows how please support, Validation or Java Script. Kindly provide the full details im new to this please. Thanks Inadvance.Feature Request: Show date marked complete in to-do.office.com
I primarily use the online version of To Do and would like to be able to view when the Tasks were marked complete. This would make creating weekly status reports much easier and also better for that occasional "when was X done\finished\completed" question.
