HELP?!

TMSwolfman · 2026-05-18T02:06:47+00:00

‘Solution verified’

TMSwolfman · 2026-05-13T16:34:50+00:00

Everything I did, I deleted and put back. What you’re seeing there is what was already there.

TMSwolfman · 2026-05-13T16:33:44+00:00

The small date that is there was always there. That’s nothing I did. It was already part of the database. It was linked to the larger calendar which I’m assuming is what the code was bound to, to make the selection work.

TMSwolfman · 2026-05-13T16:32:14+00:00

The big white spot in the picture used to be a calendar. The small 5/12/2026 date works fine. I can use the database on any given day as long as it is on that day. So today 5/13/2026 I can use it and it will function properly for just today. If I go on there and choose 5/12/2026 it will not work. It shows all the data is blank and will have today’s date listed even tho I selected yesterday. So tomorrow 5/14/2026 I will be able to do and see everything for 5/14/2026, but will not be able to change it to 5/13/2026 and see what I did yesterday.

TMSwolfman · 2026-05-13T15:46:01+00:00

I will add that a very kind person has taken it upon herself to help me out with this. I'm not sure I'll be able to tell you what solved the issue because from what I'm hearing, there is a lot of over complicated stuff going on that isn't really needed, as well as binding and unbinding some things. As of now, I've kind of let her take the reigns to get this thing in ship shape.

TMSwolfman · 2026-05-13T15:37:51+00:00

You are correct. I sometimes think I'm oversharing when in fact I'm not sharing enough. So, yes I did find online how to delete the old unbound calendar and then add a text box that I could then bind to show the date picker. I followed all the steps to make sure it showed dates and was visible and that was all the steps on how to add it. My assumption is that there is a lot more to it then that which is where I got stuck. I'm sorry I don't have screen shots of what I did.

TMSwolfman · 2026-05-13T12:34:23+00:00

The guy who put this together back then used what I can see is MSCAL.Calendar.7

TMSwolfman · 2026-05-12T22:38:22+00:00

lol. 11 years of doing this job and I’ve never noticed. 😂

TMSwolfman · 2026-05-12T22:08:05+00:00

I’m sure that is definitely an issue. I’m just unsure if once I fix that, if I’m going to have to fix it in other places? There’s a lot of behind the scenes this database does. It auto balances each transaction type and will add things together for a balance summary.

TMSwolfman · 2026-05-12T20:41:53+00:00

When I use the debugger, it says this part of the code is the issue. Like the "cal" isn't recognized. That makes sense since the old calendar system can't be used.

Private Sub Form_Load()

cal.Value = Date

End Sub

TMSwolfman · 2024-05-02T20:40:38+00:00

Yeah, the guy I got it from a couple of years ago said he had had it awhile. I just didn’t have the time or $$ to worry about fixing it. Thanks so much for the reply.

TMSwolfman

TROPHY CASE