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 Instead of Format, I've tried using the code Day(Me.txtSelectDate), but that didn't work either. It always defaults to the day of the month that's today. Can anyone tell what I'm doing wrong? I've checked the formatting, and everything is set to 'Short Date'... I'm just at a complete loss! Any help is greatly appreciated!
Yet Another Conditional Formatting Query
Hey folks, I have an SP list with 3 relevant columns - IssueDate, ReviewFrequency, and NextReview. IssueDate is for manual date entry, ReviewFrequency is a choice of N/A, 3, 6, 12, 24, 36. NextReview is a calculated column that adds number value in ReviewFrequency to IssueDate. I have applied JSON formatting in Format View to format rows where NextReview is less than today (@now) in sp-field-severity--severeWarning, rows where next review is due within 30 days (2592000000ms) in sp-field-severity--Warning, and all other rows in alternating sp-css-backgroundColor-BgLightGray30 and sp-css-backgroundColor-noFill (giving zebra alternate banding). All works well apart from an issue with dates being read by conditional formatting as MM-dd-yyyy not dd-MM-yyyy as illustrated here: How do i ensure dates in the columns are seen / interpreted as dd-MM-yyyy in the conditional formatting rules? Thanks in advance,
How to create a rolling calculated column in sharepoint list
Hi- first time posting here, and new to sharepoint. I have a sharepoint list in which i have some basic calculating columns totaling hours and units worked on a day's shift per employee. I was looking for some insight, if a calculated column could be made using a rolling time calculation for instance towards a payroll date. This will allow me to group all entries by a pay date. payroll is sent out on the 15 & 30th of every month. I plan to have this sharepoint list as a data source into power bi & /or excel i can easily group the employee's total per pay period and have it vlookup again a payment table. However if i can group by a payment period that would greatly impact my over all goal. Thank you for taking to time to review my question Drew Westman
Date filtering of Bing Searches
I have become extremely reliant on being able to filter out or on searches by date. Often there are posts that are days, months, years old that are not relevant in both I want data that is old or I just want the most recent. Currently, there is a default window set that can be used consiting of less than a day, week or month old. While that is great for some statistics and data mining it is just not good enough for research. This lack of capability forces me to go back to Google to find pertinent data associated with a period. I was even envisioning a tag team capability where Bing mines the gross data and Edge Dev provides an interface to refine the data, maybe even manipulate it. I would think that seeding Bing would provide a better set of raw material. What does anyone else think?Date Interval - get each day´s date for a flow run?
I have a problem with how i use a flow. My users report a start date and an end date to a sharepoint list. Then i post a reminder of todays events and tomorrows event into Teams. But if the user have entered a date interval of 3 days, the flow only picks up the startdate column data. How can i force sharepoint to create a row for each day in the date interval? For example, user answer my Microsoft Forms and enters startdate and enddate of their event. but then i want to remind in teams about this event every day, not just at the start-date. I want a reminder each day. So if the date-interval is 10 days i want one reminder every day. How to get the date for each day in flow? Or if i could build a flow that breaks down a date interval and adds a row for each interval and use that list to pick out reminders like i do today. Acutally that would be the best solution, i got the reminder flow running now, it works fine. If i just could point that flow to a list containing all dates in a date column, it all would be solved. How to break down a ten day interval so that each day get it´s own row startdate, date2, date3....date9, date10 (one for each row).
Date Calculator / Seasonal rates
Hello. I am trying to figure out how to make a simple calculator for my apartment that I rent out. The rent amount is seasonal. I would like to be able to just enter a start date and an end date, and end up with a total cost (which factored in the varying seasonal rates). The seasonal rates are fairly simple as they are based by the month. Any feedback or direction is greatly appreciated.
