I have some code in my access database file, it is in Visual Basic, what I want from the below code is, instead of hard coded value for the “#1/1/2020#”, I want to get #1//12023# for this year, means first day of the year 2 yrs before, can you please help me, thank you so much.

I have some code in my access database file, it is in Visual Basic, what I want from the below code is, instead of hard coded value for the “#1/1/2020#”, I want to get #1//12023# for this year, means first day of the year 2 yrs before, can you please help me, thank you so much.

I have some code in my access database file, it is in Visual Basic, what I want from the below code is, instead of hard coded value for the “#1/1/2020#”, I want to get #1//12023# for this year, means first day of the year 2 yrs before, can you please help me, thank you so much.

I have some code in my access database file, it is in Visual Basic, what I want from the below code is, instead of hard coded value for the “#1/1/2020#”, I want to get #1//12023# for this year, means first day of the year 2 yrs before, can you please help me, thank you so much.

I have some code in my access database file, it is in Visual Basic, what I want from the below code is, instead of hard coded value for the “#1/1/2020#”, I want to get #1//12023# for this year, means first day of the year 2 yrs before, can you please help me, thank you so much.

I have some code in my access database file, it is in Visual Basic, what I want from the below code is, instead of hard coded value for the “#1/1/2020#”, I want to get #1//12023# for this year, means first day of the year 2 yrs before, can you please help me, thank you so much.

I have some code in my access database file, it is in Visual Basic, what I want from the below code is, instead of hard coded value for the “#1/1/2020#”, I want to get #1//12023# for this year, means first day of the year 2 yrs before, can you please help me, thank you so much.

I have Microsoft Office Professional Plus 2021 on my laptop.
I am the admin and the only person that uses it.
Access has begun acting strangely.
When I exit out of the application, it closes the window but does not completely close Access.
I tracked it down to this code in the form_load of my main form

I want to run a code everytime I delete/add a record in the subform. I need to know the amount of records there are in the subform after delete/add event.

I need to get the amount of records of a Report (RecordCount) in the OnOpen event. if there’s no record, I need to display a message to the user and close the report.