Form to display a calendar of specified stored dates

[Blings]

Thanks for this @davegri. I’m on holiday at the moment, I plan to pick development up again this weekend! I’ll come back ASAP.

[ssanfu]

Here is another Calendar example. In my view, it has issues - I was going to fix them but ended up not using this/a calendar.

There are look up FIELDS, tables missing (3 in this example) and variables not declared correctly

Dim strSQL, strQRY, strSource, strBox, strTxt, strLst As String

(variables supposed to be type string, but are declairedvariant)

The form that is opened when an order is dbl clicked leaves a lot to be desired..... but that can be fixed.

Maybe it will give you some ideas.......

[davegri]

Made some significant enhancements to DB in post#15.

Replaced global variables with TempVars.

Eliminated some UDFs by replacing with built-in functions that MS added to later Access versions.

Eliminated about 300 lines of code addressing the vba Event_Procedures for Got_Focus, Lost_Focus
events for every calendar block. Replaced the 84 Event_Procedures with 2 function calls.

Set tab stops properly.

Made other changes getting rid of redundant or unnecessary code. Added more comments. Code logic should be somewhat easier to follow now.

Calendar-davegri-v04.zip