Calendar Seminar - How To Build a Fully Functional Calendar Form and Printable Monthly Report in Microsoft Access


	Back to Calendar Seminar Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Calendar Seminar

Janice Daniels

6 years ago

Hi, I hope somebody can help me.

I am in the middle of the Calendar Seminar, I have added a list box, then when I close the form and re-open it, I get a parameter box showing the following.

Forms!DatePickerF!StartDate

I have checked all spellings in the table, query and forms and everything is OK, so I took the SQL apart and it seems everything works ok until I add +1 at the end of the statement.

Has anyone got any idea why this would happen please. Thanks

	Richard Rost @Reply 6 years ago
It always comes down to spelling. What's the SQL statement?

	Janice Daniels OP @Reply 6 years ago
As I couldn't get it to work, I used your Embedded Calendar and changed all the commands in the list boxes, it was completely messed up and I couldn't get it to work no how so I have deleted the calendar completely from my Database. Are there any instructions how to put your Embedded Calendar into the Monthly Calendar Form? Stay Safe.

	Richard Rost @Reply 6 years ago
Sorry you went through all of that. This Seminar was published over 11 years ago, and I've never had anyone complain that parts didn't work. I don't see any reason why the calendar popup won't work with the monthly form.

	Janice Daniels OP @Reply 6 years ago
Oh well, I will start again from scratch with the Seminar. I love your lessons Janice

	Richard Rost @Reply 6 years ago
Thanks, Janice, and be patient... as I mention in my Beginner 1 class, sometimes after you watch a lesson 2 or 3 times, it starts to make more sense. This is why I usually try to give multiple examples in my normal classes. Seminars not so much because they're more direct and to the point.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Calendar Seminar Lessons.

Next Unseen

New Feature: Comment Live View