Access Date Time Picker

Calendar Control Addendum

From

To

> have a field named DateTime.  A reserved word that interferes with VBA and SQL.

You're welcome to rename that Field to whatever you want :)
Just update it wherever it's referenced.

Hello Alex,  Thanks for the info.   I'm a little confused.  According to the Calendar seminar I paid for the new Calendar with the new date picker.  Was there a newer version?

Can you point me to where you saw that so I can check?

The original calendar control was removed, and instead you can just use a textbox with the date picker on the side like the second picture (to).

The Template was something Rich built as an alternative to the original ocx

If you open the Seminar Access Calendar.  You will see two versions Old and New.  The new was the improved version.  Does this help.  From what I can see it is not the one you pointed out.

Hi Bill, first of all, the original Calendar Seminar is fairly old. However, the purpose of that seminar (lime most of my seminars and templates) was not to be a finished final database product that you can just use out of the box. The purpose of it was to show you and teach you how to make a form and report that looks like a printable monthly calendar, which is not something Access does natively. So it's not a finished polished database. The whole purpose is to be a starting point where you can take what I teach you and add it to your database.

Secondly, the database that Alex is showing you is actually the Date Time Seminar, which is different from the calendar seminar. I added a whole bunch of additional forms to pick times in addition to dates. I'm going to go ahead and send you a free copy of that. It has some additional updates in it.

As far as the reserved word "DateTime" goes, that's not one of those that I consider bad reserved words. I have a video coming up on this. It shouldn't cause any problems with Access. In some other database programs it's a no-no, but not in Access.

This is the list of bad reserved words, and the bold ones are really bad ones (see image next)...

"Date" and "Time" are no-nos in Access, but you should be OK with "DateTime" most of the time. (See what I did there?)

Thanks always Richard.  I was trying to do something special with your calendar database.  Ran into problems with SQL and DateTime fields.  I tried changing them to a DateC field.  Wow I did not have any idea how many functions used DateTime in the database.  Thanks again Richard.  Star Trek forever.  Still like the first one best.  I will be very interested in The Date time Seminar.  Thanks again.