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!How do I create a custom form for uploading file in a Document Library?
Hi, I noticed, with much disappointment, that when I set a column to "Require that this column contains information" in a document library, and then when uploading a file, I am not forced to enter metadata but the file simply shows "Required info" in the column. Maybe using a custom form for uploading file I can in some way drive the upload to force the valorization of the required metadata (e.g. disabling "Save" or "OK" button in the form until the required column does not contain a value). Do you think I can succeed to create such a form? Is there somewhere an easy tutorial (suitable for a non-developer person) for creating new form for built-in actions such as "upload file"? Thank you.Public form for Microsoft Lists
Hi there, we use Monday for now, but I have a look on Lists. With Monday, we can have a public form (URL, accessible for everyone. So once someone fills out the form, the data appears as a new item in the list. How do I do that for MS Lists? I figured out, how to customize the form for a new item, when you got access to the list (open the list and hit +New Item). But how can people enter data, without access to the list (not even having a company account) THANKS!
